User`s guide

2 Getting Started with Database Toolbox
2-72
3
Click the System DSN tab and then click Add. When setting up an ODBC data
source, you can use a User DSN or System DSN. A User DSN is specific to the user
on a machine. Any data sources a user defines under User DSN are seen only by that
specific user. Conversely, a System DSN is not specific to the user on a machine. Any
data sources a user defines under System DSN on a machine can be seen by any user
who logs into that machine. Your ability to set up a User DSN or System DSN might
depend on the database and ODBC driver you are using. For details, contact your
database administrator or your database ODBC driver documentation.
4
A list of installed ODBC drivers appears in the Create New Data Source dialog box.
Select the ODBC driver PostgreSQL ANSI(x64). Your ODBC driver might have a
different name. Click Finish.
5
In the PostgreSQL ANSI ODBC Driver (psqlODBC) Setup dialog box, enter an
appropriate name for your data source in the Data Source field. You use this
name to establish a connection to your database. Here, enter PostgreSQL30 as the
data source name. Enter a description for this data source, such as PostgreSQL
database, in the Description field. Enter your database name in the Database
field. Enter your database server name in the Server field. Enter your port number
in the Port field. The default port number is 5432. Enter your user name in the
User Name field. Enter your password in the Password field. Leave all settings in
the Options section with default settings.
6
Click Test to test the connection to your database. If your computer successfully
connects to the database, the Connection Test dialog box displays this message:
Connection successful.