<div>
i PatelAlpesh,<br />
both these work<br />
select * from openquery (serverB, 'SELECT * from northwind.dbo.employees')<br />
SELECT * from serverB.northwind.dbo.empl<wbr />oyees<br />
<br />
I thought i had to use OPENQUERY for a linked server but maybe not...<br />
thanks for your help...all ok now :-)
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
I have created a linked server from serverA to serverB using <br />
EXEC sp_addlinkedserver @server='serverB'<br />
<br />
When I fire the following query from serverA<br />
select * from openquery (serverB, 'SELECT * from serverB.northwind.dbo.empl<wbr />oyees')<br />
<br />
I get the following error<br />
OLE DB provider &quot;SQLNCLI&quot; for linked server &quot;serverB&quot; returned message &quot;Deferred prepare could not be completed.&quot;.<br />
Msg 14, Level 16, State 1, Line 1<br />
[DBNETLIB][ConnectionOpen (Invalid Instance()).]Invalid connection.<br />
<br />
any help appreciated...thanks<br />
<br />

</div>
</div>


Hi,
I have created a linked server from serverA to serverB using 
EXEC sp_addlinkedserver @server='serverB'

When I fire the following query from serverA
select * from openquery (serverB, 'SELECT * from serverB.northwind.dbo.employees')

I get the following error
OLE DB provider "SQLNCLI" for linked server "serverB" returned message "Deferred prepare could not be completed.".
Msg 14, Level 16, State 1, Line 1
[DBNETLIB][ConnectionOpen (Invalid Instance()).]Invalid connection.

any help appreciated...thanks



i PatelAlpesh,
both these work
select * from openquery (serverB, &#39;SELECT * from northwind.dbo.employees&#39;)
SELECT * from serverB.northwind.dbo.employees

I thought i had to use OPENQUERY for a linked server but maybe not...
thanks for your help...all ok now :-)

linked server error in sql server 2005

Hi,
I have created a linked server from serverA to serverB using 
EXEC sp_addlinkedserver @server=&#39;serverB&#39;

When I fire the following query from serverA
select * from openquery (serverB, &#39;SELECT * from serverB.northwind.dbo.employees&#39;)

I get the following error
OLE DB provider &quot;SQLNCLI&quot; for linked server &quot;serverB&quot; returned message &quot;Deferred prepare could not be completed.&quot;.
Msg 14, Level 16, State 1, Line 1
[DBNETLIB][ConnectionOpen (Invalid Instance()).]Invalid connection.

any help appreciated...thanks



Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.