Hi,all
In my ODBC setup for SQL server, I used windows authentication. after set up, the test for datasource connection is successful.
In my ASP code, I used
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "dsn=CMC;Trusted_Connection=""sspi"""
it doesn't work, it always come up with error message.
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'BETTYPC\IUSR_BETTYPC'.
/myweb/webmsde/init.asp, line 30
even I changed to
conn.Open "Driver={SQL Server};Server=BETTYPC;Database=CMC;Truested_Connection=Yes"
it still give me the same error message.
Anybody can help, please?
Betty
In my ODBC setup for SQL server, I used windows authentication. after set up, the test for datasource connection is successful.
In my ASP code, I used
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "dsn=CMC;Trusted_Connection=""sspi"""
it doesn't work, it always come up with error message.
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'BETTYPC\IUSR_BETTYPC'.
/myweb/webmsde/init.asp, line 30
even I changed to
conn.Open "Driver={SQL Server};Server=BETTYPC;Database=CMC;Truested_Connection=Yes"
it still give me the same error message.
Anybody can help, please?
Betty