|
ODBC Product Installation and Activation (UNIX/Linux) |
The installation archives for the PxPlus SQL ODBC Driver or PxPlus SQL Server can be obtained from your PxPlus reseller or from the PxPlus website www.pvxplus.com. The installation process is very similar for all PxPlus UNIX/Linux ODBC products.
Obtain the PxPlus ODBC distribution file from your PxPlus reseller or via the PxPlus website www.pvxplus.com. Ensure that you download the correct version for your specific UNIX/Linux operating system.
The PxPlus SQL ODBC Driver distribution file is named with a .taz extension, which is short for .tar.Z, a compressed version of a UNIX .tar file:
sql_odbc_driver_v.vv.vvvv_ddd_www_aaa.taz
Where:
|
|
v.vv.vvvv |
Identifies the version of the PxPlus SQL ODBC Driver (e.g. 5.00.0000) |
|
|
ddd |
Identifies a specific operating system (e.g. ol.61 for Oracle Linux/CentOS versions 6.1 and up) |
|
|
www |
Identifies the word size (e.g. 32-bit) |
|
|
aaa |
Identifies the architecture (e.g. x86) |
The sql_odbc_driver_v.vv.vvvv_ddd_www_aaa.taz distribution file contains the following installation components:
|
|
pxpsql |
PxPlus SQL Command Line Client executable |
|
|
libpxpio.so |
PxPlus SQL ODBC Library used by libpxpsqlodbc.so |
|
|
libpxpsqlodbc.so |
PxPlus SQL ODBC Driver |
|
|
license.sample |
PxPlus SQL ODBC Driver sample license configuration file |
|
|
install.txt |
Installation readme file |
|
|
license.txt |
License agreement |
|
|
licenses_3rdparty.txt |
Third-party license agreements (version 8.00.0000/PxPlus 2023) |
|
|
readme.txt |
Readme file for this version containing change information |
Obtain the PxPlus SQL Server distribution file from your PxPlus reseller or via the PxPlus website www.pvxplus.com. Ensure that you download the correct version for your specific UNIX/Linux operating system.
The PxPlus SQL Server distribution file is named with a .taz extension, which is short for .tar.Z, a compressed version of a UNIX .tar file:
sql_server_ v.vv.vvvv_ddd_www_aaa.taz
Where:
|
|
v.vv.vvvv |
Identifies the version of the PxPlus SQL Server (e.g. 5.00.0000) |
|
|
ddd |
Identifies a specific operating system (e.g. ol.61 for Oracle Linux/CentOS versions 6.1 and up) |
|
|
www |
Identifies the word size (e.g. 32-bit) |
|
|
aaa |
Identifies the architecture (e.g. x86) |
The sql_server_ v.vv.vvvv_ddd_www_aaa.taz distribution file contains the following installation components:
|
|
pxpsqlsvr |
PxPlus SQL Server executable |
|
|
libpxpio.so |
PxPlus SQL ODBC Library used by pxpsqlsvr |
|
|
pxpsqlsvr.conf.sample |
Sample PxPlus SQL Server configuration file |
|
|
install.txt |
Installation Readme file |
|
|
license.txt |
License agreement |
|
|
licenses_3rdparty.txt |
Third-party license agreements (version 8.00.0000/PxPlus 2023) |
|
|
readme.txt |
Readme file for this version containing change information |
After you download the installation archive, move it to the /tmp directory. Follow these steps to expand, install and activate the PxPlus ODBC program on your computer:
|
Step |
Description |
|
1. |
Change to the /tmp directory and rename the product_name_ v.vv.vvvv_ddd_www_aaa.taz with a .tar.Z extension so that it can be uncompressed: umask 0 |
|
2. |
Create the new directory to receive the PxPlus software and then change into it: mkdir /usr/install_dir |
|
3. |
Use the tar command to copy the software into the directory: tar -xvf /tmp/product_name_ v.vv.vvvv_ddd_www_aaa.tar |
|
4. |
If required, set the file permissions on the executable and configuration files to whatever is necessary depending on the username who will be running the product: chmod 500 pxp* |
|
5. |
If this is the first time the product has been installed on the system, then for a PxPlus SQL Server install, copy the sample configuration file to create the configuration file. For a PxPlus SQL ODBC Driver install, copy the sample license to create the license file: cp pxpsqlsvr.conf.sample pxpsqlsvr.conf (PxPlus SQL Server) |
|
6. |
Copy libraries to either the /usr/lib or /usr/lib64 directory: cp libpxpio.so /usr/lib/libpxpio.so |
To activate the PxPlus UNIX/Linux ODBC products, use a text editor (e.g. vi) to modify (or create a new copy of) the license file (for the PxPlus SQL ODBC Driver) and the pxpsqlsvr.conf file (for the PxPlus SQL Server).
The sample files contain documentation at the top of the files on the entries that are required and the syntax of those entries. These files are used to configure the Activation Information.
Enter your activation information as follows:
serial=xxxxx-y- zzzzzzzzzzzzzzzz
Where:
|
|
xxxxx |
Serial Number |
|
|
y |
User Count |
|
|
zzzzzzzzzzzzzzzz |
Activation Key |
If purchasing a Professional or Web edition of PxPlus that includes SQL ODBC Driver support, you must use the Serial Number, User Count, and ODBC Activation Key of your PxPlus Professional or Web license.
To run the PxPlus ODBC products in demonstration mode, set the serial= entry to a blank value. The PxPlus SQL ODBC Driver in demo mode will notify the user that he/she is connected to a demo-activated product each time it is used and is limited to returning a maximum of 10 records. The PxPlus SQL Server in demo mode will allow one user to access the server with demo messages appearing periodically on the client's screen.
At this point, the installation is complete; however, the configuration file may require updated settings.
For configuration details, see
PxPlus SQL ODBC Driver Configuration (Windows)
PxPlus SQL ODBC Driver Configuration (UNIX/Linux)
PxPlus SQL Server Configuration (Windows)
PxPlus SQL Server Configuration (UNIX/Linux)
Once configured, you are ready to start using the ODBC product.
Using the PxPlus SQL ODBC Driver
PxPlus SQL Command Line Client (installed with the PxPlus SQL ODBC Driver)
PxPlus SQL Server