Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Microsoft SQL Server Native Client install Expand / Collapse
Author
Message
Posted Friday, September 18, 2009 9:30 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, February 25, 2010 1:26 PM
Points: 58, Visits: 184

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.




Post #790482
Posted Friday, September 18, 2009 9:38 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, May 22, 2014 9:05 AM
Points: 201, Visits: 391
Why do you want to install SS native client on App server? I am just curious.
Post #790495
Posted Friday, September 18, 2009 9:45 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, February 25, 2010 1:26 PM
Points: 58, Visits: 184
It was the requirement for the application.
Post #790505
Posted Friday, September 18, 2009 9:47 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, February 25, 2010 1:26 PM
Points: 58, Visits: 184
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?
Post #790506
Posted Friday, September 18, 2009 9:59 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, May 22, 2014 9:05 AM
Points: 201, Visits: 391
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.
Post #790513
Posted Friday, September 18, 2009 12:32 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, February 25, 2010 1:26 PM
Points: 58, Visits: 184
NAtive client is application's requirement.but don't know why they need that. HOw can we say MDAC is installed ?
Post #790620
Posted Friday, September 18, 2009 12:43 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, May 22, 2014 9:05 AM
Points: 201, Visits: 391
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.
Post #790631
Posted Friday, September 18, 2009 12:47 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, February 25, 2010 1:26 PM
Points: 58, Visits: 184
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.
Post #790634
Posted Friday, September 18, 2009 12:53 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, May 22, 2014 9:05 AM
Points: 201, Visits: 391
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:

http://support.microsoft.com/kb/301202
Post #790641
Posted Friday, September 18, 2009 12:57 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, May 22, 2014 9:05 AM
Points: 201, Visits: 391
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.
Post #790647
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse