cat /home/oracle/temp/psqlodbc-09.02.0100/test/odbc.ini
[postgresql]
Description = psqlodbc regression test DSN
Driver = /home/oracle/temp/psqlodbc-09.02.0100/.libs/psqlodbcw.so
Trace = Yes
TraceFile = /home/oracle/tmp/sql.log
Database = postgresdb
Servername = postgresdev.office.corp
Username = postgres
Password = ***********
Port = 5432
Protocol = 6.4
ReadOnly = No
RowVersioning = No
ShowSystemTable = No
ShowOidColumn = No
FakeOidIndex = No
ConnSettings =
cat /home/oracle/temp/psqlodbc-09.02.0100/test/odbcinst.ini
[psqlodbc]
Description = PostgreSQL ODBC driver (Unicode version), for regression tests
Driver = ../.libs/psqlodbcw.so
Debug = 0
CommLog = 1
cat /oracle/database/11.2.0.3/hs/admin/initdg4odbc.ora
# This is a sample agent init file that contains the HS parameters that are
# needed for the Database Gateway for ODBC
#
# HS init parameters
#
HS_FDS_CONNECT_INFO =postgresql
HS_FDS_TRACE_LEVEL =off
HS_FDS_SHAREABLE_NAME = /usr/lib/libodbc.so
#
# ODBC specific environment variables
#
set ODBCINI=/home/oracle/temp/psqlodbc-09.02.0100/test/odbc.ini
set odbcinst=/home/oracle/temp/psqlodbc-09.02.0100/test/odbcinst.ini
cat /oracle/database/11.2.0.3/network/admin/listener.ora
LISTENER_POSTGRES =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = scfsdb.office.corp)(PORT = 1524))
)
)
SID_LIST_LISTENER_POSTGRES =
(SID_LIST =
(SID_DESC =
(SID_NAME = postgresql)
(ORACLE_HOME = /oracle/database/11.2.0.3)
(PROGRAM = hsodbc)
(ENVS = "LD_LIBRARY_PATH=/oracle/database/11.2.0.3/lib:/oracle/database/11.2.0.3/hs/lib:/usr/lib")
)
(SID_DESC =
(SID_NAME = postgresql)
(ORACLE_HOME = /oracle/database/11.2.0.3)
(PROGRAM = hsodbc)
)
)
#ADR_BASE_LISTENER_POSTGRES = /oracle/database
LOGGING_LISTENER_POSTGRES = OFF
cat /oracle/database/11.2.0.3/network/admin/tnsnames.ora
postgresql =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xx.x.xx)(PORT = 1524))
(CONNECT_DATA =
(SID = postgresql)
)(HS = OK)
)
This is not working, could you please let me know, where I should make the change. Thank you so much for all your help in Advance..!!! Guru's, please respond on this.