S
SB
Hi
I am using ODBC to get data from Sage into excel. I have managed to
get this to work fine on my machine and I have the VBA code working to
automate the task. However when i try to do the same on my colleagues
machine (from scratch) it doesn't work.
I am on Excel 2000 and sage v11 (single co licence) whilst he is on
Excel 2000 & Sage v10 (5 company licence)
The error message which appears when i do Data>Get External Data>etc
in excel is this ...
Cannot find all files in data path
Driver's SQLSetConnectAttr failed
The driver returned invalid (or failed to return)
SQL_DRIVER_ODBC_VER:2.00
There is one other posting relating to this but it is not that helpful
saying only "Yes thats a problem with the ODBC DSN".
Can anyone advise what I need to do on my colleagues machine to get
this working?
Thanks in advance.
I am using ODBC to get data from Sage into excel. I have managed to
get this to work fine on my machine and I have the VBA code working to
automate the task. However when i try to do the same on my colleagues
machine (from scratch) it doesn't work.
I am on Excel 2000 and sage v11 (single co licence) whilst he is on
Excel 2000 & Sage v10 (5 company licence)
The error message which appears when i do Data>Get External Data>etc
in excel is this ...
Cannot find all files in data path
Driver's SQLSetConnectAttr failed
The driver returned invalid (or failed to return)
SQL_DRIVER_ODBC_VER:2.00
There is one other posting relating to this but it is not that helpful
saying only "Yes thats a problem with the ODBC DSN".
Can anyone advise what I need to do on my colleagues machine to get
this working?
Thanks in advance.