Skip to main content

PCM - How to Configure an ODBC

Deborah Grieves
Updated

Configuring ODBC Connection for PCM

If you are on a 64-bit machine, you will have two folders in your C:\Windows directory that will contain an ODBC tool.  To establish a connection between a database and PCM, you will need to configure the ODBC in the SysWOW64 folder, not System32.  If you are on a 32-bit machine, get the ODBC in the System32 folder. These instructions assume your computer is 64-bit.

  • In your SysWOW64 folder, find the odbcad32.exe and open it. Alternatively, search "ODBC" in your Windows Search bar and make sure the ODBC selected is 32-bit.

 		  
  • Click on the System DSN tab, then Add.

  
  • In the Create New Data Source screen, select SQL Server driver and hit Finish.

 		  
  • In the following screen, enter a Name and enter the SQL Server you want to connect to. The Description is optional.

  • IMPORTANT NOTE: To connect to PCM, the Name must start with "PCM" and then a space.  The rest of the name after the space can be whatever you’d like. The prefix "PCM" will not be seen in the ODBC selection for the end user.
  
  • Click on Next.  All defaults on this screen can be kept if you are using Windows authentication. If you are using SQL Server authentication you will need to fill out your SQL Server login and password.

 

  
  • Click on Next again.  On this screen, first check the box next to “Change the default database to:”, then in the drop down menu, select the database you are connecting to. 

  • Also on this screen, it is important to uncheck the two ANSI boxes.  These are checked by default, so make sure to uncheck them.
  
  • Click Next. On this screen the only thing to do is uncheck the “Perform translation for character data” box.

 

  
  • Hit Finish. This will take you to a screen that summarizes your settings and where you can test the data source.

 		  

Click on OK to finish the connection process.  To add other connections to the ODBC, simply repeat the above steps.

For the PCM Code Loader, the ODBC creation is the same as above; however, you must use the 64-bit ODBC found in the System32 folder.  Below is an example of one database with a 32-bit ODBC to connect to PCM and a 64-bit ODBC to connect to the Code Loader (CL). 

Note you can add a "d" to the end of the "PCM" prefix to make it the default ODBC that is automatically selected when opening PCM.  Otherwise, if you have multiple ODBCs created, they will appear alphabetically in the PCM splash screen dropdown.

 

Comments

0 comments

Article is closed for comments.

Powered by Zendesk