<HTML >
<HEAD>
<META http-equiv="Content-Type" content="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7651.59">
<TITLE>Using/finding ODBC and DBI</TITLE>
</HEAD>
<BODY >
<DIV>
<!-- Converted from text/rtf format -->
<P><FONT SIZE=2 FACE="Arial">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?</FONT></P>
<P><FONT SIZE=2 FACE="Arial">Thanks,</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Here is the code that I'm using.</FONT>
</P>
<P><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">import odbc, dbi</FONT>
</P>
<P><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">Query = "select jobs.trakkerid, fixes.change as change, from jobs, fixes where trakkerid <> 'na' and </FONT>
<BR><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">trakkerid <> '' and jobs.job = fixes.job and fixes.change = 28339 order by change desc"</FONT>
</P>
<P><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">db = odbc.odbc( "UDAP4" )</FONT>
<BR><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">cursor = db.cursor()</FONT>
</P>
<P><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">cursor.execute( Query )</FONT>
</P>
<P><FONT FACE="Lucida Calligraphy">Emile Boudreau</FONT>
<BR><FONT SIZE=2 FACE="Arial">x5754</FONT>
</P>
</DIV>
<DIV> </DIV>
<DIV> 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. </DIV></BODY></HTML>