python ODBC issue

[GoogleCodeExporter]

What steps will reproduce the problem?
1.  easy_install  ibm_db-1.0.4-py2.6-win32.egg
2.  configured DB2 in windows ODBC and tested it...  works

connection tested successfully

3.  Python 2.6.6 (r266:84297, Aug 24 2010, 18:46:32) [MSC v.1500 32 bit 
(Intel)] on
win32
Type "help", "copyright", "credits" or "license" for more information.
>>> import pyodbc
>>> cnxn = pyodbc.connect('DRIVER={IBM DB2 ODBC DRIVER - DB2COPY1};DATABASE=SODA
;UID=db2inst1;PWD=xxxx')
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
pyodbc.Error: ('08001', '[08001] [IBM][CLI Driver] SQL1013N  The database alias
name or database name " " could not be found.  SQLSTATE=42705\r\n (-1013) (SQLDr
iverConnectW)')
>>>

What is the expected output? What do you see instead?

C:\Documents and Settings\Administrator>python
Python 2.6.6 (r266:84297, Aug 24 2010, 18:46:32) [MSC v.1500 32 bit (Intel)] on
win32
Type "help", "copyright", "credits" or "license" for more information.

What version of the product are you using? On what operating system?

windows XP
Please provide any additional information below.

Original issue reported on code.google.com by mat...@us.ibm.com on 13 Jul 2011 at 3:12

[GoogleCodeExporter]

you have installed the correct package, but instead importing ibm_db or 
ibm_db_dbi you have imported pyodbc.

so, try with importing ibm_db or ibm_db_dbi and let me know it works for you or 
not.

Original comment by rahul.pr...@in.ibm.com on 14 Jul 2011 at 6:53

• Added labels: Type-Other
• Removed labels: Type-Defect

[GoogleCodeExporter]

Original comment by rahul.pr...@in.ibm.com on 14 Jul 2011 at 6:54

[GoogleCodeExporter]

Original comment by rahul.pr...@in.ibm.com on 16 Apr 2012 at 8:46

• Changed state: Done