Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Suggested answer

Dynamics Gp 2018.5 on SQL 2019

Posted on by 5
Can anyone steer me on how to get clinets to connect to a SQL 2019 box.  All ODBC connections created through the installer are SNAC, and I am totally stumped on how to make my clients access it through the new OLEDB driver.
 
When I create an OLEDB connection or ODBC connection, they are not available in teh list of options when I launch Dynamics GP
 
Any help would be appreciated!
  • Suggested answer
    Lisa at AonC.com Profile Picture
    Lisa at AonC.com 3,024 on at
    Dynamics Gp 2018.5 on SQL 2019
    Have you allowed the required SQL ports through your firewall?
  • Dynamics Gp 2018.5 on SQL 2019
    Lance,
     
    I see the 32bit ODBC, but SQL Native Client isnt supported on SQL Server 2019...so I cant even create it for our new SQL server.  I can point it to the old SQL 2104 box no problem, but we want to move to SQL Server 2019, and cant point any clients to that machine.
     
    We cant even create a native client connection to 2019!
     
    I know I am missing something super obvious, but cant figure it out!
  • lancebrigham Profile Picture
    lancebrigham 119 on at
    Dynamics Gp 2018.5 on SQL 2019
    Hello User,
     
    To my knowledge you'll only see ODBC options listed that were created using the SQL Server Native Client 11.0 driver. It must be created as a 32-bit ODBC and not 64-bit (launch odbacad32.exe from c:\windows\syswow64 and not c:\windows\system32).
     
    Are you not even seeing the ODBC created by the installer as an option to use?

    Lance Brigham
    Principal Consultant
    Velosio

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,558 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,647 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans