Netsol-NOS
asked on
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
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
check add remove programs?
ASKER
32 or 64 is not mentioned there.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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 ?
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 ?
The 64bit installer installs in both folders, if I recall correctly. Don't get confused - it is as I stated above.
ASKER
So you are 100% SURE that sqlncli.msi 32 bit will not installed on 64 Bit Operating System ?
Yes. Just try yourself, Setup should tell you are "doing wrong".
ASKER
Thanks,
Just give me 2 hours let me connect GTM and check the server.
Just give me 2 hours let me connect GTM and check the server.
Check the drivers page of odbcad32:
- (32-bit) %WINDIR%\SysWOW64\odbcad32 .exe
- (64-bit) %WINDIR%\System32\odbcad32 .exe
- (32-bit) %WINDIR%\SysWOW64\odbcad32
- (64-bit) %WINDIR%\System32\odbcad32
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.
https://docs.microsoft.com /en-us/sql /relationa l-database s/native-c lient/appl ications/i nstalling- sql-server -native-cl ient?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
The x64 and Itanium versions of sqlncli.msi also install the 32-bit version of SQL Server Native Client...
https://docs.microsoft.com
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
> 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.
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.
ASKER
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
05-Sep-18-2-42-03-PM.jpg
ASKER
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.
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.
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
The only thing to care about is to run the 64bit package on 64bit and the 32bit one on 32bit OS.