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. |