Problem In Accessing data Using Oracle Transparent gateway connectivity.

From: <lovkeshanand_at_gmail.com>
Date: 13 Dec 2005 01:06:50 -0800
Message-ID: <1134464810.505976.182740@f14g2000cwb.googlegroups.com>

Hi,
As of now the error in trace File of tg4msql folder following error comes as:-

[Microsoft][ODBC SQL Server Driver]Timeout expired (SQL State: S1T00; SQL Code: 0)

and for this I set the remote query timeout value =0(for Unlimited) in Oracle server,but this Doesn't work, Now I am very much confused with this as I have wasted around 6 days on this,Please Suggest me what To do Next.

Thanks

Lovkesh

hpuxrac wrote:
> lovkeshanand_at_gmail.com wrote:
> > This gave a following error:-
> >
> > "WEB_30_SUM", "WEB_360_COUNT", "WEB_360_SUM", "WEB_90_COUNT",
> > "WEB_90_SUM"
> > *
> > ERROR at line 48:
> > ORA-28500: connection from ORACLE to a non-Oracle system returned this
> > message:
> > [Transparent gateway for MSSQL]
> > ORA-02063: preceding 2 lines from DBL_GETGC1
> >
> >
> > Elapsed: 00:01:01.04
> >
> > after this I set The paramater "HS_FDS_TRACE_LEVEL=ON" in INIt file of
> > tg4msql Folder then in the trace File of tg4msql folder following error
> > comes:-
> >
> > Oracle Corporation --- WEDNESDAY DEC 07 2005 02:57:51.966
> >
> >
> > Heterogeneous Agent Release
> > 9.2.0.1.0
> >
> >
> > HS Agent received unexpected RPC disconnect
> > Network error 1003: NCR-01003: NCRS: Read error.
> >
> > and few moments back it also gave the Following error:-
> >
> > Oracle Corporation --- THURSDAY DEC 08 2005 12:24:00.593
> >
> >
> > Heterogeneous Agent Release
> > 9.2.0.1.0

>

> Just a wild guess that your software may not be patched appropriately.
> 9.2.0.1 is missing a whole bunch of oracle patchsets.

>

> It may have been fixed a long time ago by oracle software maintenance
> but if you don't run the patched version ... you don't get possible
> fixes.

>

> > If any one has Faced the similar kind of problem and Can help me,Please
> > let me Know where I am doing Wrong and How this error can be ractified.

>

> Check with your dba and see if your system's are appropriately patched.
> If you get a reproducible problem work with oracle support.
Received on Tue Dec 13 2005 - 03:06:50 CST