I'm having difficulty attaching to a Foxpro database as a linked server from one of our SQL 7 servers and am at a complete loss as to the cause. The other server connects fine using the same provider string (DRIVER={Microsoft Visual FoxPro Driver};SourceDB=\svrm2mdata01sales;SourceType=DBF ;NULL) but this one doesn't.

It creates the linked server, but is unable to access the data. I checked the Foxpro ODBC drivers, and they are different. The one that's having the problems has newer drivers (6.01.8629.01 with a date stamp of 3/7/00 as opposed to 6.01.8629.01 with a date stamp of 9/21/99).

I'm at a complete loss and under a deadline, so any help would be greatly appreciated.

Thanks.

Aric Datesman
adatesman@gerotechinc.com