Dynamics GP 2016 not installing ODBC Connector properly during Setup

(0) Share

Report

Posted on by Community Member

Please suggest a fix or alternative route to fix this problem, if possible. I'm installing the Dynamics GP 2016 Client software on a user's laptop and for some reason it is not installing its ODBC Connector properly during Setup. It keeps throwing me this error: (This is occurring on a Windows 7 Pro x64 bit edition OS) Many thanks in advance!

*This post is locked for comments

I have the same question (0)

All responses (12)

Answers (1)

L Vail 65,271 on at

Like (1)

Report

RE: Dynamics GP 2016 not installing ODBC Connector properly during Setup

Hi,

I've not run into this before. What happens if you manually try to create the 32-bit ODBC on this machine named Dynamics GP 2016?

As an aside, I love your profile picture :)

Leslie

Was this reply helpful? Yes No
Victoria Yudin 22,768 on at

Like (1)

Report

RE: Dynamics GP 2016 not installing ODBC Connector properly during Setup

This is one of the reasons I never have the ODBC created automatically. :-) Once in a while it does something crazy.

Add me to the likes for that profile picture!

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

RE: Dynamics GP 2016 not installing ODBC Connector properly during Setup

I will try this and let you know my results, thanks!! --Mark

P.S.: Yes, I ran across that picture and thought it was fitting! :D

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

RE: Dynamics GP 2016 not installing ODBC Connector properly during Setup

Ok, I manually added the ODBC connector of type "SQL Server Native Client 11.0" to the User DSN and now I can see that 'ServerName' and select it, however when I attempt to logon to it thru GP Utilities for the first time setup, I get this new error:

Was this reply helpful? Yes No
twelvestrikes 3,657 on at

Like (1)

Report

RE: Dynamics GP 2016 not installing ODBC Connector properly during Setup

Hi DynamicMark

Make sure that you have setup a 32bit ODBC driver and not the 64bit ODBC driver

Was this reply helpful? Yes No
Bill Campbell 12 on at

Like (0)

Report

RE: Dynamics GP 2016 not installing ODBC Connector properly during Setup

Just my two cents - but you stated User DNS - I have always been installing the ODBC in the SYSTEM DSN

Not sure it makes a difference - but I have to say I have never tried it from anywhere else.

Was this reply helpful? Yes No
KirkLivermont 5,985 on at

Like (1)

Report

RE: Dynamics GP 2016 not installing ODBC Connector properly during Setup

Make sure you are using a driver for your exact SQL version. I just had a similar problem with a 11.00.3XXX version of the driver which required manually updating it to version 11.00.6XXX.

Sorry for the Xs. I can't recall the exact build numbers.

Regards,

Kirk

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (1)

Report

RE: Dynamics GP 2016 not installing ODBC Connector properly during Setup

This problem turned out to be a corrupt C:\Windows\SysWOW64\ODBCCP32.DLL file in relation to the ODBC Connector with the laptop's OS. I had never seen this happen before now! Thanks for the assistance!!

Was this reply helpful? Yes No
Victoria Yudin 22,768 on at

Like (0)

Report

RE: Dynamics GP 2016 not installing ODBC Connector properly during Setup

Wow - in all my years of installing GP, I've never seen that. Thanks for letting us know what it was!

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Dynamics GP 2016 not installing ODBC Connector properly during Setup

An ODBC connection is like the 'address and driving directions' for the application on your local computer to know how to get to the data on your SQL server UPSers.

Was this reply helpful? Yes No