web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / GP ODBC Connection
Microsoft Dynamics GP (Archived)

GP ODBC Connection

(0) ShareShare
ReportReport
Posted on by Community Member

When installing GP 2010, I have the choice to go with the default ODBC connection or create my own.  Whenever I chose to create my own, it's not seen by GP.  Whenever I let GP create it, I can't see it in the DSN lists.  I'm assuming that it is somewhere within Dexterity. 

The manual goes into detail about the naming convention of the default ODBC, but doesn't tell you anything about creating your own. My question is, how do I create my own ODBC and have GP recognize it?

 

Thanks

*This post is locked for comments

I have the same question (0)
  • K Day Profile Picture
    K Day 7,365 on at
    Re: GP ODBC Connection

     This is what I might try.  But I have not seen GP 2010 yet.

    Control Panel, Administrative Tools, Data Sources.  Go to System DSN's (not sure if this makes a difference).  You shoudl see the similar ones that you see in your GP drop down list between the Local and System ones.

    Create a new one,  SQL Native Client, fill out the information, I use SQL server Auth but uncheck the box to connect and get default settings.  I suppose you could enter the sa password here, but not a normal GP user as it won't work.  I always leave all the check boxes unchecked and Finish.

    That's always worked for me.  Let me know how it goes.

  • Aaron Axvig Profile Picture
    Aaron Axvig on at
    Re: GP ODBC Connection

    If you are on a 64-bit machine there are two versions of the ODBC Data Source Administrator.  Their locations are described here: http://support.microsoft.com/kb/942976

     If you open the 32-bit obdcad32.exe (even the 64-bit exe has "32" in the name) you should be able to see the "Dynamics GP 2010" System DSN.  It looks like the 64-bit obdcad32.exe is what will be launched if you use any of the Windows Shell entries to launch it.

  • Community Member Profile Picture
    Community Member on at
    Re: Re: GP ODBC Connection

    [quote user="Aaron Axvig"]

    If you are on a 64-bit machine there are two versions of the ODBC Data Source Administrator.  Their locations are described here: http://support.microsoft.com/kb/942976

     If you open the 32-bit obdcad32.exe (even the 64-bit exe has "32" in the name) you should be able to see the "Dynamics GP 2010" System DSN.  It looks like the 64-bit obdcad32.exe is what will be launched if you use any of the Windows Shell entries to launch it.

    [/quote] 

     

    ooooh yeah.  forgot about that.  

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans