Brocade Network Advisor SAN Installation and Migration Guide v12.0.0 (53-1002801-01, March 2013)

Network Advisor SAN Installation and Migration Guide 23

53-1002801-01

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) (Windows only) 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. Click 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.