Skip to main content

Posts

Showing posts with the label HS db connection to PostgreSQL

Heterogeneous DB Connection Between Oracle And Postgres Plus

Hi , Finally,i have configured the heterogeneous (HS) Database Connectivity between Oracle 11.2 and PPAS 9.1. I believe, the same steps will be suitable for the PostgreSQL as well. Please find the steps one by one . Step 1:- -------- We need to Configure the odbcinst.ini file which is having all the Drivers Information. [enterprisedb] Description=PostgresPlus Advanced Server ODBC driver Driver=/opt/PostgresPlus/9.1AS/connectors/odbc/lib/edb-odbc.so Setup=/opt/PostgresPlus/9.1AS/connectors/odbc/lib/libodbcedbS.so UsageCount=1 Step 2:- -------- We need to Configure the odbc.ini file which is having all the DNS entries. [edb] Driver=enterprisedb Description=Connection to LDAP/POSTGRESQL Servername=localhost    Port=5444 Protocol=7.4 FetchBufferSize=99 Username=enterprisedb Password=adminedb Database=edb ReadOnly=no Debug=1 Trace = yes CommLog=1 UseDeclareFetch=0 TraceFile=/tmp/sql.log UseServerSidePrepare=1 dbms_name=PostgreSQL Step 3:- --------- Check the DNS Conn...