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!

SQL connection timeout

Ramesh EegaApr 17 2002

We are using Oracle (817) and Gateway to connect to SqlServer 7 .When We are querying Sql Server from Oracle,
and if query takes more then 75 seconds (approx)
We are getting following error.

ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Transparent gateway for MSSQL]SQL Server connection timed out.
ORA-02063: preceding 2 lines from TG4MSQL
We talked to Sql Server DBAs. They said SQL Server timeout set to 0 which means no time limit.

We had been using gateway for sybase more then year and configured same as SQL Server.But we do not have any such problems.

We set listner timeout to 10 minutes for test on gateway ,but it seems that is not the problem.

We could not resolve the problem.Any help will be greatly appriciated

Locked Post

New comments cannot be posted to this locked post.

Locked on May 15 2002

Added on Apr 17 2002

#heterogeneous-connectivity

1 comment

371 views