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..."