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 have tried on the same Active Directory as well, not
working.... We desperately need to connect to the FoxPro table under our
current setup. Even suggests point in the right direction would help!!!
Adam H