NickCorlett
Technical User
I am attempting to obtain a database connection to a SQL 2000 database. The code I have works fine for a SQL 6.5 database but returns an error saying I can't login. Can anybody help???
This is the code which works on a SQL6.5 database but not on a 2000 one.
"Set DBObj= Server.CreateObject("ADODB.Connection"
dBObj.Open "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=NickDev;Data Source=NTSERVER11;Locale Identifier=2057;Connect Timeout=15;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=NIL251;
dbObj.CommandTimeout = 0"
This is the code which works on a SQL6.5 database but not on a 2000 one.
"Set DBObj= Server.CreateObject("ADODB.Connection"
dBObj.Open "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=NickDev;Data Source=NTSERVER11;Locale Identifier=2057;Connect Timeout=15;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=NIL251;
dbObj.CommandTimeout = 0"