September 18, 2009 at 9:30 am
X86 Package (sqlncli.msi) - 3516 KB
X64 Package (sqlncli_x64.msi) - 6403 KB
Should i install 32 bit or 64 bit Microsoft SQL Server Native on application server? THe backend database server for this application is sql server 2005 sp2 64 bit.
September 18, 2009 at 9:38 am
Why do you want to install SS native client on App server? I am just curious.
September 18, 2009 at 9:45 am
It was the requirement for the application.
September 18, 2009 at 9:47 am
FYI, application will even uses analysis services. May be for analysis services. It need sql server backward compability apart from native client. I even have question should i install 32 bit or 64 bit on 32 app server to connect to 64 bit sql server?
September 18, 2009 at 9:59 am
I don't think you have to install anything even if you have MDAC application.
The Windows already has MDAC components including SQL Sever native client, you just may want to check it version.
September 18, 2009 at 12:32 pm
NAtive client is application's requirement.but don't know why they need that. HOw can we say MDAC is installed ?
September 18, 2009 at 12:43 pm
NAtive client is application's requirement.
Yes, I understand. I am just think it is already installed with MDAC.
There are two different ways to check which version of Microsoft Data Access Components (MDAC) is installed on a system:
-Use the Component Checker tool.
-Check the version information that is stored in the registry.
September 18, 2009 at 12:47 pm
I even can't find out if MDAC is installed or not. HOw i can find that? I will worry about version later once i know MDAC is installed.
September 18, 2009 at 12:53 pm
It is not about version. The only way to find MDAC is verify the version. If you see the version, something like 2.0, that means you have it installed.
This is link, and I would recommend the second way there:
September 18, 2009 at 12:57 pm
Here is how to check it through Registries:
The version information is found in the following key:
HKEY_LOCAL_MACHINE\Software\Microsoft\DataAccess\FullInstallVer
To check the registry, follow these steps:
On the Start menu, click Run.
In the Open text box, type regedit and then click OK; this starts Registry Editor.
In the Navigation pane, drill-down to the following path:
HKEY_LOCAL_MACHINE\Software\Microsoft\DataAccess
In the Details pane, look in the Name column for FullInstallVer and Version. Each of these keys will have corresponding version information in the Data column.
When finished, click Exit on the Registry menu to close Registry Editor.
September 18, 2009 at 1:20 pm
Thank you for the information. Ya it is installed.
However i found the answer for my problem. I think i have install 32 bit sql server combatibility components in app server becasue 64 bit can't be installed on 32 bit OS.
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply