sql 2005 with classic asp
pussy cat | Posted 3:38am 17. July 2007 Server Time |
I can't get my asp sql 2005 connections to work
.net connections run fine but asp give permission denied errors
both set tot he same db with the same access rights
Set ObjConn = Server.CreateObject("Adodb.Connection")
ObjConn.Open "Provider=SQLOLEDB.1;User ID=user;Pwd=password;Data Source=server;Persist security info=false;Initial catalog=DB"
is what causes the error
Do I need to connect in a different way than for SQL 7 & 2000?
thanks
|
katy8439 | Posted 4:52am 17. July 2007 Server Time |
If I remember correctly from the trouble we had, you have to reference the specific pc name and instance name of your 2005 database in the data source.
I've also used this connection string before as well which is slightly different to the one you're using:
Provider=SQLNCLI;Server=yourserver;Database=yourdb;UID=username;PWD=@password;
Reply to Post sql 2005 with classic asp
|
|
|
