Re: Using HS

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).