Python - Linux - Connecting to MS SQL with Windows Credentials - FreeTDS+UnixODBC + pyodbc or pymssql

Question

There doesn't seem to be any great instructions for setting this up. Does anyone have any good instructions? I am a linux noob so be gentle. I did see another post that is similar, but no real answer.

I have a couple of problems.

FreeTDS doesn't "seem" to be working. I am trying to connect and I get the following message using the "tsql" command: "Default database being set to databaseName There was a problem connecting to the server" but it doesn't mention what the problem is.
1. The error I get when I try to connect using pyodbc is: "pyodbc.Error: ('08S01', '[08S01] [unixODBC][FreeTDS][SQL Server]Unable to connect: Adaptive Server is unavailable or does not exist (20009) (SQLDriverConnectW)')"
2. I tried something similar with pymssql, but I ran into similar issues. I keep getting errors that I can't connect, but it doesn't tell me why.

It seems pretty amazing that there isn't any clear cut solution to this. — Keith P
– Keith P, Commented Jul 6, 2010 at 21:08
I guess it is because nobody was able to reproduce your problem. You might have to do further analysis on your system, such as setting up an empty "dummy" MSSQL database and checking whether the issue is still there. Then, provide a summary on what exactly your test setup is composed of. That way, others could spot issues in your setup, or try a similar setup on their own machines. — vog
– vog, Commented Aug 26, 2010 at 9:54

Michaelnt · Accepted Answer · 2010-08-22 14:28:04Z

2

The following works if you configure the MS SQL server to allow remote TCP/IP connections and have an appropriate user to connect as.

You also need to be careful to set up the correct hostname for the db as reported by MS SQL.

import pymssql
connection = pymssql.connect(
            user = 'username', 
            password = 'password', 
            host = 'server', 
            database = 'database',
        )
cursor = connection.cursor()
cursor.execute('select * from db;')
rows = cursor.fetchall()

answered Aug 22, 2010 at 14:28

Michaelnt

1664 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

kermatt · Accepted Answer · 2011-06-18 19:19:05Z

1

When building FreeTDS (http://www.freetds.org/userguide/config.htm):

./configure --with-tdsver=8.0 --enable-msdblib

edited Jun 18, 2011 at 19:19

answered Jun 16, 2011 at 21:23

kermatt

1,7122 gold badges18 silver badges36 bronze badges

Comments

ayaz · Accepted Answer · 2010-10-25 18:22:39Z

0

That error suggests that the TDS version is not set right. You can set that in the configuration setting for FreeTDS. You don't mention which MSSQL version you are using. But, if you are using say 2005, setting 8.0 as the TDS version will work.

answered Oct 25, 2010 at 18:22

ayaz

10.5k6 gold badges37 silver badges49 bronze badges

Collectives™ on Stack Overflow

Python - Linux - Connecting to MS SQL with Windows Credentials - FreeTDS+UnixODBC + pyodbc or pymssql

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related