Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Openquery
Message
 
 
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Miscellaneous
Thread ID:
00881389
Message ID:
00881455
Views:
28
>Sergey,
>
>when I try the 4-part naming I get following error:
>OLE DB provider 'MSDASQL' reported an error. The provider did not give any information about the error.
>
>I tried with a simple query like 'select * from LS.LS..table1'

Hans,

Is this table a free table or a part of DBC? The four part reference will only work for a table in DBC. For a free table try
SELECT * FROM openquery(ls, 'select * from table1')
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform