Pervasive for Hydra


Although remote users only need to install database drivers, Pervasive does not give this option, so a full install is needed. The instructions below assume that the installation is being done from CD-ROM.

Pervasive Windows Connections

  1. In the Welcome screen click the Next button.
  2. In the EULA window, read the agreement and, if you agree to the terms and conditions, click the Yes button.
  3. In the Verify Setup Information screen, click the Install button.
  4. In the Finish screen, click the Finish button.
  5. In the Pervasive System Analyzer window, you are presented with options to test the Transactional Engine. Select the appropriate radio buttons, or accept the defaults, and click the Next button.
  6. In the Transactional Engine Test Results window, click the Next button.
  7. In the Test Relational Engine window, click the Next button.
  8. In the Relational Engine Test Results window, click the Next button.
  9. In the Completing the Pervasive System Analyzer Wizard window, click the Finish button.

Connection Setup

  1. Open ‘HydraStudio’, and from the Tools menu, select Database Connections.
    The Querix Connect window is displayed
  2. Click the ODBC tab and then click the ODBC Administrator button. The ODBC Data Source Administrator window is displayed.
  3. Select the System DSN tab, and click the Add button. The Create New Data Source window is displayed.
  4. From the list displayed, select Pervasive ODBC Client Interface, and click the Finish button. The Pervasive ODBC Client DSN Setup window is displayed.
  5. In the Client region, Data Source Name field, type a name to identify this connection setup.
  6. In the Server region, Address field, type the host name or IP address.
  7. In the Transport Hint field, select the appropriate protocol options.
  8. In the Data Source Name field, click the Get DSN List button and select the appropriate DSN engine; OR click the Create button and, in the Logon dialog displayed, type the Username and Password in the appropriate fields.
  9. Click the OK button. The DSN engine DEMODATA is a demonstration database that is automatically set up during the installation of Pervasive.

Pervasive Unix/Linux Connections

  1. Change user to root.
  2. Mount the installation CD-ROM, and from its directory, type the command: rpm –ivh filename.rpm
    Where filename.rpm is the name of the file that contains the installation files.
    Pervasive will install automatically.
    For Pervasive to work correctly a new data source needs to be created.
  3. To create a new data source use the command: dsnadd –dsn=dsn_name –host=host_name –sdsn=DEMODATA Where dsn_name is the name of the client; host_name is the name or IP address of the host server. DEMODATA is the name of a demonstration database set up when Pervasive is installed.
  4. Set the environment variable SQLSERVER to the DSN name. This can be done with a command, which will only last for the current session, or by mapping the environment variable SQLSERVER to the DSN name.
    The command for the current session is: export SQLSERVER=DSN_name To find out where to map the SQLSERVER environment variable to the DSN name, ask your system administrator.