[IM004][unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_HENV failed [ISQL]ERROR: Could not SQLConnect

]#   isql -v MYPGDB

[IM004][unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_HENV failed

[ISQL]ERROR: Could not SQLConnect

Cause

Either odbc drivers are not mentioned properly or environment variable are not set ODBCSYSINI ODBCINI

Solution

1 ) Set driver in /etc/odbc.ini file

Driver                = /usr/lib64/psqlodbc.so

Description           = PostgreSQL ODBC

2) Export path of odbc.ini file

]# export ODBCSYSINI=/etc

]# export ODBCINI=/etc/odbc.ini

]#   isql -v MYPGDB

+---------------------------------------+

| Connected!                            |

|                                       |

| sql-statement                         |

| help [tablename]                      |

| quit                                  |

|                                       |

+---------------------------------------+

SQL>