Integrated Support for Pervasive.SQL

A set of tools have been provided to simplify integration with Pervasive.SQL relational database system. These tools make the creation, deletion and modification of pervasive database names directly from within the Connector possible. Using these tools, it's no longer necessary to create Pervasive ODBC System DSN entries in the control panel.

To browse, add, modify, delete and troubleshoot pervasive database names from within Sage Intelligence Reporting, use the Database Name Manager for Pervasive.SQL module from within the Connector or the Report Manager.

 

To launch, select the Pervasive Software ODBC-32 connection, right-click and select PVS.SQL DB Manager.

You will need to specify the server running the Pervasive.SQL engine (this is your local machine name if you are not running Pervasive.SQL Server version on a remote server). If the engine is on a remote server then you will need to supply a username and password for the server (the username needs administrative operating system privileges on the server machine).

 

A Sage Intelligence Reporting explorer style module will open which allows you to browse, add, edit, delete and troubleshoot database names under the control of the Pervasive.SQL engine. The module is shown below.