ODBC Data Connection

 

The Pervasive SQL Engine has two components - the Transactional Engine and Relational Engine.  Evo-ERP and DBA use the Transactional engine which requires no additional setup but if you want to access the data using Crystal Reports or Access, connect to UPS or Federal Express or other shipping software, or use the Java applications for BOM Availability (BM-N), Scheduling (SH-R), Sales Analysis (SA-F-A, B, C, D), Daa Export (DE-A) or Business Status (GL-R), you need to define the database parameters so that it can be connected to using ODBC or JDBC.

 

First (and this needs to be repeated each time an update to Evo-ERP/DBA is installed and is called automatically by the update utility) you need to create the Data Dictionary, or DDF files.  This is done for each company at UT-A, program ODBCDDF and is part of the standard utility run each time an updte is installed.

 

Next, the database needs to be defined on the server so the Pervasive Engine knows where the files are.  This is done at the server console.  Load the Pervasive Control Center (Start - Programs - Pervasive - Control Center & Documentation).  Select New Database, confirm the server, then on the next screen, give the database a name and point to the company folder location.  Accept the other defaults and click Finish.

 

Finally, to use the Evo-ERP Java applications, use SM-T Enter Java Settings