sql server connect: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist o -- sql server connect

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist o

TroelsM
4/18/2006 12:09:02 PM

sql server connect:

I have a serval .asp page with get som data from a SQL database.
Sometimes (not every time) i call one of the pages it gives me this error

Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access
denied

I dont know when the error are comming, sometime the page are ok 2-3 times
in a row and the it fails - other times it fail 2 times in a row

SQL 2000 SR4a

More info on this error

TroelsM
4/19/2006 1:37:01 AM

I have 2 webservers
Webserver one - with SQL server 2000
on this server the asp script never fails

Webserver two
on this i use the SQL server on webserver one and on this the script from
time
to time fails.

so when I call the script on the webserver where the sql server are local
there are no fails, but when i use "external" connection from another
webserver the fails comes and goes.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server connect group.