Issue 122: Connection Error - Connecting to MSSQL 2005
Status:  Complete
Owner: ----
Closed:  Nov 2010
Reported by opm...@gmail.com, Sep 22, 2010
What steps will reproduce the problem?
1. import pyodbc
2. db = pyodbc.connect('DRIVER={SQL Native Client};SERVER=192.168.1.103;DATABASE=vpmser;UID=massEmailer;PWD=password')
3. gives the error: Error: ('IM002', '[IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0) (SQLDriverConnectW)')

What is the expected output? What do you see instead?
I am meant to connect so the user can choose a variety of different commands, all select statements

What version of the product are you using? On what operating system?
Using the latest pyodbc, running python 2.7, on windows XP, coded in PyScripter and being run from PyScripter

Please provide any additional information below.


Nov 21, 2010
Project Member #1 mkleehammer
It appears that {SQL Native Client} only works if SQL Server 2005 has been installed.  I have a test box with only SQL Server 2008 and it does not work there either.  I will update the Wiki.

If you have 2008, you'll need to use {SQL Server Native Client 10.0}.  Microsoft really has lost their way.

Status: Complete