Oninit cdi / Archive
Talk to an expert →

Informix ODBC v9.x on AIX

Posted in 2003

GarryS@charlesmcmurray.com — — source: Usenet: comp.databases.informix

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C31FCE.B60809D0 Content-Type: text/plain I am looking for some help that will get the ODBC working. AIX v 4.3 Informix 9.6.2.5 w/ Informix ODBC 3.7 We are migrating to the RS6000 using the Informix database. We are AIX and Informix neophytes and need some help getting ODBC configured on the server. We are currently using ODBC drivers to connect our web application and Excel powerusers to our legacy HP3000 Image database. I have completed all of the steps for installing and configuring the server(AIX) and Client(win98). It appears that there is a problem with the UNIRPCD running or a UNIVERSE LOGIN script? Any help would be appreciated. Below are some config info from our AIX server. ------------------------------------------------------------------------- AIX 4.3 -------------------------------------------------------------- # ps -ef | grep unirpcd root 90144 24812 0 15:42:10 pts/5 0:00 grep unirpcd ---------------------------------------------------------- # uvosrv -v UniVerse ODBC Server Version 3.7 Copyright (c) 2000 Informix Software, Inc. All rights reserved. # uname -a AIX rs6k 3 4 0002712F4C00 # ps -ef | grep inetd root 4408 4946 0 Jan 26 - 0:02 /usr/sbin/inetd root 90156 24812 1 15:43:41 pts/5 0:00 grep inetd # ps -aux | grep unirpcd# rsh rs6k echo good rshd: 0826-813 Permission is denied. # ---------------------------------------------- INFORMIX >.L RELLEVEL RELLEVEL 001 X-type - The RELEASE LEVEL of this account 002 9.6.2.5 003 ADMIN 004 005 9.6.2.5 Garry Smith Dir. Info Systems Charles McMurray Company V# 559-292-5782 F# 559-346-6169 ------_=_NextPart_001_01C31FCE.B60809D0 Content-Type: text/html Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Dus-ascii"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2653.12"> <TITLE>Informix ODBC v9.x on AIX</TITLE> </HEAD> <BODY> <P><FONT SIZE=3D2 FACE=3D"Arial">I am looking for some help that will = get the ODBC working. AIX v 4.3 Informix 9.6.2.5 w/ Informix ODBC = 3.7</FONT> </P> <P><FONT SIZE=3D2 FACE=3D"Arial">We are migrating to the RS6000 using = the Informix database. We are AIX and Informix neophytes and need some = help getting ODBC configured on the server. We are currently using ODBC = drivers to connect our web application and Excel powerusers to our = legacy HP3000 Image database.</FONT></P> <P><FONT SIZE=3D2 FACE=3D"Arial">I have completed all of the steps for = installing and configuring the server(AIX) and Client(win98).</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">It appears that there is a problem = with the UNIRPCD running or a UNIVERSE LOGIN script?</FONT> </P> <P><FONT SIZE=3D2 FACE=3D"Arial">Any help would be appreciated. Below = are some config info from our AIX server.</FONT> </P> <P><FONT SIZE=3D2 = FACE=3D"Arial">---------------------------------------------------------= ----------------</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">AIX 4.3</FONT> <BR><FONT SIZE=3D2 = FACE=3D"Arial">---------------------------------------------------------= -----</FONT> </P> <P><FONT SIZE=3D2 FACE=3D"Arial"># ps -ef | grep = unirpcd&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp= ;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp= ;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp= ;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp= ;&nbsp; </FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp;&nbsp;&nbsp; root&nbsp; = 90144&nbsp; 24812&nbsp;&nbsp; 0 15:42:10&nbsp; pts/5&nbsp; 0:00 grep = unirpcd&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = </FONT> </P> <P><FONT SIZE=3D2 = FACE=3D"Arial">---------------------------------------------------------= -</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial"># uvosrv = -v&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs= p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs= p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs= p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs= p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs= p; </FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">UniVerse ODBC Server Version = 3.7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb= sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb= sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb= sp;&nbsp;&nbsp;&nbsp; </FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">Copyright (c) 2000 Informix Software, = Inc.&nbsp; All rights = reserved.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </FONT> <BR><FONT SIZE=3D2 = FACE=3D"Arial">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb= sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb= sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb= sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb= sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb= sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb= sp;&nbsp; </FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial"># uname = -a&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs= p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs= p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs= p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs= p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs= p;&nbsp; </FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">AIX rs6k 3 4 = 0002712F4C00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;= &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;= &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;= &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;= </FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial"># ps -ef | grep = inetd&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&= nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&= nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&= nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&= nbsp;&nbsp;&nbsp; </FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp;&nbsp;&nbsp; root&nbsp;&nbsp; = 4408&nbsp;&nbsp; 4946&nbsp;&nbsp; 0&nbsp;&nbsp; Jan = 26&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp; 0:02 = /usr/sbin/inetd&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </FONT> <BR><FONT S