Hello Satomi,<br><br>> I have a question about Python Database API Specification v2.0. <a href="http://www.python.org/dev/peps/pep-0249/">http://www.python.org/dev/peps/pep-0249/</a> <br> > I would like to access the database connected by ODBC and am looking for a sample code for that.
<br> <br>Here I've pasted some simple examples:<br>-------------------------------------------------------------------<br># -*- coding: utf-8 -*-<br><br># Windows only, <a href="http://sourceforge.net/projects/pywin32/">
http://sourceforge.net/projects/pywin32/</a><br>import odbc <br> <br>conn = odbc.odbc('DBALIAS') # or odbc.odbc('DBALIAS/USERNAME/PASSWORD') <br> cur = conn.cursor()<br>cur.execute('SELECT * FROM YOURTABLE')
<br>data = cur.fetchall()<br>print data<br><br>##############################<br><br># <a href="http://ceodbc.sourceforge.net/">http://ceodbc.sourceforge.net/</a> <br> import ceODBC<br><br>conn = ceODBC.connect('DSN=DBALIAS') # or
ceODBC.connect('DSN=DBALIAS;UID=USERNAME;PWD=PASSWORD')<br>cur = conn.cursor()<br>cur.execute('SELECT * FROM YOURTABLE')<br>data = cur.fetchall()<br>print data<br><br>##############################<br><br>
# using Egenix's commercial friver<br># <a href="http://www.egenix.com/products/python/mxODBC">www.egenix.com/products/python/mxODBC</a><br>import mx.ODBC.Windows as odbc <br> <br>conn = odbc.connect('DBALIAS') # or
odbc.connect('DBALIAS', 'USERNAME', 'PASSWORD') <br> cur = conn.cursor()<br>cur.execute('SELECT * FROM YOURTABLE')<br>data = cur.fetchall()<br>print data<br>-------------------------------------------------------------------
<br><br>-- <br> Best Regards, <br> Dmitry V. Selitsky <br> +375 29 7724015 | ICQ 73737480 | <a href="http://wiki.python.org/moin/DmitrySelitsky">http://wiki.python.org/moin/DmitrySelitsky</a><br><br><br>