test

Configuring JDBC/ODBC Drivers

OTD Wizard: Database Connection Information

To connect to SQL, use the information provided in Table 1–7 to complete the Connect to Database step of the JDBC/ODBC OTD Wizard. To access SQL, it is recommended to use the SQL Server eWay Adapter.

Table 1–7 PostgreSQL Driver Connection Information

Parameter 

Value 

Driver Jar Files 

postgresql-8.0-310.jdbc3.jar

Driver Java Class Name 

org.postgresql.Driver 

URL Connection String 

jdbc:postgresql://server-name:server-port/database-name

Note –

NOTE: Default server port is 5432.

User Name 

Login name of the account used to access the database. 

Password 

Password associated with the login account name used to connect to the database.