When installing Microsoft Dynamics GP on an x64 OS such as Windows Server 2008 R2 the Data Sources (ODBC) in Control Panel cannot be used as this will create an x64 data source whereas Microsoft Dynamics GP will only work with an x86 data source.
An x86 ODBC connection can be created by using the Data Sources (ODBC) which is located in %windir%\syswow64\odbcad32.exe. You can navigate to it using Windows Explorer or by using the Windows Run command;
About Ian Grieve
Ian is a Microsoft Dynamics GP certified consultant specialising in the delivery of Microsoft Dynamics GP projects and currently working for
Perfect Image Ltd., a Microsoft Partner and VAR in the North East of England.
Ian has worked with Microsoft Dynamics GP since 2003 and, over the nine years since, has dealt with all aspects of the product life-cycle from presales, to implementation, to technical and functional training, to post go-live support and subsequent upgrades and process reviews.
In his spare time, Ian runs the azurecurve | Ramblings of a Dynamics GP Consultant blog dedicated to Microsoft Dynamics GP and related products.
Pingback: Missing Data Source When Installing Microsoft Dynamics GP 2010 | azurecurve