Skip to main content

Notifications

Microsoft Dynamics GP forum
Answered

Identify the SQL Server used in GP

Posted on by 395

Hi,

I need to identify the name of the SQL Server to where GP is connected, I already check the ODBC's configuration but there's no reffence to GP. Also checked the SQL directory in the GP installation but it only have .dll's

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    Re: Identify the SQL Server used in GP

    If you search for 32 bit odbc 64 bit computer or other variations there of, you wouild find it.

    support.microsoft.com/.../942976

    Here is the technical blurb.

  • Edie Williams Profile Picture
    Edie Williams 395 on at
    Re: Identify the SQL Server used in GP

    Thanks, I would never found this by myself, after days on google...

  • Verified answer
    Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    Re: Identify the SQL Server used in GP

    the ODBC connection to GP is done via a 32-bit ODBC driver. If you are on a 64 bit computer and just go to Admin Tools->ODBC you will not see anything. Go out to your Windows folder and then SysWOW64 and look for ODBCAD32.exe.

Helpful resources

Quick Links

Dynamics 365 Community Update

Welcome to the inaugural Community Platform Update. As part of our commitment to…

Dynamics 365 Community Newsletter - August 2024

Catch up on the latest D365 Community news

Community Spotlight of the Month

Kudos to Mohana Yadav!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 227,969 Super User 2024 Season 2

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans