How to make a VFP DB a linked server in SQL Server?

[musik]

I'm trying to link a VFP DB (Free table directory) to SQL Server as a "Linked Server". This will (would!) allow me to access the FP tables as though they were tables in SQL Server and (the whole goal) do joins against other datasources.

The problem is, when I try to use my ODBC DSN, it just says there are no tables, and any table I try to access I get "*.dbf does not exist".

BUT, in Visual Basic (for example), the ODBC DSN works _just fine_ and I can see all the tables and all of their contents.

Why can't SQL Server connect to this data source?

Any other ideas of how I can do a JOIN from VFP Data to ADSI other than by making both Linked Servers on a SQL box? (And I'm a VB/VC programmer... the VFP db is a third-party app over which I have no control. I can't modify it in any way and I only have (and only need) read-only access.)

Thanks much!!!

 

[jjgraf]

go to the SQL server form and try to get answer there. I just did a quick glance at the Help files about this it seems this only works on OLE DB drivers not ODBC