How to create 32 bit ODBC data sources for Dynamics GP from a 64 bit server.

Hi folks , this is a real quick handy hint. As you are probably no doubt aware Dynamics GP can not see 64 bit ODBC although it is compatable with  64 bit operating systems (versions 10 and 2010 only, service pack specific).

The 32 bit drivers are still on the server however if you create a datasource through ODBC settings it will create a 64 bit one by default.

To access the 32 bit drivers:

1. Browse out to %systemdrive%\Windows\SysWoW64\odbcad32.exe

2. Created short cut on desk top to odbcad32.exe

3. Created 32 bit odbc using odbcad32.exe

You will then have 32 bit ODBC datasources.