error 80004005

[iainmck]

I have been getting this error on simple ASP code on my web site

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets] SQL Server does not exist or access denied.

The Web Server is running on NT(sp6a) and IIS 4.0
The database is on a separate Windows 2000 (Sp 4) with MS SQL Server 2000 (8.00.760)
And the PDC on a separate NT(sp6a) server.
The application is accessed via a Cisco PIX 515 Firewall.

This error appears intermittently at random times without any specific pattern and rebooting the PDC then web server always clears the problem.

I have replicated the application inside the firewall and this runs trouble free so it would appear the problem is either with the web server or the firewall but as I have little experience of either I am unsure where to start.

Any pointers would be gratefully received.

Apologies if this is the wrong forum – wasn’t sure where to post


Iain

 

[kisasama]

this may not be a problem with the asp code what so ever but a problem with the db connectivity. try creating a UDL file and speciying it to look for the datasource. you can then test the source to see if it functins correctly or if there needs any adjustments. you can create a udl file with notepad by creating a file and renaming it to dbsource.udl. right click on it and there should be tabs for u to experiment on with data connections. try it and see what comes up.