[KLUG Members] Informix ODBC Gehenna

Bert members@kalamazoolinux.org
Fri, 02 May 2003 09:54:59 +0200


Thomas wrote:

>I am trying to get my ODBC connection to my informix database to work
>(again).  It was working only days ago, and now not.
>
>There are no LAN changes that have been made.
>
>I will not be able to get truthful answers concerning what another admin
>has done with system so it is up to me to get this working again; today;
>then tomorrow; then the next day. (But that is another story)  I am not
>complaining, as iron sharpens iron, so one man sharpens another.  
>
>I emphasize that this WAS working so that hardware can be ruled out as a
>cause.
>
>We are running SCO unix, 
>Uname -a reports
>SCO_SV cityhall 3.2 5.0.6 i386
>
>Informix is version: 7.20.UE5
>
>I have previously installed Informix's SETNET32
>
>Here are screen captures for them.
>	Environment tab:
>www.geocities.com/pikitfense/setnet1.jpg
>	Server information:	www.geocities.com/pikitfense/setnet2.jpg
>	Host information
>www.geocities.com/pikitfense/setnet3.jpg
>	About 			www.geocities.com/pikitfense/setnet4.jpg
>
>I run the ILOGIN program that comes with setnet 32 and this is what the
>screen looks like.
>www.geocities.com/pikitfense/ilogin1.jpg
>
>And this is the error message I get:
>http://www.geocities.com/pikitfense/ilogin2.jpg
>
>(in case you don't know.  The setnet32 programs will setup an ODBC
>connection and test it.  The Setnet32 is _LIKE_ the ODBC setup in the
>control panel.  The ilogin program allows you to check to see if the
>connection is working.)
>
>The full docs on this error message are here.
>	
>www.geocities.com/pikitfense/finderr.jpg
>
>	
>
Are you shure DNS is working? What if you try to telnet to the same 
host? e.g. telnet hostname 1526. Does it indeed show a connection 
comming up?


Bert.

>
>Here is the connection that I made in the ODBC folder of the control
>panel.  (Windows 2000).
>			www.geocities.com/pikitfense/ODBC.jpg
>
>
>When I test it I get the error 
>"Test connection was NOT successful.[Informix][Informix ODBC
>Driver][Informix]Cannot connect to database server (gtyserver1_tcp) 
>
>
>www.geocities.com/pikitfense/ODBCerr.jpg
>
>On the unix box my  /etc/services files has at the end
>gtyserver1_tcp	1526/tcp
>
>My /i/Informix/etc/onconfig.gtyserver1 files has the line
>DBSERVERALIASES gtyserver1_tcp
>
>
>Help me Obiwan Kanobi?
>
>-Thomas
>_______________________________________________
>Members mailing list
>Members@kalamazoolinux.org
>
>
>  
>