1 PostgreSQL database

Installing the ODBC driver on Linux systems

To install the ODBC driver and , complete the following steps.

1. Execute the following command in the terminal:

> su

>chmod 777 edb_psqlodbc.bin

> ./edb_psqlodbc.bin

2.On the Setup psqlODBC screen click Next.

3.Install the file to the usual location for your system’s application files (for example, /opt/PostgreSQL/psqlODBC) on the Installation Directory 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.

4.On the Ready to Install screen click Next.

5.On the Completing the psqlODBC Setup Wizard screen click Finish to complete the installation.

Adding the Datasourse on Linux systems

Before you edit the INI files, make sure the PostgreSQL database is up and running.

NOTE

For RedHat and Oracle Enterprise systems, the odbc.ini and odbcinst.ini files are located in /etc. For SUSE systems, the odbc.ini and odbcinst.ini files are located in /etc/unixODBC.

1. Open the odbc.ini file in an editor and enter the datasource information as follows:

[TestDB]

Description = PostgreSQL 8.4

Driver = /opt/PostgreSQL/psqlODBC/lib/psqlodbcw.so Database = dcmdb

Servername = 172.26.1.54 UserName = dcmadmin Password = passw0rd Port = 5432

2.Save and close the odbc.ini file.

3.Open the odbcinst.ini file in a text editor and make sure that the driver path information is correct.

After you install the PostgreSQL ODBC driver, the odbcinst.ini should automatically update the driver path. If the direver path is not updated, add the following:

[psqlODBC]

Description=PostgreSQL ODBC driver Driver=/opt/PostgreSQL/psqlODBC/lib/psqlodbcw.so

4. Save and close the odbcinst.ini file.

20

Brocade Network Advisor IP User Manual

 

53-1003056-01

Page 72
Image 72
Brocade Communications Systems IP250 Installing the Odbc driver on Linux systems, Adding the Datasourse on Linux systems