MS SQL 2000 / HTTP / XML db module
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
participants (1)
-
Luke Kenneth Casson Leighton