var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
I have a spreadsheet written in Excel 98. It extracts data using a
Macro and query from Dbase table using DBase odbc driver.
This works fine.
When I try running this on another pc, I get the following error
"Run time Error 1004. General ODBC Error"
I had a look on the ODBC log file, and the following was reported
Driver's SQLSetConnectAttr failed (0)
When I click on the deub line, the error is reported at the following;
Any ideas on how we may resolve? I have ticked ODBC add-in Excel.
I have even tried changing the False to True.
Many thanks for your help people. I look forward to your reply.
Hullo. You may want to try checking the OBDC settings of the failing computer. Make sure that it has the correct setup for DBase, mirroring the system that works.
thanks for getting back to me.
I have checked the driver version (using dbase and the working pc version is the same as the one that does not work...
Any more kind assistance would greatly be appreciated!!
The actual problem paragraph is;
where **** is the problem line..
hope this can help someone point me in thr right direction!!
many thanks in advance.
Welcome to the Board!
Have you tried setting up the Data-->Get External Data-->New Database Query sequence and connecting to the Database from the other PC?
Without the full sequence code, there is no query to refresh. Once you set up the new query, everything should work fine.
Hope that helps,
Thanks for getting back to me.
I have tried your suggestion and the following error message comes up;
[Microsot][ODBC dBase driver] Index not found.
The data tables I am used are Dbase with ntx indexes. I have checked my version of the Dbase driver (odbcjt32.dll) and it is the same as the pc that is working.
Is there anything else that I am missing?
Many thanks in advance!