Oracle 8.1.7.4 - Informix HS ODBC problem

[Andrew Carruthers]

I'd be grateful if anyone can help with a problem I'm having, I can't find
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"@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)
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.
(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
(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

[Emmon Simbo]

Hi Andrew

One thing that springs to mind is your ODBCINI variable,

set ODBCINI=c:\winnt

As far as I know, odbcini does not reside here. Typically when
configuring HS for use with our own ODBC drivers, I tend to leave this
variable unset. This is simply because, on Windows, as opposed to
*nix, you tend to have a set place for the ODBCINI variable which by
default is set in the registry.

May I suggest you comment out that line. Another thing I might add is,
also enclose your Datasource name in quotes e.g...

HS_FDS_CONNECT_INFO = "mt_mysql_oneal"

Regards,

Emmon Simbo
Technical Services Manager
OpenLink Software
Universal Data Access & Virtual Database Technology Providers
http://www.openlinksw.com






"Andrew Carruthers" <andrewcarruthers@cri-uk.com> wrote in message news:<100fiiaomb8dn09@corp.supernews.com>... I'd be grateful if anyone can help with a problem I'm having, I can't find 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"@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) 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. (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 (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

[Andrew Carruthers]

Thanks Emmon,

The solution turned out to be simple - rebooting the server...

It looks like the paths were not set correctly after the ODBC install,
confusing as the ODBC connection worked through Oracle ODBC Test program
before the reboot


"Emmon Simbo" <esimbo@openlinksw.co.uk> wrote in message
news:2c804093.0401190240.1449adf0@posting.google.com... Hi Andrew One thing that springs to mind is your ODBCINI variable, set ODBCINI=c:\winnt As far as I know, odbcini does not reside here. Typically when configuring HS for use with our own ODBC drivers, I tend to leave this variable unset. This is simply because, on Windows, as opposed to *nix, you tend to have a set place for the ODBCINI variable which by default is set in the registry. May I suggest you comment out that line. Another thing I might add is, also enclose your Datasource name in quotes e.g... HS_FDS_CONNECT_INFO = "mt_mysql_oneal" Regards, Emmon Simbo Technical Services Manager OpenLink Software Universal Data Access & Virtual Database Technology Providers http://www.openlinksw.com "Andrew Carruthers" <andrewcarruthers@cri-uk.com> wrote in message
news:<100fiiaomb8dn09@corp.supernews.com>... I'd be grateful if anyone can help with a problem I'm having, I can't
find 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"@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) 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. (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 (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