Re: Oracle 8.1.7.4 - Informix HS ODBC problem

[Quoted] 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_at_cri-uk.com> wrote in message news:<100fiiaomb8dn09_at_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"_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)
> 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
Received on Mon Jan 19 2004 - 11:40:02 CET