-
Linked server problem (rather urgent, please help)
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|