sql server support from linux

S

Simon Wittber

I am currently tasked with connecting Python CGI programs, under
Apache2 / Linux, to SQL Server on Windows 2000.

The latest MSSQL module from
http://www.object-craft.com.au/projects/mssql/ (0.09) will not (for
me, at least) compile on Debian.
The next version of the module (0.08) will compile, but raises a
MemoryException whenever I return varchar fields. Hopeless. It also
segfaults (!) whenever I use datetime fields.

The sybase library (also from object-craft) appears to work, but
raises an exception whenever an empty query result is returned. This
is bizzare, and not DB-API 2.0 compiant.

Does anyone in this list ever connect to SQL Server from Linux, using
Python? If so, what is your solution?

I'm going nuts over here!

Sw.
 
V

vincent wehren

Simon said:
I am currently tasked with connecting Python CGI programs, under
Apache2 / Linux, to SQL Server on Windows 2000.

The latest MSSQL module from
http://www.object-craft.com.au/projects/mssql/ (0.09) will not (for
me, at least) compile on Debian.
The next version of the module (0.08) will compile, but raises a
MemoryException whenever I return varchar fields. Hopeless. It also
segfaults (!) whenever I use datetime fields.

The sybase library (also from object-craft) appears to work, but
raises an exception whenever an empty query result is returned. This
is bizzare, and not DB-API 2.0 compiant.

Does anyone in this list ever connect to SQL Server from Linux, using
Python? If so, what is your solution?

Using mx.ODBC?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,744
Messages
2,569,484
Members
44,903
Latest member
orderPeak8CBDGummies

Latest Threads

Top