I am working with the following progress database sytstem.
Database type: Progress 8.3C
ODBC driver: Intersolv 3.10 32 BIT PROGRESS
Server OS: Windows 2000
I'm trying to query for information using a select statement in my ASP page, but keep getting the following error message,
Microsoft Error x80004005
Specified Driver Cannot be loaded due to system error 5
(Intersolve 3.10 32 BIT PROGRESS)
I obtain the connection string using a Microsoft UDL file (a text file), which the connection tested successfully. So...I know the OLE DB string is correct.... Here is the snippet of code in my ASP page...
strCnn = ...the OLE DB string from UDL file...
strSQL = "SELECT * FROM table1"
Set Conn = Server.CreateObject("ADODB.Connection")
Set Rs = Conn.Execute(strSQL)
The error occurs when the code tries to open the connection to the database through the connection string. I also tried pointing to the System DSN in the ODBC setting, that also give the same error.
I did researches on Microsoft for error 80004005 which refers to the MDAC. I have updated it to most recent version 2.5 on the client's computer, so that shouldn't be the cause.
Could it also be because in the above code, I didn't set Rs varaible to server.createobject(ADODB.Connection)? I didn't need to do this for other databases...
Mainly, I wonder if the error occurs because of the ODBC driver not being compatible with IIS and ASP technology. Anyone with any solutions or guidance please help!!!!
Typically when this error occurs with the OpenLink drivers, its because of a PATH environment variable which doesn't contain the either the Progress/bin directory or the actual OpenLink Progress ODBC driver. It might be worth adding these directories and retrying your connection