# RazorSQL

## Query, Edit, Browse, and Manage Databases

- razorsql.com
- Contact

# Pervasive Connection Help

RazorSQL can connect to Pervasive via either JDBC or ODBC. RazorSQL does not ship with drivers for Pervasive. To connect, either the ODBC or JDBC drivers need to be obtained. See more information for each connection method below.

## Connecting to Pervasive via JDBC

RazorSQL does not ship with the Pervasive JDBC drivers. To get connected to Pervasive, the JDBC drivers must first be obtained. The JDBC driver is included with the Pervasive installation in files name pvjdbc2.jar, jpscs.jar, and pvjdbc2x.jar. The pvdjbc2.jar file may be the only file needed depending on your Pervasive configuration.

Pervasive JDBC drivers can also be downloaded from the following:

http://www.pervasivedb.com/support/Pages/PSQLSDK-Archives.aspx

Once the JDBC driver is obtained, users can connect to Pervasive by launching the Connections -> Add Connection Profile menu option and selecting Pervasive as the database type and JDBC (Pervasive JDBC Driver) as the connection type. Click the browse button to the location of the pvjdbc2.jar file. Repeat this process for the jpscs.jar and pvjdbc2x.jar file if necessary. The three file paths should be separated by semi-colons. Next, enter any login information and the host or ip address of the server, the port the server is listening on, and the database name.

## Connecting to Pervasive via ODBC

To get connected with ODBC, the Pervasive ODBC driver must be installed on your machine, and an ODBC datasource for Pervasive must be configured on the user's machine prior to connecting. For more information on setting up ODBC datasources, see the following:

ODBC Setup

Once the ODBC driver is installed and an ODBC datasource is configured, open the Connections -> Add Connection Profile menu option, select Pervasive as the database type, ODBC as the connection type, and select the name of the ODBC datasource you configured to make an ODBC connection to Pervasive.

## Manual Pervasive JDBC Information

If manually configuring your connection, see the following for JDBC driver class and JDBC URL format. Manual JDBC Information