[DB-SIG] Examples on how to use mxODBC?

[M.-A. Lemburg]

jgoldtest wrote:
> Hi all,
> 
> I've got to appologize for posting what must be a stupid question but so far, I've been unable to figure it out for myself.  I'm trying to learn web development using python.  I've tried out Zope, Twisted, and finally Cherrypy. I work at a Microsoft  shop but I'm trying go get them away from .Net and into open source.  I figure if I can learn it, I can make it easy for everyone else by teaching it.  I may have taken on too much.  The learning curve is steep! 
> 
> I've taken a break from the Web stuff for a bit to try and figure out how to access my database.  Ideally, I'd just like a few lines to show what you need to import, what objects and methods need to be executed to connect to a database and execute a select statement.  I guess I'd also be nice if it could read through the returned records.  I'm sure this is a really simple thing to do but I can't find any working examples.  I can find examples for accessing MySQL but I don't know how to convert them to  mx ODBC.  I've tried a number of things but nothing seems to work.
> 
> I've found old examples that use the ODBC 1.0 spec and start with lines like "from calldll import odbc" but I can't find this "calldll" package.  It's all very confusing.  I downloaded and installed the mx ODBC.  I guess the documentation is good if you already know what you're doing but it's been pretty useless to me.  There are NO example programs that I can find that demonstrate step-by-step how you use it.
> 
> Anyway,  a few pointers would be helpful.  I'll try not to be a pest.

Some links that may help:

http://www.python.org/topics/database/docs.html
http://www.egenix.com/Python-Database-API-Talk.pdf

I'd suggest to buy one of the fine Python books out there. They
usually have good introductions to the DB-API and how to use
it.

-- 
Marc-Andre Lemburg
eGenix.com

Professional Python Software directly from the Source  (#1, Oct 22 2003)
 >>> Python/Zope Products & Consulting ...         http://www.egenix.com/
 >>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/
________________________________________________________________________

::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,FreeBSD for free ! ::::