[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Create linked server from 64-bit SQL to 32-bit SQL or use a join query

Posted on 2013-11-01
1
Medium Priority
?
308 Views
Last Modified: 2013-11-20
I have one database on a 64-bit version of SQL Server 2008.  I have another "Linked Server" in my 32-bit SQL Express instance on the same server.  

I was going to try to create another linked server with my 64-bit instance to the 32-bit instance, but SQL Mgmt Studio isn't recognizing it.  

My other option was to use join statements to connect the two, but that doesn't seem to work, either.  

How can I get the 32-bit piece to talk to the 64-bit piece?  I can see both of them in my SQL Mgmt Studio, obviously in separate connections to the SQL instances.
0
Comment
Question by:saturation
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 71

Accepted Solution

by:
Qlemo earned 2000 total points
ID: 39618123
1. You can't use different instances in a join without having them defined as Linked Server.
2. Bitness does not matter for Linked Servers. However, you might have to use TCP explicitly to get it work between 32- and 64-bit instances on the same server.

Proving a full servername\instance as server might help; adding the port the other instance listens to could work, too:   servername,1555 (if 1555 is the listening port of that instance, see its network connection properties).
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

649 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question