Re: [Tutor] database access to MSSQL

2005-04-06 Thread Kent Johnson
Ryan Davis wrote: 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

[Tutor] database access to MSSQL

2005-04-06 Thread 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 dat