search

djhenderson / pyodbc

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

Unable to find pyodbc compatible DB2 driver for Windows 2008 64 bit OS #144

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1.Python 2.7 (python-2.7.1.amd64.msi) 
2.pyodbc-2.1.8.win-amd64- py2.7.exe
3. python script to connect to DB2 database

What is the expected output? What do you see instead?
Expected :Successfully connect to Database and retrieve data from employee table
Instead it results in following error
pyodbc.Error: ('IM002', '[IM002] [Microsoft][ODBC Driver Manager] Data source 
name not found and no default driver specified (0) (SQLDriverConnectW)') 

What version of the product are you using? On what operating system?
Python 2.7, pyodbc-2.1.8, Windows 2008 64 bit OS

Please provide any additional information below.
I have searched extensively on Google but Unable to find pyodbc compatible DB2 
driver for Windows 2008 64 bit OS. Please let me know where to find compatible 
DB2 driver and how to configure/load the driver thru the script

Original issue reported on code.google.com by mail2ba...@gmail.com on 16 Dec 2010 at 2:23

GoogleCodeExporter commented 9 years ago 
You should just need the standard ODBC driver for DB2, no need to look for 
"pyodbc compatible" endorsement.  A quick search on the IBM website brought me 
to the following download page which offers an ODBC driver for DB2:
http://www-01.ibm.com/support/docview.wss?rs=4020&uid=swg21385217 (seems to 
require registration to download)
BTW let's keep support requests in the forum so that the issue tracker can be 
reserved for tracking bugs in pyodbc.
(disclaimer: I am just a fellow user, not a pyodbc dev)

Original comment by lukedell...@gmail.com on 20 Dec 2010 at 10:55

GoogleCodeExporter commented 9 years ago

Original comment by mkleehammer on 28 Feb 2011 at 12:35