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"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.
takThere's just gotta be a better choice for your user id and password... *shrug*
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"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.
takThere's just gotta be a better choice for your user id and password... *shrug*