Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Server 2000 Linked Server to Visual FoxPro
Message
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Miscellaneous
Thread ID:
00916172
Message ID:
00935987
Views:
18
It looks like you're using OLE DB Provider for ODBC. VFP ODBC driver doesn't support any post VFP6 data features, like autoinc fields, DBC events, e.t.c. You've to use VFP OLE DB provider if you want to access dabases/tables that implement such features. Keep in mind that only read access to VFP data is supported for a linked server with VFP OLE DB provider.

>Thanks for your help.
>Would you know why I cannot access any FoxPro tables that contain a AutoInc field with a linked server?
>
>I get the following message:
>
>Server: Msg 7399, Level 16, State 1, Line 1
>OLE DB provider 'MSDASQL' reported an error. The provider did not give any information about the error.
>OLE DB error trace [OLE/DB Provider 'MSDASQL' IColumnsInfo::GetColumnsInfo returned 0x80004005: The provider did not give any information about the error.].
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform