Results 1 to 2 of 2
  1. #1
    Join Date
    May 2003
    Posts
    2

    Red face Unanswered: ASP/IIS and Progress 8.3C error

    Hi,

    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...


    <%
    Dim Conn
    Dim Rs
    Dim strCnn
    Dim strSQL

    strCnn = ...the OLE DB string from UDL file...
    strSQL = "SELECT * FROM table1"

    Set Conn = Server.CreateObject("ADODB.Connection")
    Conn.Open strCnn

    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!!!!

    Thanks a million!

  2. #2
    Join Date
    Nov 2002
    Location
    London
    Posts
    47
    Hi

    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

    HTH
    Emmon (OpenLink Software)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •