Skip to content
logo Knowledgebase

How to set up ODBC Pervasive DSN for Purchasing and Inventory data

Created on  | Last modified on 

Summary

How do I set up an ODBC Pervasive DSN for Purchasing and Inventory data for Sage 300 CRE?

Resolution

CAUTION: This solution requires an advanced understanding of Windows or third-party add-ons. Mistakes in the Windows registry, security, and network settings can cause serious problems. Sage isn't responsible for the Windows environment, third-party add-ons, or customization issues. Create a system and database backup before making changes. Get help from your system admin, consultant, or vendor. 

  1. Set up the Pervasive ODBC Engine Interface DSN on the file server.
    1. Log on to the file server as the local administrator.
    2. Find and note down the IP address of the server.
    3. Go to Start, Programs, Administrative Tools, Data Sources (ODBC).
    4. Select the System DSN tab and then click Add.
    5. Select Pervasive ODBC Engine Interface and click Finish.
    6. Type a Data Source Name name.  NOTE: The Data Source Name must not contain any special characters. The first character can't be a number.
    7. Click Create.
    8. Enter the Data Source Name created above in the Database Name box.
    9. Click Browse to find and select your POIVData folder.  NOTE: This can't be mapped network drive but a local drive path to the POIVData or ACData folder. 
    10. Click OK twice and then click Test.
    11. A message Connection successful appears. Click OK three times.
  2. If you have terminal servers connecting to other servers containing Sage Timberline Office data, set up the Pervasive ODBC Client Interface DSN on the terminal server.
    1. Click Start, Programs, Administrative Tools, Data Sources (ODBC).
    2. Click the System DSN tab and then click Add.
    3. Select Pervasive ODBC Client Interface and then click Finish.
    4. Type a Data Source Name name.  NOTE: The Data Source Name must not contain any special characters. The first character can't be a number.
    5. In the Server Address box, enter the file server's IP Address from Step 1.
    6. Click Get DSN List and select the DSN created in Step 1.
    7. Click Test.
    8. A message Connection successful appears. Click OK three times.
  3. Open the Actian PSQL or Zen Control Center, depending on the version (Start, All Programs, and Actian PSQL 12 or Actian Zen 15).
  4. Expand Engines in the folders on the left to see your server name.
  5. Right-click Database, New, and Database.
  6. Enter the name of your custom ODBC/DSN in the Database Name field.
  7. Browse the network by clicking the (…) button near the Location field to select the POIVData folder or enter the path directly. For example, \\ServerName\TIMBERLINE OFFICE\Data\Construction Sample Data\POIVData\.
     NOTE: You'll see the DSN Options section above the Finish button. It has a box checked for Create 32-bit Engine DSN, which creates an ODBC connection in the ODBC 32-bit Administrator. 
  8. Click Finish.