9 Replies Latest reply: Mar 25, 2017 8:28 AM by Edwin Matlapeng RSS

    ODBC CONNECT32

    Edwin Matlapeng

      Morning All,

       

      I need assistance with the following. I need to refresh a qvd with an excel document and the said document will occasionally consist of more than one sheet. So I am making the ODBC connection to the excel document and the connection works such that for every excel document the program will loop across the document for each sheet. The problem is everytime I run the document refresh I get an error. SQL##f - SqlState: IM002, ErrorCode:0, ErrorMsg:[Microsoft][ODBC Driver Manager] Data Source Name not found and no default driver specified. However, when you press the Okay button, the program proceeds to run. The problem is the first file never gets read. I have downloaded all the latest drivers for Excel to no avail.

      Please assist.