February 29, 2012 at 10:09 am
What is the syntax for querying a linked servers, linked server?
I have a 32 bit server, linked to a 32 bit ODBC datasource. I can query this linked server from the 32 bit server using the 4 part naming convention without any problems.
I am now adding a 64 bit server to the mix, and am unable to link to the original ODBC datasource to this new server as no 64 bit drivers are available.
I have created a linked server from the 64 bit server to the 32 bit server, but cannot determine how to query the linked server attached to the 32 bit server from the 64 bit server...
Is this possible?
February 29, 2012 at 10:49 am
You can create a stored proc that utilizes the new linked server on the server where this new linked server is defined. Then from the first linked server you can execute that proc via the original linked server.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply