dbi and odbc

[ghostdog]

hi

i wanted to connect to a database using dbi and odbc. I have set up DSN 'test' using ODBC data source administrator. how do i call a stored procedure and have the results shown?? did i missed out some other steps

i used execute() but the results are not shown.. 

here is the code :

import dbi,odbc

DSN="test"

USER="me"

PASSWORD="secret"

s = odbc.odbc("%s/%s/%s" % (DSN,USER,PASSWORD))

cur = s.cursor()

cmd = "sp_help"

cur.execute(cmd)

 

 

thanks for any help

 

 

 

 

 



---------------------------------
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/python-list/attachments/20021227/e95810dd/attachment.html>