423,103 Members | 1,428 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 423,103 IT Pros & Developers. It's quick & easy.

SQL Server Native Client 11.0 - Some advice please

Nauticalgent
P: 64
Good morning Bytes,

I have posted this question in some other forums - I am casting a wide net because I need some good advice.

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?
1 Week Ago #1
Share this Question
Share on Google+
3 Replies


Nauticalgent
P: 64
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.

<<ZMBD<Removed broken link>>>

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...
1 Week Ago #2

zmbd
Expert Mod 5K+
P: 5,202
Nauticalgent:
This is a bit out of my realm; however, looking for something to replace the broken link in your last post
https://docs.microsoft.com/en-us/sql...ql-server-2017
1 Week Ago #3

Nauticalgent
P: 64
Hello there Z, seems editing my posts have become a full time jibe for you :)

Iíll try to be more diligent in the future...

If you are curious, here is the link to where I cross-posted...it gained some traction there and some very good replies:

http://www.utteraccess.com/forum/ind...&#entry2692066
1 Week Ago #4

Post your reply

Sign in to post your reply or Sign up for a free account.