12 Replies Latest reply: Dec 17, 2014 8:30 AM by Norm POllock RSS

    SQL##f - SqlState: S1000, ErrorCode: 0, ErrorMsg: [DataDirect][ODBC Progress OpenEdge Wire Protocol driver] Insufficient information to connect to the data source.

    Nicholas Scott

      Extracting data from a Progress Database using an ODBC connection I get the following error:

       

      SQL##f - SqlState: S1000, ErrorCode: 0, ErrorMsg: [DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Insufficient information to connect to the data source.

       

      ODBC Error.bmp

      The driver (pgoe1023.dll) and has been installed and tested, and works!   I can connect to the database and preview the table content in the Qlikview connection wizard.  I simply can't reload/extract the data.

      Progress ODBC.bmp

      I can use the ODBC connection with Excel MS Query and extract data from tables.  The user is the owner of the database, so security, or permission to read the database should not be the issue.

       

      After having established the connection to the database in Qlikview, the logon prompt continues to appear when making a selection on the tables.

      Progress ODBC 2.bmp

      It appears to be an issue with the Qlikview connection string as it doesn't store the password (which is in fact "blank").

         

      ODBC CONNECT32 TO STYLEman (XUserId is QbMHOZdNPDdUM);

       

      However, modifying the connection statement and using "ODBC CONNECT32 TO STYLEman (UserId is abcd, Password is )" does not solve the problem!

       

       

      Does anyone have experience in configuring the ODBC for Progress so that the User ID and Password are passed through.