ODBC problem

[clarice]

Recently I wiped and reinstall Win XP and Office XP on my
computer. Since then, an excel report that utilized odbc
to pull data from an accounting program into an excel file
can no longer find the souce data. The messages I get are:
[Basis][Basis ODBC Driver] Unable to connect to source
data. Please see log for details. And: [Microsoft][ODBC
Driver Manager] Driver's SQLSetConnectAttr failed.
We had to reidentify the ODBC path after wiping the hard
drive. Evidently we did not use the exact same name os
originally. If the excel program cannot find the source
data, it must know what path name it is looking for.
Where would that path name be stored? I can rename it
from that info.
thanks
Clarice

 

[Arvi Laanemets]

Hi

I had a similar problem with ODBC query. I thought it was because VisualFox
ODBC driver for QindowsXP - it wasn't included into available drivers and I
has to install it from VisualFox homepage. But maybe the problem is general.

After the driver was installed, the query continued to return error. I had
at first to create Data Source manually (AdministrativeTools.DataSources) -
it seems in computer with WindowsXP you are limited to 3 ODBC drivers
(dBase files*; Excel files*; MS Access Database*) you can access directly
from Excel.