SQL Server Native Client 32 Bit or 64 Bit

Dear EE,

How do i determine which MS SQL 2008 R2 Native Client 32 bit or 64 bit is installed on my Windows 2008 R2 64 Bit Standard Edition ?

Thanks
Netsol-NOSAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Alex Green3rd Line Server SupportCommented:
check add remove programs?
0
Netsol-NOSAuthor Commented:
32 or 64 is not mentioned there.
0
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
You cannot install Native Client with a different bitness than the OS, so you have 32bit on 32bit OS and 64bit on 64bit OS.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
CompTIA Security+

Learn the essential functions of CompTIA Security+, which establishes the core knowledge required of any cybersecurity role and leads professionals into intermediate-level cybersecurity jobs.

Netsol-NOSAuthor Commented:
Thanks Qlemo.

Please see that there are two folders
Programfiles
Programfles (x86)

I CAN SEE FOLDERS of  SQL Server 2008 R2 Native Client installed on both folders. BUT I DO NOT KNOW WHICH VERSION IS INSTALLED IS IT 32 BIT or 64 BIT ?
0
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
The 64bit installer installs in both folders, if I recall correctly. Don't get confused - it is as I stated above.
0
Netsol-NOSAuthor Commented:
So you are 100% SURE that sqlncli.msi 32 bit will not installed on 64 Bit Operating System ?
0
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
Yes. Just try yourself, Setup should tell you are "doing wrong".
0
Netsol-NOSAuthor Commented:
Thanks,
Just give me 2 hours let me connect GTM and check the server.
0
ste5anSenior DeveloperCommented:
Check the drivers page of odbcad32:

- (32-bit) %WINDIR%\SysWOW64\odbcad32.exe
- (64-bit) %WINDIR%\System32\odbcad32.exe
0
Paul JacksonSoftware EngineerCommented:
Actually both versions of SQL Native Client are installed on 64 bit OS because there might be 32 bit processes running on the 64 bit operating system that require the 32 bit version of SQL Native client.

The x64 and Itanium versions of sqlncli.msi also install the 32-bit version of SQL Server Native Client...

https://docs.microsoft.com/en-us/sql/relational-databases/native-client/applications/installing-sql-server-native-client?view=sql-server-2017

Why are you trying to determine what is installed in the first place? It shouldn't matter as the appropriate client will be used  depending on whether a 32 bit process or a 64 bit process is running
0
bbaoIT ConsultantCommented:
> The 64bit installer installs in both folder

correct. 64-bit client does install 32-bit component for best compatibility  and stability. therefore 32-bit installation folder (or "C:\Program Files (x86)" is not a condition to determine which installer it is as it must be installed. 64-bit installation folder is the thing to check.
0
Netsol-NOSAuthor Commented:
Please see screenshot when i tried to install 32 SQL NATIVE CLIENT of 2008 R2 on 64 Bit OS.
05-Sep-18-2-42-03-PM.jpg
0
ste5anSenior DeveloperCommented:
The actual version is downloadable at

Microsoft® SQL Server® 2012 Feature Pack
0
Netsol-NOSAuthor Commented:
i am not requesting for downloading link ..
How to determine which BIT is installed on my server.

It is clear i tried to install 32 bit on 64 bit and it does not install.
And i tried to REINSTALL 64 bit and its setup works.
0
Paul JacksonSoftware EngineerCommented:
As I stated you only need to install x64 version as it will also install a x32 version using the x64 install msi. There is no need to use the x32 install at all
0
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
The only thing to care about is to run the 64bit package on 64bit and the 32bit one on 32bit OS.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Experts Exchange

From novice to tech pro — start learning today.