Crystal Report ODBC Data Source setup in GoldMine Report Center on 64-bit Operating Systems[Uploaded File]

Version 1

    Details

    [64-bit Operating Systems – The Problem

    Since GoldMine Premium Edition 8.5.x FrontRange Solutions/GoldMine supports Windows 2008 Server 64-bit as server Operating system as GoldMine Premium Edition application server. Additionally from GoldMine Premium Edition 9.x onwards also Windows 7 64-bit as Clients or Remote systems is certified and a supported Operating system.

    In relation to the usual ODBC Administrator tool Microsoft wanted to ‘To maintain backward compatibility ….’  (see http://support.microsoft.com/kb/942976) and introduced therefore on 64-bit Operating system a further ODBC Administrator applications aside the usual ODBC Administrator tool from 32-bit Operating Systems.

    Using the ODBC Administrator from the usual location – Administrative Tools >> Data Sources (OBDC) and creating there the necessary ODBC connection for GoldMine leads in the Crystal Report integration feature in the GoldMine Report Center to the issue that the ODBC data source cannot be selected from the drop down list.

    The following document describes this situation, the reason for this behavior and the correct steps to integrate Crystal Reports appropriately within GoldMine. This document will apply to all appropriate versions of GoldMine Premium Editions and Windows 64-bit Operating Systems. Please refer to the most recent Compatibility Matrix for your specific GoldMine version as compatibility and support did change since GMPE 8.5.x

    [Pre-requisites]

    - GoldMine PE 9.0.0.102 - as Server installation , Undocked user installation or Network Client with Connecting to existing GoldMine system (full client)
    -
    Crystal Report installation - Crystal reports 11 runtime or full Crystal reports 11 installation
    -
    Verify in GoldMine Report Center that Crystal Reports is available

     

     

     

    - System DSN ODBC data source(s) have been setup via Administrative Tools >> Data Sources (OBDC) (ODBC Data Source Administrator - odbcad32.exe). It does not matter for this document which driver - SQL Server or SQL Server Native Client 10 - has been used for setting up the ODBC data source(s) but some Customers reported that with the SQL Server driver not all records were pulled within a report, so their recommendation is to use SQL Server Native Client 10.

     

    [Steps to Reproduce for all Operating Systems]

    1.    Go To >> Reports >> Reports
    2.   
     On the Crystal Reports entry >> Right Click >> Set ODBC Data Sources
    3.   
    On the 'GoldMine database data source name' and 'Contact database data source name' select from the drop down list the appropriate ODBC connection for the GoldMine database

     

     

    Result - On Windows 32-bit Operating Systems:

    The previously created ODBC data source(s) is/are available and can be selected from the Report Center's Crystal Report Data Source Names dialog



     

    The Crystal Reports integration setup works as expected

    Result - On 64-bit Operating Systems (tested for GMPE 9.0.0.102 on Win 7 64-bit Workstation Client and Windows 2008 Server Application server):

    The previously created ODBC data source(s) is/are NOT available and can NOT be selected from the Report Center's Crystal Report Data Source Names dialog. The drop-down list is empty.



    The Crystal Reports integration setup is not successful


     


    Resolution

    Please keep in mind that Crystal Reports integration is not officially supported anymore and will not be further maintained within GoldMine since GMPE 2014.x. The following steps should still apply but are not officially supported, for further information about the GoldMine Premium Edition compatibility matrix, please refer to Knowledge Article # 12210.


    [Cause / Reason]


    GoldMine is a 32-bit application which means regardless if the OS is a 32- or 64-bit system, GoldMine relies on 32-bit ODBC drivers. On 64-bit OS the usual way to create ODBC via Administrative Tools >> ODBC Data Source Administrator (odbcad32.exe) refers to 64-bit ODBC Administrator. This means the setup ODBC connections are visible for 64-bit applications, but not visible for 32-bit applications.

     

    See also  http://support.microsoft.com/kb/942976

     

    What happens for GoldMine in this case is that due to the fact that the 32-bit version of the ODBC Administrator tool displays 32-bit system DSNs, 32-bit user DSNs, and 64-bit user DSNs. The 64-bit version of the ODBC Administrator tool displays 64-bit system DSNs, 32-bit user DSNs, and 64-bit user DSNs

     

     

    This means that GoldMine (as it is a 32-bit application and uses the 32-bit ODBC Administrator) the setup 64-bit ODBC connection cannot be seen and selected.


    [Resolution]

    Setup the necessary ODBC connection via the 32-bit ODBC Administrator via the correct ODBC Data Source Administrator (odbcad32.exe)

     

    The 32-bit version of the Odbcad32.exe file is located in the %systemdrive%\Windows\SysWoW64 folder.

    The 64-bit version of the Odbcad32.exe file is located in the %systemdrive%\Windows\System32 folder.

     

    Note: Windows 8 and Windows 2012 Server usually display already in the Administrative Tools ODBC Data Sources (32-Bit) or ODBC Data Sources (64-bit)
      

    Steps to create 32-bit ODBC data source(s) for GoldMine:

     

    1. Make      sure all ODBC Administrator applications (Odbcad32.exe)      are closed
    2. Browse      to %systemdrive%\Windows\SysWoW64 and start odbcad32.exe from there



     

    3. The      ODBC Administrator's System DSN tab shall not contain the previously      created ODBC data sources as this indicates that still the 64-bit ODBC      Administrator's is in use.



    4. Via      Add button >> Setup your ODBC connection(s) as desired (preferably      with a different name than those from 64-bit ODBC Administrator)
    5. Within      GoldMine again

    6. Go      To >> Reports >> Reports

    7. On      the Crystal Reports entry >> Right Click >> Set ODBC Data      Sources

    8. On      the 'GoldMine database data source name' and 'Contact database data source      name' select from the drop down list the appropriate ODBC connection for      the GoldMine database



     

    The Crystal Reports integration setup works now also on 64-bit OS as expected