[DB-SIG] questions for Python Database API Specification v2.0

[Dmitry Selitsky]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.python.org/pipermail/db-sig/attachments/20070910/44ae2736/attachment.htm