ODBC

[lblr33]

I would like to connect to an Oracle database. In python version 2.1 I
used the following code and it worked fine. When I run the code in
version 2.4 it says that the odbc moduled does not exist. How do you
connect to an Oracle database in v2.4?

oradb=odbc.odbc('oracle/scott/tiger')
stmt='select project_id from s_projects'
cur=oradb.cursor()
cur.execute(stmt)
for rec in cur.fetchall():
print rec[0]
cur.close()

Thanks

[Roger Upole]

From the syntax, this appears to be the odbc module included
with the Pywin32 package.
http://sourceforge.net/projects/pywin32/
You probably have it installed with the 2.1.1 version, but
not 2.4.

hth
Roger

<lb****@yahoo.com> wrote in message news:11**********************@o13g2000cwo.googlegr oups.com...

I would like to connect to an Oracle database. In python version 2.1 I
used the following code and it worked fine. When I run the code in
version 2.4 it says that the odbc moduled does not exist. How do you
connect to an Oracle database in v2.4?

oradb=odbc.odbc('oracle/scott/tiger')
stmt='select project_id from s_projects'
cur=oradb.cursor()
cur.execute(stmt)
for rec in cur.fetchall():
print rec[0]
cur.close()

Thanks

----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----