VFP DBC as Linked Server in a SQL Server 2000?

[mejiaks]

Hi, Anybody of you knows how to add a Visual Foxpro DBC as a Linked Server in my SQL Server. anyone of you have experience with this.

In the Enterprise manager I go to
My Server
security
Linked Server
New linked servers
-Choosed Other Data Source
OLE DB Provider for ODBC Drivers
and specify the DSN

but for some reason doesn't work. any Ideas

 

[oublie]

As far as I recall, I think you need the ODBC driver for FOXPRO DBC installed on the SQL server. You should then be able to select this from the dropdown of connections.

 

[mrdenny]

You need to have the drives installed on the server, as well as the machine running Enterprise Manager.

I've done this with Oracle, I'm assuming that VFP is the same.

Denny