?
Solved

Is Windows 7 x64 SQL Client compatible with SQL Server 2005 32-bit?

Posted on 2010-01-12
9
Medium Priority
?
927 Views
Last Modified: 2013-11-29
We have SQL Server 2005 32-bit and want to allow access by a 64-bit Windows 7 client. Can this be done by just purchasing/installing a SQL Client 64-bit package on the new client?
0
Comment
Question by:edison04
[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
  • 5
  • 4
9 Comments
 
LVL 11

Expert Comment

by:princeatapi
ID: 26295477
Yes it will
please find the general information
http://www.microsoft.com/sqlserver/2005/en/us/64-bit.aspx
0
 

Author Comment

by:edison04
ID: 26295525
My concern is whether a 64-bit client can successully access a 32-bit SQL Server.
0
 
LVL 11

Accepted Solution

by:
princeatapi earned 1500 total points
ID: 26295640
Recently i tested my application moving to IIS7 (64bit) and Sql Server2008 but i ve located my database in a different server which is SqlServer 2005 32bit i have no issues in connecting with the DB
0
What Is Blockchain Technology?

Blockchain is a technology that underpins the success of Bitcoin and other digital currencies, but it has uses far beyond finance. Learn how blockchain works and why it is proving disruptive to other areas of IT.

 

Author Comment

by:edison04
ID: 26295666
Do you know if I have to buy a separate software package to get the x64 SQL client?
0
 
LVL 11

Expert Comment

by:princeatapi
ID: 26295685
I don't think so all the essential Components comes along with the Package , even you can avail for free from Microsoft web site
0
 

Author Comment

by:edison04
ID: 26295736
I will keep looking for a download
0
 
LVL 11

Expert Comment

by:princeatapi
ID: 26295754
You can get express editions keep going ..
0
 

Author Comment

by:edison04
ID: 26299137
Yes, thank you. That's what I had to do. Plus I had to go here:

http://www.sqlservercurry.com/2008/05/install-sql-server-express-64-bit-on-64.html

and uninstall Sql Native Client and install these 2 things.
0
 

Author Closing Comment

by:edison04
ID: 31676229
I did get the answer that I needed, but only part of the "how," which I had to find myself. It was good to know it could be done and to use SQL Express, that is why I am still giving all 500 points. Without that info, I would not have known what to look for. Thanks.
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

This article helps those who get the 0xc004d307 error when trying to rearm (reset the license) Office 2013 in a Virtual Desktop Infrastructure (VDI) and/or those trying to prep the master image for Microsoft Key Management (KMS) activation. (i.e.- C…
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 …
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…

762 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