Do not access SQL Server via DSN
In the connection string, add the server and database driver:
DIM ConnSet conn = server.createObject ("adodb.connection") conn.connectionstring = "driver = {SQL Server};" Server = YourServer; UID = SA; PWD = PWD; Database = PUBS "conn.openset cmd = server. CreateObject ("AdoDb.command") Set cmd.activeConnection = conn
