Linked Server Query Returning No Records
-
I have an x64 Server Running SQL Server 08 and within that server I am setting up a linked server to an XP box running SQL express 05. I am setting up the linked server with a server name of "ComputerName\SQLEXPRESS", using the Microsoft OLE DB Provider for SQL Server. It connects fine and passes a connection test, but when i write a simple select query to get all records from the linked server table it returns no records when there are multiple records in the table I have queried. Any one ever seen this before? It should be noted that when I try to add the linked server and keep the radio button selected for sql server it will not connect giving me an error message VIA Provider: The specified module could not be found. OLE DB provider: SQLNCLI10 for linked server returned message login timeout expired. OLE DB Provider for linked server returned message a network related or instance specific error has occured while establishing..... I am at a loss? :mad:
-
I have an x64 Server Running SQL Server 08 and within that server I am setting up a linked server to an XP box running SQL express 05. I am setting up the linked server with a server name of "ComputerName\SQLEXPRESS", using the Microsoft OLE DB Provider for SQL Server. It connects fine and passes a connection test, but when i write a simple select query to get all records from the linked server table it returns no records when there are multiple records in the table I have queried. Any one ever seen this before? It should be noted that when I try to add the linked server and keep the radio button selected for sql server it will not connect giving me an error message VIA Provider: The specified module could not be found. OLE DB provider: SQLNCLI10 for linked server returned message login timeout expired. OLE DB Provider for linked server returned message a network related or instance specific error has occured while establishing..... I am at a loss? :mad:
Member 8003276 wrote:
a network related or instance specific error has occured
That's a general message, and there can be many reasons why it can't connect. Try using an IP-address to identify the computer. Is Sql configured to use TCP/IP or use named pipes? Did you install all the service-packs?
Bastard Programmer from Hell :suss: