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.
I will assume initially it was the drivers that came with Office. I have since installed some files for drivers I was given by Qlikview support. I still get the same error.
Ok, if the drivers are ok then we're halfway.
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):
Can you figure out whether a correct DSN exists and what architecture you used to define it (32-bit or 64-bit)?
Thank you for your continued assistance, man.
I am developing on a server which also doubles as the production server - story for another day!!!
I have defined the ODBC connection on the System DSN tab which is how I have used it since I started with data warehouses back in 1998! I am also using the 64-bit architecture.