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 f
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 message:
[Transparent gateway f
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
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 store
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.
Pro