Fala pessoal,
alguem tem experiencia em acessar um banco POSTGRES pelo gateway ODBC??
configuração:
Oracle 11.2.0.3
postgres 9.1.4
arquivo odbc.ini
[oracle@ora11g admin]$ cat
/opt/Progress/DataDirect/Connect64_for_ODBC_71/odbc.ini
[ODBC Data Sources]
PostgreSQL Wire Protocol=DataDirect 7.1 PostgreSQL Wire Protocol
[ODBC]
IANAAppCodePage=4
InstallDir=/opt/Progress/DataDirect/Connect64_for_ODBC_71
Trace=0
TraceFile=odbctrace.out
TraceDll=/opt/Progress/DataDirect/Connect64_for_ODBC_71/lib/ddtrc27.so
[PostgreSQLWireProtocol]
Driver=/opt/Progress/DataDirect/Connect64_for_ODBC_71/lib/ddpsql27.so
Description=DataDirect 7.1 PostgreSQL Wire Protocol
AlternateServers=
ApplicationUsingThreads=1
ConnectionReset=0
ConnectionRetryCount=0
ConnectionRetryDelay=3
Database=postgres
DefaultLongDataBuffLen=2048
EnableDescribeParam=1
EncryptionMethod=0
ExtendedColumnMetadata=0
FailoverGranularity=0
FailoverMode=0
FailoverPreconnect=0
FetchTSWTZasTimestamp=0
FetchTWFSasTime=0
HostName=localhost
HostNameInCertificate=
InitializationString=
KeyPassword=
KeyStore=
KeyStorePassword=
LoadBalanceTimeout=0
LoadBalancing=0
LoginTimeout=15
LogonID=postgres
MaxPoolSize=100
MinPoolSize=0
Password=*****
Pooling=0
PortNumber=5432
QueryTimeout=0
ReportCodepageConversionErrors=0
TransactionErrorBehavior=1
TrustStore=
TrustStorePassword=
ValidateServerCertificate=1
XMLDescribeType=-10
[oracle@ora11g admin]$ cat initPOSTGRES.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 = "PostgreSQLWireProtocol"
HS_FDS_TRACE_LEVEL =DEBUG
HS_FDS_SHAREABLE_NAME =
/opt/Progress/DataDirect/Connect64_for_ODBC_71/lib/ddpsql27.so
HS_LANGUAGE=american_america.we8iso8859p1
#HS_FDS_TRACE_FILE_NAME= /tmp/hs.log
#
# ODBC specific environment variables
#
set ODBCINI=/opt/Progress/DataDirect/Connect64_for_ODBC_71/odbc.ini
set ODBCINSTINI=/opt/Progress/DataDirect/Connect64_for_ODBC_71/odbcinst.ini
#
# Environment variables required for the non-Oracle system
#
set LD_LIBRARY_PATH =
/opt/Progress/DataDirect/Connect64_for_ODBC_71/lib:/u01/app/oracle/11.2.0/db_1/lib:/lib:/usr/lib
set
PATH=/u01/app/oracle/11.2.0/db_1/lib:/opt/Progress/DataDirect/Connect64_for_ODBC_71/lib
Listener.ora
LISTENER=
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ora11g)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = TESTEDB)
(ORACLE_HOME = /u01/app/oracle/11.2.0/db_1)
(SID_NAME = TESTEDB)
)
(SID_DESC =
(SID_NAME = POSTGRES)
(ORACLE_HOME = /u01/app/oracle/11.2.0/db_1)
(PROGRAM=dg4odbc)
(ENVS=LD_LIBRARY_PATH =
/opt/Progress/DataDirect/Connect64_for_ODBC_71/lib:
/u01/app/oracle/11.2.0/db_1/lib:
/lib:/usr/lib:/etc)
)
)
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM", status READY, has 1 handler(s) for this service...
Service "POSTGRES" has 1 instance(s).
Instance "POSTGRES", status UNKNOWN, has 1 handler(s) for this service...
Service "TESTEDB" has 2 instance(s).
Instance "TESTEDB", status UNKNOWN, has 1 handler(s) for this service...
Instance "TESTEDB", status READY, has 1 handler(s) for this service...
Service "TESTEDBXDB" has 1 instance(s).
Instance "TESTEDB", status READY, has 1 handler(s) for this service...
The command completed successfully
TNSNAMES.ora
POSTGRES =
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST = localhost)(PORT=1521))
(CONNECT_DATA=(SID=POSTGRES))
(HS=OK)
)
SQL> select nome from "neto"@PGSQL3;
select nome from "neto"@PGSQL3
*
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
ORA-02063: preceding line from PGSQL3
não tem nenhuma informação nesse erro!
habilitei o HS_FDS_TRACE_LEVEL =DEBUG
agora não sei onde esta o arquivo de trace gerado.
