Issue:

You would like to connect PIDMO or PLANTMO to a SQL server database and need to add the ODBC drivers to the designers machine.

Solution:

1.  Start the Data Sources (ODBC) from the Control Panel to setup

      the SQL Server ODBC Driver.


    To ensure you are in the 32bit version you can navigate here: %windir%\syswow64\odbcad32.exe


    To ensure you are in the 64bit version you can navigate here: %windir%\system32\odbcad32.exe

 

  2.  Hit the Add button, and select "SQL Server".

 

  3.  In the ODBC SQL Server Setup dialog, type in the following:

 

      For PIDMO the

      Data Source Name: PIDMO_SQL_SERVER

      Server: (select the SQL Server you are using)

      The Data Source Name has to be PIDMO_SQL_SERVER

      

      For PLANTMO the

      Data Source Name: PLANTMO_SQL_SERVER

      Server: (select the SQL Server you are using)

      The Data Source Name has to be PLANTMO_SQL_SERVER

Notes:

You must ensure you are using the 32bit ODBC drivers for versions before 10.0

You must ensure you are using the 64bit ODBC drivers for versions after 10.0

Attached are reg files that can be modified to automate this process. You must change the Server and Last User