I downloaded Python 2.7 (python-2.7.1.amd64.msi) and pyodbc the python
extension module (i.e. pyodbc-2.1.8.win-amd64-py2.7.exe)

I wrote a sample script as shown below to connect to database

import csv
import pyodbc
conn =
pyodbc.connect("Driver={db2};Database=TEST001;Hostname=db2server;Port=5­­
0001;Protocol=TC

PIP;Uid=username;Pwd=password;",
autocommit = True , ansi = True)
curs = conn.cursor()
curs.execute('select count(edokimp_id) from edokimp')
print curs.fetchall()

The script resulted in following error

pyodbc.Error: ('IM002', '[IM002] [Microsoft][ODBC Driver Manager] Data
source na
me not found and no default driver specified (0) (SQLDriverConnectW)')

I thought pyodbc is shipped with DB2 driver. From the error i realize
that i need to download separate driver for DB2 database. So Could you
please point me to the website where i can download the appropriate
driver for DB2 database and later how to configure it so that the
script works.

Thanks for your time in advance as i am newbie to Python with JAVA
experience.