Re: Oracle 8.1.7.4 - Informix HS ODBC problem

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_at_openlinksw.co.uk> wrote in message news:2c804093.0401190240.1449adf0_at_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_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 - 16:03:28 CET