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" <[EMAIL PROTECTED]>
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
> [EMAIL PROTECTED]
>
> __________________________________________________
> 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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
