Using/finding ODBC and DBI

Boudreau, Emile Emile.Boudreau at cognos.com
Mon Apr 9 09:12:20 EDT 2007


Hello all, I'm trying to use ODBC and DBI but I don't seem to have the
right files on my system. I have looked around and I can't find what I'm
looking for. From the information I have been able to find these are not
part of the standard python library. True?? Where can I find the modules
that I'm missing to be able to import the modules correctly and run my
script?

Thanks,

Here is the code that I'm using.

import odbc, dbi

Query = "select jobs.trakkerid, fixes.change as change, from jobs, fixes
where trakkerid <> 'na' and 
trakkerid <> '' and jobs.job = fixes.job and fixes.change = 28339 order
by change desc"

db = odbc.odbc( "UDAP4" )
cursor = db.cursor()

cursor.execute( Query )

Emile Boudreau
x5754
 
     This message may contain privileged and/or confidential information.  If you have received this e-mail in error or are not the intended recipient, you may not use, copy, disseminate or distribute it; do not open any attachments, delete it immediately from your system and notify the sender promptly by e-mail that you have done so.  Thank you.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/python-list/attachments/20070409/ef39e146/attachment.html>


More information about the Python-list mailing list