MS SQL 2000 / HTTP / XML db module

Luke Kenneth Casson Leighton lkcl@samba-tng.org
Fri, 23 Mar 2001 02:38:34 +1100


python HTTP / XML MS-SQL 2000 database access - v0.1 released.

http://sourceforge.net/projects/pyxsqmll

(damn, even i have trouble spelling it.  stupid name.  whoever picked
that?? :)

version 0.1 uses HTTP Basic Authentication.
Your Microsoft SQL 2000 and IIS Server can be
configured to require user / password access.

btw, the htmlxmlsql2000 module has exactly the same
format as MySQLdb 0.3.0 (with a couple of features
and functions removed, because i was in a hurry
to get this working!)

in other words, other than the differences in the SQL statement
interoperability (such as SELECT IDENT_CURRENT('tablename') instead of
SELECT LAST_INSERT_ID()), you can replace the module name MySQLdb in your
code with the module name httpxmlsql2000db and expect it to work.

dependencies:

- py-xml-0.6.4 (0.6.2 is known to work, too)

- python 2.0 (other versions not tested)

- MS SQL 2000 (we didn't bother trying with SQL-7, just upgraded)

- MS IIS Server with the SQL-2000 XML isapi component enabled.

python r0kz!

luke

 ----- Luke Kenneth Casson Leighton <lkcl@samba-tng.org> -----

"i want a world of dreams, run by near-sighted visionaries"
"good.  that's them sorted out.  now, on _this_ world..."