Re: unix odbc and informix datasource problem

Posted in 2006

Topics: Installation, Setup & Upgrades, Connectivity: ODBC / JDBC / .NET, Connectivity: ESQL/C, 4GL & Embedded SQL, Internationalization & Character Sets

kjuliff@gmail.com — 18 Jul 2006 14:21:27 -0700 — source: Usenet: comp.databases.informix

OK. I have installed sdk 32 bit and have set up my INFORMIXDIR to point to where it is installed /usr/informix32/.... This is the contents of my odnbinst.ini file [Informix] Description=Informix IDS 2000 Driver=/usr/informix32/lib/cli/iclis09b.so APILevel=1 ConnectFunctions=YYY DriverODBCVer=03.00 FileUsage=0 SQLLevel=1 smProcessPerConnect=Y and this of my odbc.ini file [pic2] Driver=Informix Server=kylie Database=pic2 CLIENT_LOCALE=en_us.8859-1 DB_LOCALE=en_us.8859-1TRANSLATIONDLL=/usr/informix32/lib/esql/igo4a304.so And now I get only [root@kylie bin]# ./isql pic2 [ISQL]ERROR: Could not SQLConnect No other error. I followed the instructions in http://www.unixodbc.org/doc/informix.html So I'm not sure where I'm going wrong .... Any help appreciated

↪ replying to kjuliff@gmail.com

Sheshnarayan Agrawal — Wed, 19 Jul 2006 15:48:53 +0530 — source: Usenet: comp.databases.informix

What version of unix ODBC DM are you using? Is it >= 2.2.11? As enough error message is not provided...Are you getting something of "ERROR -11048: UNABLE TO LOAD TRANSLATION SHARED LIBRARY (DLL)" ..If so there ishigh possibility that you are hitting Informix ODBC defect 175992. Ask your Tech Support for the patch. There is workaround exist, while linking(your application) if you use libifgls.so library (i.e -lifgls) then you will not see this issue. Thanks & Regards -Shesh "kjuliff@gmail.com" <kjuliff@gmail.com> Sent by: informix-list-bounces@iiug.org 07/19/2006 02:51 AM To informix-list@iiug.org cc Subject Re: unix odbc and informix datasource problem OK. I have installed sdk 32 bit and have set up my INFORMIXDIR to point to where it is installed /usr/informix32/.... This is the contents of my odnbinst.ini file [Informix] Description=Informix IDS 2000 Driver=/usr/informix32/lib/cli/iclis09b.so APILevel=1 ConnectFunctions=YYY DriverODBCVer=03.00 FileUsage=0 SQLLevel=1 smProcessPerConnect=Y and this of my odbc.ini file [pic2] Driver=Informix Server=kylie Database=pic2 CLIENT_LOCALE=en_us.8859-1 DB_LOCALE=en_us.8859-1TRANSLATIONDLL=/usr/informix32/lib/esql/igo4a304.so And now I get only [root@kylie bin]# ./isql pic2 [ISQL]ERROR: Could not SQLConnect No other error. I followed the instructions in http://www.unixodbc.org/doc/informix.html So I'm not sure where I'm going wrong .... Any help appreciated _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list

↪ replying to Sheshnarayan Agrawal

kjuliff@gmail.com — 19 Jul 2006 07:05:24 -0700 — source: Usenet: comp.databases.informix

> What version of unix ODBC DM are you using? Is it >= 2.2.11? Yes it is As enough > error message is not provided...Are you getting something of "ERROR > -11048: UNABLE TO LOAD TRANSLATION SHARED LIBRARY (DLL)" .. No, there IS no error message. Just what I posted. Kate If so there is > high possibility that you are hitting Informix ODBC defect 175992. Ask > your Tech Support for the patch. > > There is workaround exist, while linking(your application) if you use > libifgls.so library (i.e -lifgls) then you will not see this issue. > > Thanks & Regards > -Shesh > > > > > "kjuliff@gmail.com" <kjuliff@gmail.com> > Sent by: informix-list-bounces@iiug.org > 07/19/2006 02:51 AM > > To > informix-list@iiug.org > cc > > Subject > Re: unix odbc and informix datasource problem > > > > > > > OK. I have installed sdk 32 bit and have set up my INFORMIXDIR to point > to where it is installed /usr/informix32/.... > > This is the contents of my odnbinst.ini file > > [Informix] > Description=Informix IDS 2000 > Driver=/usr/informix32/lib/cli/iclis09b.so > APILevel=1 > ConnectFunctions=YYY > DriverODBCVer=03.00 > FileUsage=0 > SQLLevel=1 > smProcessPerConnect=Y > > > and this of my odbc.ini file > [pic2] > Driver=Informix > Server=kylie > Database=pic2 > CLIENT_LOCALE=en_us.8859-1 > DB_LOCALE=en_us.8859-1> TRANSLATIONDLL=/usr/informix32/lib/esql/igo4a304.so > > > And now I get only > [root@kylie bin]# ./isql pic2 > [ISQL]ERROR: Could not SQLConnect > > > No other error. > > I followed the instructions in > http://www.unixodbc.org/doc/informix.html > > So I'm not sure where I'm going wrong .... > > Any help appreciated > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > > > --=_alternative 00382AFA652571B0_= > Content-Type: text/html > X-Google-AttachSize: 2630 > > > What version of unix ODBC DM are you > using? Is it >= 2.2.11? As enough error message is not provided...Are > you getting something of  "ERROR -11048: UNABLE TO LOAD TRANSLATION > SHARED LIBRARY (DLL)" ..If so there is high possibility that you are > hitting Informix ODBC defect 175992. Ask your Tech Support for the patch. > > There is workaround exist, while linking(your > application) if you use libifgls.so library (i.e -lifgls) then you will > not see this issue. > > Thanks & Regards > -Shesh > > > > > <table width=100%> > <tr valign=top> > <td width=40%>"kjuliff@gmail.com" > <kjuliff@gmail.com> > Sent by: informix-list-bounces@iiug.org > 07/19/2006 02:51 AM > <td width=59%> > <table width=100%> > <tr valign=top> > <td> > <div align=right>To</div> > <td>informix-list@iiug.org > <tr valign=top> > <td> > <div align=right>cc</div> > <td> > <tr valign=top> > <td> > <div align=right>Subject</div> > <td>Re: unix odbc and informix datasource > problem</table> > > <table> > <tr valign=top> > <td> > <td></table> > </table> > > > <tt>OK. I have installed sdk 32 bit and have set up my > INFORMIXDIR to point > to where it is installed /usr/informix32/.... > > This is the contents of my odnbinst.ini file > > [Informix] > Description=Informix IDS 2000 > Driver=/usr/informix32/lib/cli/iclis09b.so > APILevel=1 > ConnectFunctions=YYY > DriverODBCVer=03.00 > FileUsage=0 > SQLLevel=1 > smProcessPerConnect=Y > > > and this of my odbc.ini file > [pic2] > Driver=Informix > Server=kylie > Database=pic2 > CLIENT_LOCALE=en_us.8859-1 > DB_LOCALE=en_us.8859-1 > TRANSLATIONDLL=/usr/informix32/lib/esql/igo4a304.so > > > And now I get only > [root@kylie bin]# ./isql pic2 > [ISQL]ERROR: Could not SQLConnect > > > No other error. > > I followed  the instructions in > http://www.unixodbc.org/doc/informix.html ; > > So I'm not sure where I'm going wrong .... > > Any help appreciated > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list ; > </tt> > > --=_alternative 00382AFA652571B0_=--

Re: unix odbc and informix datasource problem

Glossary

Your privacy choices