Oracle 8.1.7.4 - Informix HS ODBC problem

From: Andrew Carruthers <andrewcarruthers_at_cri-uk.com>
Date: Fri, 16 Jan 2004 11:30:26 -0000
Message-ID: <100fiiaomb8dn09_at_corp.supernews.com>

[Quoted] [Quoted] I'd be grateful if anyone can help with a problem I'm having, I can't find [Quoted] any information on Metalink for this message. The ODBC driver is working correctly as the Informix IloginDemo works fine, ODBC version 2.81

Thanks!

select * from "GLTRAN"_at_hsodbc

                       *

ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Generic Connectivity Using ODBC]DRV_InitTdp: [Informix][Informix ODBC Driver]Unable to load translation DLL. (SQL State: IM009; SQL Code: -11048) [Quoted] ORA-02063: preceding 2 lines from HSODBC

tnsnames.ora and listener.ora are configred correctly to get to this point

trace file
FRIDAY JAN 16 2004 11:09:07.452
(0) hoagprd(2); Entered.
(0) [Generic Connectivity Using ODBC] version: 2.0.4.0.0010
(0) connect string is:
(0)

YEAR2000_POLICY=-1;CTL_DEBUG=T;CONSUMER_API=1;SESSION_BEHAVIOR_FLAGS=4;PARSE R_-
(0) DEPTH=2000;EXEC_FLAGS =
(0) 131080;defTdpName=hsodbc;binding=(hsodbc,ODBC,"Mentor");
(0) ORACLE GENERIC GATEWAY Log File Started at 16-Jan-04 11:09:07
(0) Class version: 65
(0) hoagprd(2); Exited with retcode = 0.
(0) hoainit(3); Entered.
(0) hoainit(3); Exited with retcode = 0.
(0) hoalgon(7); Entered. name = transfer.
[Quoted] (0) [Informix][Informix ODBC Driver]Unable to load translation DLL. (SQL
State:
(0) IM009; SQL Code: -11048)
(0) DRV_InitTdp: [Informix][Informix ODBC Driver]Unable to load translation
DLL.
(0) (SQL State: IM009; SQL Code: -11048)
(0)
(0) nvRETURN (P:\Src\DRV\DRV_BIND.C 324): -2220
(0) nvRETURN (P:\Src\NAV_BIND.C 417): -2220
[Quoted] (0) nvOUT (P:\Src\UTIL\GETERROR.C 327): DRV_InitTdp: [Informix][Informix
ODBC
(0) Driver]Unable to load translation DLL. (SQL State: IM009; SQL
Code: -11048)
(0) hoalgon(7); Exited with retcode = 28500.
(0) hoaexit(6); Entered.
(0) hoaexit(6); Exited with retcode = 0.
(0) Closing log file at FRI JAN 16 11:09:08 2004.

hsodbc.ora

#
# HS init parameters
#

HS_FDS_CONNECT_INFO = Mentor

#HS_FDS_TRACE_LEVEL = 0
HS_FDS_TRACE_LEVEL=DEBUG HS_FDS_TRACE_FILE_NAME = hsodbc_trace.log

#HS_LANGUAGE=AMERICAN_AMERICA.CP1252

#
# Environment variables required for the non-Oracle system
#
#set <envvar>=<value>

set ODBCINI=c:\winnt Received on Fri Jan 16 2004 - 12:30:26 CET