Does anyone know of a decent way to access a SQL Server 2000 database?
I make heavy use of SQL Server from Jython using Microsoft's JDBC driver. This works great if it is an option for you.
Otherwise if your client is on Windows take a look at adodbapi. I have just played around with this enough to see that it will connect to SQL Server so I can't vouch for the quality but at least it claims to be ready for production use.
http://adodbapi.sourceforge.net/
eGenix sells an ODBC adapter: http://www.egenix.com/files/python/mxODBC.html
Kent
I've gotten some versions working using dbi,odbc and defining a DSN on the computer, but I'd like to be able to specify a server, user, pass, and database in code. As far as I can tell, I'd have to define a DSN for every database I'd want to use.
I found this via google: http://www.object-craft.com.au/projects/mssql/ but that has a lot of strong language saying "this isn't ready for use".
Has anyone done this before and come up with a reasonable solution?
Thanks,
Ryan
_______________________________________________ Tutor maillist - Tutor@python.org http://mail.python.org/mailman/listinfo/tutor
_______________________________________________ Tutor maillist - Tutor@python.org http://mail.python.org/mailman/listinfo/tutor
