python connection to mssql from windows box
graeme.matthew at contrado.com.au
Sat Oct 2 09:31:58 CEST 2004
look at the ODBTP page I think ther eis a python wrapper for it
"Josh Close" <narshe at gmail.com> wrote in message
news:mailman.4134.1096552901.5135.python-list at python.org...
> On Thu, 30 Sep 2004 09:09:05 +0100, Tim Golden
> <tim.golden at viacom-outdoor.co.uk> wrote:
>> I think you're asking for this:
>> (which, by the way, is the first non-mailing-list result
>> Google gives for python mssql)
> Google? What's that?
> I use the Sybase module by object-craft for linux/python connections
> to mssql, and I refuse to use the mssql module due to these things
> listed on the main mssql page.
> There are a few things that do not work - the work still has not been
> * Almost no testing has been performed - if you use the module you
> will be a pioneer.
> * You cannot send parameters to Cursor.execute() - for the moment
> you must format an SQL expression with the parameters inline.
> * On Windows the Cursor.callproc() method does not work. Some guru
> will have to figure out what is going wrong (i.e. not me). You can
> achieve the same result by simply using Cursor.execute(). For example:
> c = db.cursor()
> c.execute('sp_help titles')
> * The state machine for the Cursor class is quite hokey. It
> returns COMPUTE rows in their own result set. At some stage this will
> be cleaned up.
> * The Connection.commit() and Connection.rollback() methods have
> not been implemented.
> So basically it *kind of* works, but not well. I'm talking about
> native windows module that uses the client tools api. Maybe ADO will
> be the best thing for me. I've seen some problems with that too
> though...... man I hate mssql.
More information about the Python-list