Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to create a linked server in SQL 2000 w/dbf in diff
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2000 Server
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01466282
Message ID:
01466300
Views:
35
Here is the error when trying to use linked server pointing to the containing dbc to get to a dbf in that dbc but that is in a different folder on the same drive.

Server: Msg 7350, Level 16, State 2, Line 1
Could not get the column information from the OLE DB provider 'VFPOLEDB'.
[OLE/DB provider returned message: Table does not exist.]
OLE DB error trace [OLE/DB Provider 'VFPOLEDB' IColumnsInfo::GetColumnsInfo returned 0x80040e37].

Error when trying to use the path to the dfb -

Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'VFPOLEDB' reported an error.
[OLE/DB provider returned message: Cannot resolve backlink.]
OLE DB error trace [OLE/DB Provider 'VFPOLEDB' IDBInitialize::Initialize returned 0x80004005: ].
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform