1004 general ODBC error office 97 windows xp

I am not knowledgeable in excell and have no understanding of macros. I am installing a new computer into a network. other computers with 0ffice 97 run macros fine. when i attempt to run macros from the new computer i get the "1004 general ODBC error" message. i have disabled firewalls, virus protection , etc. I also opened the general tab and clicked the "enable macros" button. I can compare settings with computers that are running macros, but I don't know where to look to compare the settings.

Hello astro,

Since Windows '97, there have been a few changes made in how ODBC connections are established. To answer your question about what is wrong, you need to post your ODBC connection string code, and include which database server you are connecting to e.g., Oracle, SQL, etc.

Sincerely,
Leith Ross

the database server is FoxPro.DBF format. I don't know if this is connected to the database. after installing excel 97 i just opened the file through the file directory -file -open. then went to -tools -macro as i was shown to do with another computer that is set up properly.
I don't know where to find the ODBC connection string.
these are the addresses i found in the visual basic debugger.

this was hi-lighted:
Workbooks.Open FileName:= _
"Z:\LABORATORY\LAB DATA\LAB DATA TEMPLATES\Alkalinity2320B 'enter date here'.xls"

this was in the same section:

Range("A20").Select
With ActiveSheet.QueryTables.Add(Connection:= _
"FINDER;L:\XLTools\Queries\Alkalinity2320B.dqy", Destination:=Range("A11"))


ChDir "Z:\LABORATORY\LAB DATA\LAB DATA TEMPORARY"
ActiveWorkbook.SaveAs FileName:= _
"Z:\LABORATORY\LAB DATA\LAB DATA TEMPORARY\Alkalinity2320B 'enter date here'.xls", _
FileFormat:=xlNormal, Password:="", WriteResPassword:="", _


thanx for all the help. i need it on this one.