Issue 144: Unable to find pyodbc compatible DB2 driver for Windows 2008 64 bit OS
Status:  NoFix
Owner: ----
Closed:  Feb 2011
Reported by mail2ba...@gmail.com, Dec 16, 2010
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


Dec 20, 2010
#1 lukedell...@gmail.com
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)
Feb 27, 2011
Project Member #2 mkleehammer
(No comment was entered for this change.)
Status: NoFix