I have an ASP page that calls an ODBC DSN (to a MS Access 2000 database) to create a connection object to use in the code. On the development machine, this code always works, but on my production server it does not always work. Sometimes it will run the code without error and other times it will stop. The following is the method I am using to make the connection and the error messages come on the last line shown:
Set objConn = Server.CreateObject("ADODB.Connection"
strConn = "DSN=Dance;Database=Dance;UID=sa;PWD=;"
objConn.Open strConn
The error message is simply "Provider error '80004005' Unspecified error "
Both machines have Microsoft Access driver version 4.11.4403.02 (MDAC 2.6) installed. I have researched this issue but the 'sometimes it works' nature makes it tricky. Does anyone have any ideas as to why such a thing would happen some of the time, or have any suggestions to fix it?
Machine parameters:
DEVELOPMENT: Windows 98SE running PWS
PRODUCTION: Windows NT4 SP6.1 running MTS and IIS5
Set objConn = Server.CreateObject("ADODB.Connection"
strConn = "DSN=Dance;Database=Dance;UID=sa;PWD=;"
objConn.Open strConn
The error message is simply "Provider error '80004005' Unspecified error "
Both machines have Microsoft Access driver version 4.11.4403.02 (MDAC 2.6) installed. I have researched this issue but the 'sometimes it works' nature makes it tricky. Does anyone have any ideas as to why such a thing would happen some of the time, or have any suggestions to fix it?
Machine parameters:
DEVELOPMENT: Windows 98SE running PWS
PRODUCTION: Windows NT4 SP6.1 running MTS and IIS5