[Tutor] database access to MSSQL

[Ryan Davis]

Does anyone know of a decent way to access a SQL Server 2000 database?

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