O'Reilly logo

Microsoft Dynamics GP 2010 Implementation by Victoria Yudin

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating an ODBC data source

Every computer that needs to run the Dynamics GP application will need to have an ODBC (Open Database Connectivity) data source pointing to the SQL Server. This is true for all servers and workstations, including the server where SQL Server is installed.

Even though Dynamics GP is supported on 64-bit operating systems, it is a 32-bit application and requires a 32-bit ODBC data source. To create the ODBC data source on a 64-bit operating system, run the Odbcad32.exe file, found in the C:\Windows\SysWOW64\ directory instead of following Step 1 as shown in the following section, then follow the steps starting with Step 2.

Steps to create the ODBC data source

The following are steps to create the ODBC data source for Dynamics ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required