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

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 08-03-2018, 11:34 PM   #1
NauticalGent
Pristine Curmudgeon
Gold Supporter
 
NauticalGent's Avatar
 
Join Date: Apr 2015
Location: Naples, Italy (EXPAT from Virginia)
Posts: 1,493
Thanks: 318
Thanked 190 Times in 168 Posts
NauticalGent has a spectacular aura about NauticalGent has a spectacular aura about
SQL Server Native Client 11.0 - Some advice please

Good morning AWF,

We have recently upgraded from SQL Server 2008 to 2014 two days ago and the smoke has finally settled. I thought about making a post about the pit-falls (error 44447 and 44446) but since there are NO entries on this forum or any other I frequent I figured it was so infrequent it wouldn't be worth it.

While I was making the DSN for my App, I chose the SQL Server Native Client 11.0 driver and it worked like a charm on my computer but when I deployed it, no one else could use it. It appears that when IT installed SSMS on my machine, the 11.0 driver was installed and no other machine has it.

I changed the driver to the generic SQL driver and all is right in the world.

My question is this, is it worth my time and effort trying to get IT to push this driver to everyone or should I just leave well enough alone?

We are currently using Win 10 64 bit / Office 2013 32 bit. Our IT department are contractors from General Dynamics and the meet any suggestions like this as an all-out attack on cyber security and my argument is going to have to be ultra-compelling.

The fact that it is working as-is will work against just about anything I can come up with so I am hopping to get some pearls of wisdom from some of you.

Is the juice worth the squeeze?

Edit: I will be posting this on the "other" forum most of you frequent so don't give me no sass when you see it!

Edit 2.0
Post from AccessForums.net:
http://www.accessforums.net/showthre...098#post405098

Post from UA:
http://www.utteraccess.com/forum/ind...&#entry2692032
I have actually received a few responses on there, I will share the one that provide a solution

Post from Bytes:
https://bytes.com/topic/sql-server/a...-advice-please

__________________
“I had the RIGHT to remain silent...but I didn’t have the ABILITY.” - Ron White

Last edited by NauticalGent; 08-04-2018 at 04:36 AM. Reason: Post the x-post links due to being gently chastised by Ridders :)
NauticalGent is offline   Reply With Quote
Old 08-04-2018, 03:58 AM   #2
ridders
Part time moderator
 
ridders's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 6,128
Thanks: 83
Thanked 1,508 Times in 1,408 Posts
ridders is just really nice ridders is just really nice ridders is just really nice ridders is just really nice ridders is just really nice
Re: SQL Server Native Client 11.0 - Some advice please

I've found this on 4 forums so far...have I missed any?

Please can you post the links to each of the forum posts.
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

New example databases:

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.
,
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.

-----------------------------------------------------------------------------------
nil illegitimi carborundum est
ridders is offline   Reply With Quote
Old 08-04-2018, 04:06 AM   #3
NauticalGent
Pristine Curmudgeon
Gold Supporter
 
NauticalGent's Avatar
 
Join Date: Apr 2015
Location: Naples, Italy (EXPAT from Virginia)
Posts: 1,493
Thanks: 318
Thanked 190 Times in 168 Posts
NauticalGent has a spectacular aura about NauticalGent has a spectacular aura about
Re: SQL Server Native Client 11.0 - Some advice please

Quote:
Originally Posted by ridders View Post
I've found this on 4 forums so far...have I missed any?
Only if you’re a member of a Yahoo News Group called Access Professionals (some really smart and helpful individuals on there but the format and readability leaves much to be desired) and two groups on LinkedIn!

Wasn’t aware of the sharing the links protocol but I will take your word for it.

__________________
“I had the RIGHT to remain silent...but I didn’t have the ABILITY.” - Ron White
NauticalGent is offline   Reply With Quote
Old 08-04-2018, 04:13 AM   #4
ridders
Part time moderator
 
ridders's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 6,128
Thanks: 83
Thanked 1,508 Times in 1,408 Posts
ridders is just really nice ridders is just really nice ridders is just really nice ridders is just really nice ridders is just really nice
Re: SQL Server Native Client 11.0 - Some advice please

Quote:
Originally Posted by NauticalGent View Post
Only if you’re a member of a Yahoo News Group called Access Professionals (some really smart and helpful individuals on there but the format and readability leaves much to be desired) and two groups on LinkedIn!

Wasn’t aware of the sharing the links protocol but I will take your word for it.
Not a member and hadn't heard of it ... i'm far too unprofessional

The linking part is important and is included on the standard advice: https://www.excelguru.ca/content.php...-cross-posters

Let us know when you get some useful advice
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

New example databases:

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.
,
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.

-----------------------------------------------------------------------------------
nil illegitimi carborundum est

Last edited by ridders; 08-04-2018 at 05:01 AM.
ridders is offline   Reply With Quote
Old 08-04-2018, 04:30 AM   #5
NauticalGent
Pristine Curmudgeon
Gold Supporter
 
NauticalGent's Avatar
 
