Go Back   Access World Forums > Apps and Windows > SQL Server

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 03-15-2019, 01:19 AM   #1
Tera
Newly Registered User
 
Join Date: Feb 2019
Posts: 93
Thanks: 127
Thanked 5 Times in 5 Posts
Tera is on a distinguished road
How to install SQL Server native Client 11.0?

I'm trying to download and install SQL Server Native Client 11.0 on some of our machines. At present they have only SQL Server driver.

According to This Microsoft Document I must download and install SQL Server 2012 Feature pack.

Clicking the link provided in mentioned page leads me to this page.. But I can't find the feature Pack in download list.

I don't want to install the whole SQL express.
Can anybody explain which one has to be downloaded?


thanks.

Tera is offline   Reply With Quote
Old 03-15-2019, 01:29 AM   #2
Minty
AWF VIP
 
Minty's Avatar
 
Join Date: Jul 2013
Location: UK - Wiltshire
Posts: 6,082
Thanks: 143
Thanked 1,636 Times in 1,608 Posts
Minty has a spectacular aura about Minty has a spectacular aura about Minty has a spectacular aura about
Re: How to install SQL Server native Client 11.0?

I think this page has what you need https://www.microsoft.com/en-gb/down....aspx?id=36434
__________________
If we have helped please add to our reputation - click the scales symbol on the left, tick 'I approve' and leave a comment.

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Minty is offline   Reply With Quote
The Following User Says Thank You to Minty For This Useful Post:
Tera (03-15-2019)
Old 03-15-2019, 01:35 AM   #3
Tera
Newly Registered User
 
Join Date: Feb 2019
Posts: 93
Thanks: 127
Thanked 5 Times in 5 Posts
Tera is on a distinguished road
Re: How to install SQL Server native Client 11.0?

Million thanks.
As always you are the one


EDIT:
I downloaded and installed it. But the installed driver name is ODBC Driver 11 for SQL Server

I need it to be the exact same name as SQL Server native Client 11.0 because FE uses this driver to connect to sql server.

Any further advice is much appreciated.


Last edited by Tera; 03-15-2019 at 01:44 AM.
Tera is offline   Reply With Quote
Old 03-15-2019, 02:02 AM   #4
Minty
AWF VIP
 
Minty's Avatar
 
Join Date: Jul 2013
Location: UK - Wiltshire
Posts: 6,082
Thanks: 143
Thanked 1,636 Times in 1,608 Posts
Minty has a spectacular aura about Minty has a spectacular aura about Minty has a spectacular aura about
Re: How to install SQL Server native Client 11.0?

Try here https://www.connectionstrings.com/sq...-and-download/

Think that is exactly what you need.

I have actually moved every one onto Microsoft SQL Server 2012 Native Client , as it was easily found.
__________________
If we have helped please add to our reputation - click the scales symbol on the left, tick 'I approve' and leave a comment.

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Minty is offline   Reply With Quote
The Following User Says Thank You to Minty For This Useful Post:
Tera (03-16-2019)
Old 03-15-2019, 03:36 PM   #5
Tera
Newly Registered User
 
Join Date: Feb 2019
Posts: 93
Thanks: 127
Thanked 5 Times in 5 Posts
Tera is on a distinguished road
Re: How to install SQL Server native Client 11.0?

Quote:
Originally Posted by Minty View Post
Try here https://www.connectionstrings.com/sq...-and-download/

Think that is exactly what you need.
The page you sent gives a link for downloading Native Client 11.0 ODBC Driver which sends me to another page. At the bottom of this page there's a link for downloading SQL Server 2012 Feature pack which in turn sends me to Microsoft download page with more than 50 msi links for downloading different features, none of them native client 11.

Quote:
Originally Posted by Minty View Post
I have actually moved every one onto Microsoft SQL Server 2012 Native Client , as it was easily found.
How exactly? It's the same thing I'm trying to do. What exactly I should download and where?


Thanks again for your time.
Tera is offline   Reply With Quote
Old 03-15-2019, 04:39 PM   #6
Minty
AWF VIP
 
Minty's Avatar
 
Join Date: Jul 2013
Location: UK - Wiltshire
Posts: 6,082
Thanks: 143
Thanked 1,636 Times in 1,608 Posts
Minty has a spectacular aura about Minty has a spectacular aura about Minty has a spectacular aura about
Re: How to install SQL Server native Client 11.0?

Sorry I'm away from the PC for the weekend. Hopefully someone else might help, if not Monday!

Sent from my SM-G955F using Tapatalk
__________________
If we have helped please add to our reputation - click the scales symbol on the left, tick 'I approve' and leave a comment.

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Minty is offline   Reply With Quote
The Following User Says Thank You to Minty For This Useful Post:
Tera (03-15-2019)
Old 03-15-2019, 08:12 PM   #7
AccessBlaster
.
 
