Brocade Network Advisor Installation Guide v11.1x (53-1002320-01, May 2011)

40 of 47 Brocade Network Advisor Installation Guide
53-1002320-01
Installing the ODBC driver
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.
5. Choose one of the following opitions:
• (32-bit OS) Select Start > Settings > Control Panel > Administrative Tools > Data Sources (ODBC).
• (62-bit OS) Select Start > Run, type %windir%\SysWOW64\odbcad32.exe and press Enter.
The ODBC Data Source Administrator dialog box displays.
6. Click the System DSN tab.
7. Cl ick Add.
The Create a New Data Source dialog box displays.
8. Select PostgreSQL Unicode.
9. Click Finish.
The PostgreSQL Unicode ODBC Driver (psqlODBC) Setup dialog box displays.
10. Enter a name for the data source in the Datasource field.
11. Enter the description of the Network advisor database in the Description field.
12. Enter the name of the Network Advisor database in the Database field.
13. Select enable or disable from the SSL Mode list to specify whether or not to use SSL when connecting to the
database.
14. Enter the IP address or host name of the Network Advisor server in the Server field.
15. Enter the database server port number in the Port Number field.
16. Enter the database user name in the User Name field.
17. Enter the password in the Password field.