Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
OpenDataSource
Message
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Miscellaneous
Thread ID:
00978137
Message ID:
00978758
Views:
37
>Try
SELECT * FROM OPENROWSET('MSDASQL',
>'Driver=Microsoft Visual FoxPro Driver;SourceDB=c:\temp\ims.dbc;SourceType=DBC',
>'SELECT * FROM zipfl')
You can also create a linked server.

I get this error:

Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: [Microsoft][ODBC Driver Manager] Driver does not support this function]
OLE DB error trace [OLE/DB Provider 'MSDASQL' IDBInitialize::Initialize returned 0x80004005: ].
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform