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
- In the Welcome screen click the Next button.
- In the EULA window, read the agreement and, if you agree to the terms and conditions, click the Yes button.
- In the Verify Setup Information screen, click the Install button.
- In the Finish screen, click the Finish button.
- 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.
- In the Transactional Engine Test Results window, click the Next button.
- In the Test Relational Engine window, click the Next button.
- In the Relational Engine Test Results window, click the Next button.
- In the Completing the Pervasive System Analyzer Wizard window, click the Finish button.
Connection Setup
- Open ‘HydraStudio’, and from the Tools menu, select Database Connections.
The Querix Connect window is displayed - Click the ODBC tab and then click the ODBC Administrator button. The ODBC Data Source Administrator window is displayed.
- Select the System DSN tab, and click the Add button. The Create New Data Source window is displayed.
- From the list displayed, select Pervasive ODBC Client Interface, and click the Finish button. The Pervasive ODBC Client DSN Setup window is displayed.
- In the Client region, Data Source Name field, type a name to identify this connection setup.
- In the Server region, Address field, type the host name or IP address.
- In the Transport Hint field, select the appropriate protocol options.
- 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.
- 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
- Change user to root.
- 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. - 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.
- 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.
Related articles