Issue:

You would like to connect CADWorx 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

 

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

 

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

 

      For CADWorx Plant the

      Data Source Name: Plant_SQL_SERVER

      Server: (select the SQL Server you are using)

      The Data Source Name has to be Plant_SQL_SERVER.

      

      For CADWorx Steel the

      Data Source Name: Steel_SQL_SERVER

      Server: (select the SQL Server you are using)

      The Data Source Name has to be Steel_SQL_SERVER.      

 

      For CADWorx P&ID the

      Data Source Name: P&ID_SQL_SERVER

      Server: (select the SQL Server you are using)

      The Data Source Name has to be P&ID_SQL_SERVER.

     

      For CADWorx IP the

      Data Source Name: IP_SQL_SERVER

      Server: (select the SQL Server you are using)

      The Data Source Name has to be IP_SQL_SERVER.     

 

Notes:

You must ensure you are using the 32bit ODBC drivers.

Attached is a reg file that can be modified to automate this process. You must change the Server and Last User

Versions: 

CADWorx Plant Professional 2005, CADWorx Plant Professional 2006, CADWorx Plant Professional 2007, CADWorx Plant Professional 2008, CADWorx Plant Professional 2009, CADWorx Plant Professional 2010, CADWorx Plant Professional 2012, CADWorx Plant Professional 2013, CADWorx Plant Professional 2014, CADWorx Plant Professional 2015, CADWorx Plant Professional 2016, CADWorx Plant Professional 2017

CADWorx PID 2005, CADWorx PID 2006, CADWorx PID 2007, CADWorx PID 2008, CADWorx PID 2009, CADWorx PID 2010, CADWorx PID 2012, CADWorx PID 2013, CADWorx PID 2014, CADWorx PID 2015, CADWorx PID 2016, CADWorx PID 2017