Hi, I was checked and checked my Odbc.ini File. I tried connection unixODBC(isql) to oracle with “root” user in linux OS. I got TNS permission problem. So, I tried connection unixODBC(isql) to oracle with “oracle” user in linux OS. Then connected. And I tried connection postgresql to oracle with “postgres” user in linux OS. It was error about this. - error - ERROR: odbclink: unsuccessful SQLConnect call: [S1000] [12514] [[unixODBC][Oracle][ODBC][Ora]ORA-12514: TNS:listener does not currently know of service requested in connect descripto Look my odbc.ini file Odbc.ini ---------------------------------------- [SNIOV2] Decription=Oracle ODBC Driver=OracleDriver Trace=yes TraceFile=/tmp/odbc_oracle.log ServerPost=192.168.10.25:1521 Database=SNIOV2 << added UserID=vsmon Password=dusrnth SID=SNIOV2 << added ---------------------------------------- My Issue is that [Success] UnixODBC – Oracle [Unsuccess] Postgresql-unixODBC-Oracle I was checking spell completed………. This case is what??? My odbc.ini parameter is not enough? What I Configuring????? Please helping.
|
