VBScript SQL 2000 Server Connection

[DANZIG]

Hellos,
I'm looking for an example code for a VBScript connection to a remote SQL 2000 server. I'm trying to avoid the system or file DSN requirement on the system running the script so I can move the script from one system to another wiht having to build a new DSN on each system. I do need to use SQL authentication in the connection. The idea is to use SQL as my data storage media for administration scripts instead of excel.

Any examples would be greatly appreciated.

Thanks in advance.

 

[hecktic]

[...]
set cnn = server.createobject("adodb.connection&quot
set rst = server.createobject("adodb.recordset&quot

cnn.open "server", "username", "password"
rst.open strQuery, cnn
[...]

 

[PHV]

Set Conn=CreateObject("ADODB.Connection&quot
Conn.Open "driver=SQL Server;server=YourServer;uid=YourId;pwd=YourPassword;database=YourDatabaseName;"
This is a DSN-less connection.

Hope This Help
PH.