Ok heres the situation:
We have a linked server from SQL 2000 to a foxpro dbf.
In our test enviroment we had the Foxpro and SQL server on the same machine. The linked worked perfect.
Now we are ready to implement it. When we made a link to the real FoxPro dbf nothing is showing up in the tables.
The FoxPro is on a seperate machine under another domain in active Directory. We desperately need to connect to the FoxPro table under our current setup. Even suggests point in the right direction would help!!!