[wxPython] Connecting to db2 Database

wxPython Users
1

I am using ODBC and DB2. This is some old code I pulled up:

from mx.ODBC.Windows import *
conn = Connect('SFBCDB2B', 'userid', 'password')
curs = conn.cursor()
curs.execute( 'SELECT * FROM SOME_TABLE' )
row = curs.fetchone()
while row:
  print row[0]
  row = curs.fetchone()

Hope that helps,
jaime

*Note - You will need the mxODBC stuff, which isn't standard. I can't
recall where I got it from, but it should be easy enough to find. Good
Luck!

···

-----Original Message-----
From: DJ Webre [mailto:d_webre@yahoo.com]
Sent: Wednesday, August 28, 2002 4:15 PM
To: wxpython-users
Subject: [wxPython] Connecting to db2 Database

I am trying to connect to my db2 database running on a mainframe. I
can use MS Excell to connect but I would like to connect with a
wxPython program. I have a wxPython program which presently connects
to mySQL database, which I will modify.

Any suggestion is appreciated.

__________________________________________________
Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes
http://finance.yahoo.com

_______________________________________________
wxpython-users mailing list
wxpython-users@lists.wxwindows.org
http://lists.wxwindows.org/mailman/listinfo/wxpython-users