My favorites | Sign in
Project Home Downloads Wiki
READ-ONLY: This project has been archived. For more information see this post.
Search
for
  Advanced search   Search tips   Subscriptions
Issue 144: Unable to find pyodbc compatible DB2 driver for Windows 2008 64 bit OS
1 person starred this issue and may be notified of changes. Back to list
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

Powered by Google Project Hosting