HP Brocade 8/24c Brocade Network Advisor Installation Guide v11.1x (53-1002320 - Page 40

Installing the ODBC driver, Installing the ODBC driver on Windows systems

Page 40 highlights

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. 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. 16. Enter the database user name in the User Name field. 17. Enter the password in the Password field. 40 of 47 Brocade Network Advisor Installation Guide 53-1002320-01

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47

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.
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.
16.
Enter the database user name in the
User Name
field.
17.
Enter the password in the
Password
field.