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