Why can't I connect to sql server 2000 ?

[Robert Chu]

Hello,
I use the following code to connect to sql server 2000. There will be errors like this: 'Let' and 'Set' assignment statements are no longer supported. How can I fix it ?

Set ConnSt03=Server.CreateObject("ADODB.connection")
STRCON="PROVIDER=SQLOLEDB.1;DATA SOURCE=localhost;USER ID=KKK;PASSWORD=KKK;INITIAL CATALOG=test"

[takkie]

take away the SET word before ConnSt03.

just make it liek this,

ConnSt03=Server.CreateObject("ADODB.connection")
STRCON="PROVIDER=SQLOLEDB.1;DATA SOURCE=localhost;USER ID=KKK;PASSWORD=KKK;INITIAL CATALOG=test"

Its not the connection to db, its your syntax of that line.

tak

[juicemousezero]

There's just gotta be a better choice for your user id and password... *shrug*