We need to combine MSSQL7 tables with Visual FoxPro 6
tables for reporting purposes using Crystal Reports
Version 6.
The process we follows to create a Linked server is as
follows:
1. We create a System DSN using Visual FoxPro Tables
(*.dbf) driver and pointing to the directory (Free Table
Directory) of the Visual FoxPro tables.
2. In SQL we are creating a Linked Server using the
Microsoft OLE DB Provider for ODBC and the DSN as the
FoxPro DSN that we have created in 1.
3. Now you should see the FoxPro tables under the
Tables section of the Linked Server.
After formatting the SQL server and re-Installed Windows
2000 Server SP3 and SQL Server 7.0 SP3, we could create
the Linked Server without any problems. After 3 days of
work, the linked server's tables were not visible anymore.
We tried to re-create the Linked Server as described
above, but without any success. Although Linked server is
visible, the FoxPro tables are then not visible.
It seems that the only way to re-establish the Linked
Server is to format the drive. Then it will work properly
for a short while.
How can we re-create the Linked server without formatting
SQL server again?
Can anyone tell us what are the prerequisites for Linked
Server?
Why do the FoxPro Linked Server tables disappear?
We are using MSDASQL.DLL version 2.53.6200.0.
The Visual FoxPro Tables are all version 6.
To create the DSN, we are using Visual FoxPro tables
(*.dbf) driver version 6.01.8629.01
Where can we look for errors, as there are no errors
reported in the SQL logs?
Thanks