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.
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.