Join Date: May 2010
Posts: 977
Thanks: 22
Thanked 250 Times in 239 Posts
AccessBlaster has a spectacular aura about AccessBlaster has a spectacular aura about
Re: How to install SQL Server native Client 11.0?

Tera,
Steve Bishop has a video series on this subject.

HTH

https://www.youtube.com/user/Program...rch?query=odbc

AccessBlaster is offline   Reply With Quote
The Following User Says Thank You to AccessBlaster For This Useful Post:
Tera (03-16-2019)
Old 03-15-2019, 09:14 PM   #8
Tera
Newly Registered User
 
Join Date: Feb 2019
Posts: 93
Thanks: 127
Thanked 5 Times in 5 Posts
Tera is on a distinguished road
Re: How to install SQL Server native Client 11.0?

Quote:
Originally Posted by AccessBlaster View Post
Tera,
Steve Bishop has a video series on this subject.

HTH

https://www.youtube.com/user/Program...rch?query=odbc
Thanks for your input.
I've almost watched them all. He shows how to program it. But never explained how we can install the driver. I know that installing SQL server on a machine, will install native client 11.0 driver too. But I don't want go installing SQL server on all our machines just to use the driver to access a database on another server.

There should be a way to install the driver only. and I'm still searching google to see if I can find how to.

thanks
Tera is offline   Reply With Quote
Old 03-16-2019, 01:12 AM   #9
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 8,628
Thanks: 102
Thanked 2,278 Times in 2,099 Posts
isladogs is a name known to all isladogs is a name known to all isladogs is a name known to all isladogs is a name known to all isladogs is a name known to all isladogs is a name known to all
Re: How to install SQL Server native Client 11.0?

Try this link for SQL Server Native Client 2012
https://www.microsoft.com/en-us/down....aspx?id=29065
Its one of many 2012 related downloads on that page.

Or if you're going for a newer version, why not jump to 2014, 2016 etc version instead as these are likely to stay available for longer
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
isladogs is offline   Reply With Quote
The Following User Says Thank You to isladogs For This Useful Post:
Tera (03-16-2019)
Old 03-16-2019, 08:40 AM   #10
Tera
Newly Registered User
 
Join Date: Feb 2019
Posts: 93
Thanks: 127
Thanked 5 Times in 5 Posts
Tera is on a distinguished road
Re: How to install SQL Server native Client 11.0?

Quote:
Originally Posted by isladogs View Post
Try this link for SQL Server Native Client 2012
https://www.microsoft.com/en-us/down....aspx?id=29065
Its one of many 2012 related downloads on that page.

Or if you're going for a newer version, why not jump to 2014, 2016 etc version instead as these are likely to stay available for longer
According to this page there is no native client in 2016 version. The latest is from sql server 2012.

Iíll check your link Monday morning as soon as Iím back to my desk.

Thanks
Tera is offline   Reply With Quote
Old 03-16-2019, 03:02 PM   #11
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 8,628
Thanks: 102
Thanked 2,278 Times in 2,099 Posts
isladogs is a name known to all isladogs is a name known to all isladogs is a name known to all isladogs is a name known to all isladogs is a name known to all isladogs is a name known to all
Re: How to install SQL Server native Client 11.0?

Thanks for posting that.
It would appear that the SQL Native Client is also no longer recommended.
According to this link https://docs.microsoft.com/en-us/sql...ql-server-2017, MS have 'undeprecated' (a word I've never heard before) the OLE DB Driver for SQL Server and that will be updated in any future releases
I've only skimmed over the links so far but I'm now, to put it mildly, somewhat confused. I will need to read all those links carefully later to take in exactly what action is appropriate.

Very tempting to suggest you stick with the old driver that's still around and supplied with Access.

__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Last edited by isladogs; 03-17-2019 at 01:39 AM.
isladogs is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
SQL Server Native Client 11.0 - Some advice please NauticalGent SQL Server 8 09-10-2018 06:42 AM
SQL Server - ODBC - SQL Server Native Client Registry Bat File Rx_ SQL Server 0 01-28-2016 03:16 PM
ODBC 42S22 Error for SQL Server Native Client for GIS workstation Rx_ Code Repository 0 07-01-2014 08:18 AM
Attach DSNLessTable for SQL Server Native Client 10.0 Rx_ Code Repository 0 04-05-2012 01:19 PM
SQL Server 2008 MDAC ODBC Native Client 10 Rx_ SQL Server 5 04-08-2010 11:32 AM




All times are GMT -8. The time now is 12:53 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World