From: Mark Johnson <mark@remingtondatabasesolutions.com>
To: ÃÖÀç¿ø <jwchoi@modernlimes.com>
To: pgsql-admin@postgresql.org
Subject: Re: How I do Configuration for Postgresql-oracle db link?
Date: Tue, 07 Jun 2011 16:36:19 +0000
Message-ID: <W641271499885751307464579@webmail64> (raw)
Did you configure a system DSN or user DSN? If connections fail for postgres and succeed for other users, then look in the postgres user's home for hidden file ~/.odbc.ini. Each user can have one of these hidden files.
-Mark
-----Original Message-----
From: ÃÖÀç¿ø [mailto:jwchoi@modernlimes.com]
Sent: Tuesday, June 7, 2011 05:14 AM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] How I do Configuration for Postgresql-oracle db link?
v\:* {behavior:url(#default#VML);}o\:* {behavior:url(#default#VML);}w\:* {behavior:url(#default#VML);}.shape {behavior:url(#default#VML);}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.
------------------------------------------------------------
»õ·Î¿î ¸ÞÀÏÀÌ µµÂøÇϸé, ¸Þ½ÅÀú·Î ¹Ù·Î ¾Ë·ÁÁÝ´Ï´Ù!
°¡ºñ¾Æ ÇÏÀÌ¿÷½º ¸ÞÀÏ - hiworks.co.kr
Attachments:image001.jpg (image/jpeg, 9.1K) downloadview image
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: mark@remingtondatabasesolutions.com, jwchoi@modernlimes.com
Subject: Re: How I do Configuration for Postgresql-oracle db link?
In-Reply-To: <W641271499885751307464579@webmail64>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox