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:
01466373
Views:
44
Are you accessing DBC and table by mapped share or UNC path in application and linked server?

>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: ].
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform