30 Brocade Network Advisor Installation and Migration Guide
53-1003373-01
Installing the ODBC driver
2
Installing the ODBC driver
You must have the Open Database Connectivity (ODBC) driver to allow remote clients to export data
and generate reports. The ODBC driver enables you to configure the data source name (DSN) for
the Network Advisor database.

Installing the ODBC driver on Windows systems

You must have the Open Database Connectivity (ODBC) driver to allow remote clients to export data
and generate reports. The ODBC driver enables you to configure the data source name (DSN) for
the Network Advisor database.
To install the ODBC driver, complete the following steps.
1. Double-click edb_psqlodbc.exe located on the DVD (DVD_Drive/Network
Advisor/odbc/Windows).
2. Install the file to the usual location for your system’s application files (for example, C:\Program
Files\Network Advisor ODBC Driver) on the Select Install Folder screen and click Next.
NOTE
If you select an invalid location, the ODBC driver is installed in a different location than where
the ODBC executable drivers are located.
3. On the Ready to Install screen, click Next.
4. Click Finish to complete the installation.

Adding the data source on Windows systems

1. To add the data source, complete the following steps. Choose one of the following options:
•(32-bit OS) Select Start > Settings > Control Panel > Administrative Tools > Data Sources
(ODBC).
•(64-bit OS) (Windows only) Select Start > Run, type %windir%\SysWOW64\odbcad32.exe,
and press Enter.
The ODBC Data Source Administrator dialog box displays.
2. Click the System DSN tab.
3. Click Add.
The Create a New Data Source dialog box displays.
4. Select PostgreSQL Unicode.
5. Click Finish.
The PostgreSQL Unicode ODBC Driver (psqlODBC) Setup dialog box displays.
6. Enter a name for the data source in the Datasource field.
7. Enter the description of the Network Advisor database in the Description field.
8. Enter the name of the Network Advisor database in the Database field.
9. Select enable or disable from the SSL Mode list to specify whether or not to use SSL when
connecting to the database.