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.
The error message says "...Data Source Name not found....", meaning that no DSN could be found. The DSN - if you're not aware of that - is a Windows System definition that ties your particular driver to a name that can be used in all your applications. QlikView cannot find this name in the sytem where you run your load script. That can be caused by one of two reasons (or even both of them):
You forgot to define a correctly named DSN in the Windows Control panel.
You did define a correctly named DSN, but you did this in the wrong control panel. On a 64-bit Windows system, you have two ODBC control panels: one for 32-bit ODBC drivers (most of the MS Office drivers are 32-bit), and one (the default control panel) for 64-bit drivers.
Can you figure out whether a correct DSN exists and what architecture you used to define it (32-bit or 64-bit)?