6.4 Connecting to Advanced Server

Table of Contents Previous Next


6 Configuring Advanced Server : 6.4 Connecting to Advanced Server

psql is a command line client application that allows you to query the server, and review the query results. Please note that additional configuration steps are required before connecting to an Oracle or MySQL database.
C:\Users\susan\AppData\Local\Temp\vmware-susan\VMwareDnD\9fbeea7c\one.png
-d specifies the database to which psql will connect;
-U specifies the identity of the database user that will be used for the session.
If you have performed an installation with the interactive installer, you can easily access the psql client through the Applications or Start menu. Navigate through the EDB Postgres/Advanced Server 9.6 menu to the Run SQL Command Line menu, and select EDB-PSQL. When the Terminal window opens, provide connection information for your session.
Before connecting Advanced Server to an Oracle database, you must download and install the Oracle JDBC driver (ojdbcxx.jar) from the Oracle website. You can find a link to the free JDBC driver at:
Download the ojdbcxx.jar file, where xx specifies the version of the driver that is appropriate for your Oracle installation, and place it in the JAVA_HOME\jre\lib\ext directory.
Before connecting Advanced Server to a MySQL database, you must download and install the MySQL JDBC driver (mysql-connector-java-5.0.8-bin.jar) from the MySQL website. You can find a link to the free JDBC driver at:
Download the mysql-connector-java-5.0.8-bin.jar file and place it in the JAVA_HOME\jre\lib\ext directory.

6 Configuring Advanced Server : 6.4 Connecting to Advanced Server

Table of Contents Previous Next