Re: Using HS

It must be a silly environment issue. Are you using a Merant driver on the Sun to SQL server (I was not aware that there is such a Merant driver), or are you using SQL*NET to get to the NT where HS is activating Merant?

• If Merant driver is on the Sun, I would check the listener environment. Probably the ODBCINI environment variable is not set.
• If Merant driver is on NT, the most common case is if you defined a user DSN instead of a system DSN. The listener starts HS under the system so the user DSN is not known.

Hope this helps...

Tzachi

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Friday, March 23, 2001 4:55 PM

> The SUN/Merant => NT link is ok because it is working
> when using Powermart.
> We just want to call a stored proc on MS SQL Server
> which is not allowed with Powermart 4.6 (it is
> supposed to work with Powermart 5) . So the idea is to
> call an Oracle Stored proc which would called a MS SQL
> Server stored proc. We won't buy the Gateway since
> Powermart 5 should do the job in a few months.
>
>
>
> --- Tzachi Nissim <tzachi_at_attunity.co.il> a écrit : >
> Looks like you did not setup the DSN name correctly.
> > Merant cannot find the
> > DSN name that HS passed to it. Look at their ODBCINI
> > file to verify that the
> > DSN appears there. I would suggest, however, that
> > you get the enterprise
> > gateway to SQL server. Performance will be better
> > too...
> >
> > I hope you had more fun in your vacation... :)
> >
> > Tzachi
> >
> > ----- Original Message -----
> > To: "Multiple recipients of list ORACLE-L"
> > <ORACLE-L_at_fatcity.com>
> > Sent: Thursday, March 22, 2001 7:30 PM
> >
> >
> > > Hi,
> > >
> > > Back from vacation and trying to make HS work
> > between
> > > Oracle 816/Solaris and MS SQl Server 6.5 or Oracle
> > > 817/Solaris MS SQl Server 6.5. The ODBC driver is
> > > Merant 360.
> > >
> > >
> > > On 816 I'm having :
> > > ORA-28500: connection from ORACLE to a non-Oracle
> > > system returned this mess
> > > age:
> > > [Transparent gateway for ODBC]DRV_InitTdp:
> > > [MERANT][ODBC lib] Data source name not found and
> > no
> > > default driver specified (SQL State: IM002; SQL
> > Code:
> > > 0)
> > > ORA-02063: preceding 2 lines from HSODBC
> > >
> > >
> > > On 817 I'm having
> > > ORA-28509: unable to establish a connection to a
> > > non-Oracle system
> > > ORA-02063: preceding line from HSODBC
> > >
> > >
> > > Anybody ?
> > >
> > >
> > >
> > > =====
> > > Stéphane Paquette
> > > DBA Oracle, consultant entrepôt de données
> > > Oracle DBA, datawarehouse consultant
> > > stephane_paquette_at_yahoo.com
> > >
> > > __________________________________________________
> > > Do You Yahoo!?
> > > Get email at your own domain with Yahoo! Mail.
> > > http://personal.mail.yahoo.com/
> > > --
> > > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > > --
> > > Author: =?iso-8859-1?q?paquette=20stephane?=
> > > INET: stephane_paquette_at_yahoo.com
> > >
> > > Fat City Network Services -- (858) 538-5051
> > FAX: (858) 538-5051
> > > San Diego, California -- Public Internet
> > access / Mailing Lists
> > >
> >
> --------------------------------------------------------------------
> > > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > > to: ListGuru_at_fatcity.com (note EXACT spelling of
> > 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > > (or the name of mailing list you want to be
> > removed from). You may
> > > also send the HELP command for other information
> > (like subscribing).
> >
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > --
> > Author: Tzachi Nissim
> > INET: tzachi_at_attunity.co.il
> >
> > Fat City Network Services -- (858) 538-5051 FAX:
> > (858) 538-5051
> > San Diego, California -- Public Internet
> > access / Mailing Lists
> >
> --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of
> > 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > (or the name of mailing list you want to be removed
> > from). You may
> > also send the HELP command for other information
> > (like subscribing).
>
>
> =====
> Stéphane Paquette
> DBA Oracle, consultant entrepôt de données
> Oracle DBA, datawarehouse consultant
> stephane_paquette_at_yahoo.com
>
> __________________________________________________
> Do You Yahoo!?
> Get email at your own domain with Yahoo! Mail.
> http://personal.mail.yahoo.com/
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: =?iso-8859-1?q?paquette=20stephane?=
> INET: stephane_paquette_at_yahoo.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Tzachi Nissim
  INET: tzachi_at_attunity.co.il

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).