search

djhenderson / pyodbc

Automatically exported from code.google.com/p/pyodbc
MIT No Attribution
0 stars 0 forks source link

Connection Error - Connecting to MSSQL 2005 #122

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
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.

Original issue reported on code.google.com by opm...@gmail.com on 23 Sep 2010 at 1:43

GoogleCodeExporter commented 9 years ago 
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.

Original comment by mkleehammer on 21 Nov 2010 at 5:27