Re: [DB-SIG] Reading DB2 on AIX in Python scripts

2007-10-24 Thread M.-A. Lemburg
On 2007-10-24 06:03, James Briggs wrote: > Hi, > > I have been using pyodbc to connect to DB2 on an AS400. > Different beast I know but this is successful provided you have the correct > ODBC drivers installed for the flavour of DB2 on your PC. > > An example from my code, which returns a databas

Re: [DB-SIG] Reading DB2 on AIX in Python scripts

2007-10-23 Thread James Briggs
Hi, I have been using pyodbc to connect to DB2 on an AS400. Different beast I know but this is successful provided you have the correct ODBC drivers installed for the flavour of DB2 on your PC. An example from my code, which returns a database connection: import pyodbc def connect_to_db2():

Re: [DB-SIG] Reading DB2 on AIX in Python scripts

2007-10-23 Thread David . Lloyd
Many thanks for that Harald. I will try that out and have a look at the pydb2 project site. Kind Regards Dave Lloyd "Harald Armin Massa"

Re: [DB-SIG] Reading DB2 on AIX in Python scripts

2007-10-23 Thread Harald Armin Massa
David, never done that. But a quick google reveals: http://sourceforge.net/projects/pydb2/ there is a python package, called pydb2. So the most propable code will be: import pydb2 cn=pydb2.connect(database="database", host="host", user="user", password="password") cs=cn.cursor() cs.execute

[DB-SIG] Reading DB2 on AIX in Python scripts

2007-10-23 Thread David . Lloyd
Hello, I am new to Python and I am trying to work out if it is possible to use Python to read DB2 version 8/9 tables on an AIX server. The code will reside on the same server as the database. If it is possible, does anyone have any examples of connecting to a DB2 database they could forward to