SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Other SQL Server 2008 Topics
 execute query using linked server
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Amirthalingam
Starting Member

India
7 Posts

Posted - 04/04/2011 :  05:37:13  Show Profile  Reply with Quote
I got this error when i execute query after created linked server

OLE DB provider "SQLNCLI10" for linked server "xxx" returned message "Login timeout expired".
OLE DB provider "SQLNCLI10" for linked server "xxx" returned message "A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.".
Msg 126, Level 16, State 1, Line 0
VIA Provider: The specified module could not be found.



Can anybody help me how to resolve this error

russell
Pyro-ma-ni-yak

USA
5072 Posts

Posted - 04/04/2011 :  10:48:51  Show Profile  Visit russell's Homepage  Reply with Quote
Sounds like you mis-typed the name (or IP) of the linked server. How did you create the linked server?
Go to Top of Page

Amirthalingam
Starting Member

India
7 Posts

Posted - 04/05/2011 :  04:52:16  Show Profile  Reply with Quote
I executed this below query
its working

EXEC sp_addlinkedserver 'SERVERNAME','SQL server'


EXEC sp_addlinkedsrvlogin
@rmtsrvname=N'SERVERNAME',
@useself=N'false',
@locallogin=null,
@rmtuser=N'UN',
@rmtpassword=N'PWD';
Go to Top of Page

Amirthalingam
Starting Member

India
7 Posts

Posted - 04/06/2011 :  07:49:42  Show Profile  Reply with Quote
I executed this below queries to make a linked server(from sql server 2008 to sql server 2000).

EXEC sp_addlinkedserver
@server=N'servername',
@srvproduct=N'',
@provider=N'SQLNCLI10',
@datasrc=N'servername';


EXEC sp_addlinkedsrvlogin
@rmtsrvname='servername',
@useself=N'false',
@locallogin=null,
@rmtuser=N'UN',
@rmtpassword=N'PWD';

After added i tried to execute this query
SELECT * FROM [Server].db.dbo.tablename

but i got below error

Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "SQLNCLI10" for linked server "servername" reported an error. The provider did not give any information about the error.
Msg 7312, Level 16, State 1, Line 1
Invalid use of schema or catalog for OLE DB provider "SQLNCLI10" for linked server "servername". A four-part name was supplied, but the provider does not expose the necessary interfaces to use a catalog or schema.



Go to Top of Page

Amirthalingam
Starting Member

India
7 Posts

Posted - 04/06/2011 :  07:50:38  Show Profile  Reply with Quote
I executed this below queries to make a linked server(from sql server 2008 to sql server 2000).

EXEC sp_addlinkedserver
@server=N'servername',
@srvproduct=N'',
@provider=N'SQLNCLI10',
@datasrc=N'servername';


EXEC sp_addlinkedsrvlogin
@rmtsrvname='servername',
@useself=N'false',
@locallogin=null,
@rmtuser=N'UN',
@rmtpassword=N'PWD';

After added i tried to execute this query
SELECT * FROM [Server].db.dbo.tablename

but i got below error

Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "SQLNCLI10" for linked server "servername" reported an error. The provider did not give any information about the error.
Msg 7312, Level 16, State 1, Line 1
Invalid use of schema or catalog for OLE DB provider "SQLNCLI10" for linked server "servername". A four-part name was supplied, but the provider does not expose the necessary interfaces to use a catalog or schema.


Can anybody help me


Go to Top of Page

russell
Pyro-ma-ni-yak

USA
5072 Posts

Posted - 04/06/2011 :  08:32:50  Show Profile  Visit russell's Homepage  Reply with Quote
See if this solves your problem.
Go to Top of Page

Amirthalingam
Starting Member

India
7 Posts

Posted - 04/07/2011 :  06:29:42  Show Profile  Reply with Quote
I am trying to connect linked server through 'SQLNCLI10' provider not 'SQLNCLI' .please suggest solution
Go to Top of Page

antoreegan
Starting Member

India
1 Posts

Posted - 08/19/2013 :  06:15:20  Show Profile  Reply with Quote
Have u got any Solution..please am also troubling with this same Problem..
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000