Join Date: Apr 2015
Location: Naples, Italy (EXPAT from Virginia)
Posts: 1,493
Thanks: 318
Thanked 190 Times in 168 Posts
NauticalGent has a spectacular aura about NauticalGent has a spectacular aura about
Re: SQL Server Native Client 11.0 - Some advice please

Quote:
Originally Posted by ridders View Post
... i'm far too unprofessional
Me too and just about 92.7% of the members! This was actually my first post.

Quote:
Originally Posted by ridders View Post
The linking part is important and is included on the standard advice: https://www.excelguru.ca/content.php...-cross-posters
Somehow I KNEW you were going to respond this way. You remove the man from teaching but you cant remove teaching from the man...

Quote:
Originally Posted by ridders View Post
Let us know when you get some useful advice
Will do.
__________________
“I had the RIGHT to remain silent...but I didn’t have the ABILITY.” - Ron White
NauticalGent is offline   Reply With Quote
Old 08-04-2018, 05:38 AM   #6
NauticalGent
Pristine Curmudgeon
Gold Supporter
 
NauticalGent's Avatar
 
Join Date: Apr 2015
Location: Naples, Italy (EXPAT from Virginia)
Posts: 1,493
Thanks: 318
Thanked 190 Times in 168 Posts
NauticalGent has a spectacular aura about NauticalGent has a spectacular aura about
Re: SQL Server Native Client 11.0 - Some advice please

From UA member CheekyBuddha:

This 2017 article from MS recommends not to use the Native client going forwards and to use the OLE DB driver instead.

https://docs.microsoft.com/en-us/SQL...QL-server-2017

Doesn't really solve my situation but if I am going to chase this rabbit down a rabbit hole, at least I will chase the right one - until MS changes their minds again...
__________________
“I had the RIGHT to remain silent...but I didn’t have the ABILITY.” - Ron White
NauticalGent is offline   Reply With Quote
Old 08-04-2018, 08:24 AM   #7
sonic8
Newly Registered User
 
Join Date: Oct 2015
Posts: 111
Thanks: 20
Thanked 35 Times in 34 Posts
sonic8 is on a distinguished road
Re: SQL Server Native Client 11.0 - Some advice please

Quote:
Originally Posted by NauticalGent View Post
My question is this, is it worth my time and effort trying to get IT to push this driver to everyone or should I just leave well enough alone?
Well, I think the fact that you, as the developer of the application, need to ask this, is a strong indicator that the answer is: No!


If *you* are not able to name any particular feature that is in SQL-Server Native Client, but not in the plain old SQL-Server ODBC driver that your application needs, then there is not much point in forcing the IT guy to upgrade.
- Form my experience, the most commonly missed feature in the old ODBC driver is support for the new Date and DateTime2 data types in SQL-Server.

__________________
New Video:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
sonic8 is offline   Reply With Quote
The Following User Says Thank You to sonic8 For This Useful Post:
NauticalGent (08-04-2018)
Old 08-04-2018, 08:36 AM   #8
NauticalGent
Pristine Curmudgeon
Gold Supporter
 
NauticalGent's Avatar
 
Join Date: Apr 2015
Location: Naples, Italy (EXPAT from Virginia)
Posts: 1,493
Thanks: 318
Thanked 190 Times in 168 Posts
NauticalGent has a spectacular aura about NauticalGent has a spectacular aura about
Re: SQL Server Native Client 11.0 - Some advice please

Quote:
Originally Posted by sonic8 View Post
- Form my experience, the most commonly missed feature in the old ODBC driver is support for the new Date and DateTime2 data types in SQL-Server.
Very pragmatic answer Sonic8, thank you. A member of UA pretty much said the same thing, however, unlike you he thinks I should install the most current driver for the sake of having the most current driver. And normally I would agree...

But, as you have pointed out, I cannot point to any particular feature to warrant me doing so. My app uses SQL Server solely because my previous set-up which involves Sharepoint was no longer viable. I use only one Pass through query and that was just to experiment with how they work. In other words, I use SQL Server solely as a BE storage and, with the exception of its awesome maintenance plans, nothing else.

In the future I may look at stored procedures and the other features that make SQL an enterprise level option but for now I will keep it simple.

Thanks for the sanity check...

John
__________________
“I had the RIGHT to remain silent...but I didn’t have the ABILITY.” - Ron White
NauticalGent is offline   Reply With Quote
Old 09-10-2018, 06:42 AM   #9
SQL_Hell
SQL Server DBA
 
SQL_Hell's Avatar
 
Join Date: Dec 2003
Location: UK
Posts: 1,323
Thanks: 15
Thanked 39 Times in 37 Posts
SQL_Hell will become famous soon enough
Re: SQL Server Native Client 11.0 - Some advice please

Yes 100% use the native client 11.0 driver for both SQL server 2012 and 2014,

I have seen some nasty results of using the incorrect driver with a latter version of SQL Server

SQL_Hell 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 - 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
Client Server Advice Len Boorman General 1 11-21-2002 05:22 AM




All times are GMT -8. The time now is 02:31 AM.


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

Sponsored Links

How to advertise

Media Kit


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