Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

TG4MSQL ora-28500 error on RECOVER login in READ-ONLY mode

pmack1Jul 16 2008 — edited May 7 2013

We're connecting from a 10.2 dbase to SqlServer2000 via TG4MSQL. No upfront problem connecting but the Oracle .trc file shows below error:

ORA-28500: connection from ORACLE to a non-Oracle system returned this message: [Transparent gateway for MSSQL][Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'RECOVER'. (SQL State: 00000; SQL Code: 18456)

Below is the content of .ora file:

HS_FDS_CONNECT_INFO=INETSQL3.ComPro
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_TRANSACTION_MODEL=READ_ONLY

We are using READ-ONLY mode so the RECOVER login was not defined on SqlServer.

Anyone know why TG4MSQL is trying to open a connection as RECOVER? And is there a way to stop it?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 4 2013

Added on Jul 16 2008

#heterogeneous-connectivity

3 comments

4,243 views