September 17th, 2004, 07:34 AM
|
|
Registered User
|
|
Join Date: Sep 2004
Posts: 3
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
ODBC Drivers error '80004005' ---Urgent!!!!
I am using desktop edition of sal server 7.0 .
I created some tables and also a system dsn .
Then I tested the connection in Test datasource option .
It was successful .
But when I tried thru the following asp,
<%
dim r1,r2,str,con,objcmd
set con = server.Createobject("ADODB.Connection")
con.open "dsn=BM"
%>
it is giving me the following error ,
Microsoft OLE DB Provider for ODBC Driverserror '80004005'
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
Some one please help me, I literally broke my head for this.
I also tried it with user dsn also ,but the problem persists.
|
Dev Articles Community Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
