Re: Informix Connect

I thought SCO Unix was originally based on Xenix which was owned (??) by Mircosoft "Art S. Kagel" wrote: > > On Tue, 20 Apr 2004 16:11:37 -0400, Tom wrote: > > NO NO NO NO > > under the hood SOC and TLI are the SAME protocol, TCP/IP. The only difference > is the call level interface. Mist systems derived from BSD use the Sockets > library API while those derived from AT&T System V.4 use the TLI API. However, > they are COMPLETELY communications compatible and neither will know that the > other is using a different API. On the SCO UNIX (based on System V) use the > setlitcp definitions, on the PC in setnet32 and/or the ODBC setup (based on > Berkley Sockets likely because MS would not license TLI from a competitor) use > sesoctcp. Use the same port numbers/service names on both systems. ALL will > be well! > > Art S. Kagel > > > Great. Here goes... > > > > What I've done: > > --------------- > > > > In my sqlhosts file on my SCO server, I changed: > > > > pei setlitcp eptsco sqlexec > > pei2 setlitcp eptsco sqlexe2 > > > > to: > > > > pei setlitcp eptsco sqlexec > > pei2 setlitcp eptsco sqlexe2 > > pei3 sesoctcp eptsco sqlexe3 > > pei4 sesoctcp eptsco sqlexe4 > > > > I've checked to see what I have running, and I only have two processes. One > > is "pei", and the other is "pei2". > > > > In my services file on my SCO server, I changed: > > > > no Informix entries > > > > to: > > > > sqlexec 1525/tcp # INFORMIX SQLexec DAEMON sqlexe2 1526/tcp > > # INFORMIX SQLexec DAEMON sqlexe3 1527/tcp # INFORMIX > > SQLexec DAEMON sqlexe4 1528/tcp # INFORMIX SQLexec DAEMON > > > > I added these lines to my services file on my XP client: > > > > sqlexec 1525/tcp # Informix SE server sqlexe2 1526/tcp # > > Informix SE server sqlexe3 1527/tcp # Informix SE server > > sqlexe4 1528/tcp # Informix SE server > > > > When I tried just substituting 'soc' for 'tli', it broke the app. > > > > When I try to connect via ODBC, using Informix Connect: (I used v2.81.TC2 > > initially, then I tried v2.80.TC1 with same results.) > > ------------------------------------------------------------------------------------------------ > > When I run Setnet32... > > > > Environment TAB > > INFORMIXDIR=C:\\Program Files\\Informix\\Connect\\ INFORMIXSERVER=pei> > INFORMIXSQLHOSTS= > > > > Server Information TAB > > IBM Informix Server - <pei> > > Hostname - <server's IP address> > > Protocolname - <sesoctcp> > > Service Name - <1525> > > Options - <empty> > > > > Host Information TAB > > Current Host - <server's IP address> > > User Name - <informix> > > Password Option - <password> > > Password - <informix's password> > > > > About Setnet32 > > 9.53 2.81.TC2 > > > > When I run ILogin Demo... > > > > Login parameters > > Server pei > > Hostname server's IP address > > Servicename 1525 > > Protocolname sesoctcp > > Username informix > > Password informix's password > > Stores Database Stores7 <or one of my databases> > > > > I get an error message... > > > > Message from ILogin Demo > > Database: Sqlcode = -908 > > Refer to informix Find Error utility or Informix Error Messages manual > > for > > more details on this Error number. > > > > Using Connect's Find Error, I get: > > > > Attempt to connect to database server (servername) failed. > > > > The program or application is trying to access another database server but > > has failed. Note the server name in the current statement. > > > > The desired database server is unavailable, or the network is down or is > > congested. Ask your DBA and system administrator to verify that the server > > and network are operational. If the network is congested, use the > > environment variables INFORMIXCONTIME and INFORMIXCONRETRY to tune > > connection timing. For information on setting these environment variables, > > see the Informix Guide to SQL: Reference. > > > > This message appears in Version 6.0 and later versions. > > > > .......... > > > > The server is up and running, as I'm running a telnet session to it at the > > same time I'm doing the above. The server itself shouldn't be too burdened, > > as there are only three other people who use it only occasionally. And I > > don't THINK the network is a problem, as I don't have a response time > > problem with my telnet sessions. (Or my talking to our AS/400's DB2 db > > either. (In a different building.)) > > > > .......... > > > > If I change the IP address to the hostname <eptsco>, I get an error -930. > > Find Error says: > > > > Cannot connect to database server servername. > > > > The application is trying to access another computer system but failed. Note > > the server name in the current statement. Ask your network administrator and > > DBA to check that the network is operational and that the particular > > database server is active. This message appears with Version 6.0 and later. > > > > > > -930 Cannot connect to remote host sitename. > > > > INFORMIX-STAR or INFORMIX-NET is trying to access another computer system > > but has failed. Note the site name in the current statement. Contact your > > network administrator, and ask for a check that the network is operational > > and that the particular site is active. This message appears in database > > servers prior to Version 6.0. > > > > .......... > > > > This makes me think that I'm getting to the "box", when I use the IP > > address, but not the Informix engine. Would you agree? > > > > > > When I try to connect using Data Direct: > > ---------------------------------------------------------------------- > > > > ODBC Informix Driver Setup > > > > General TAB > > Data Soutce Name: PentDDtax > > Description: Pent tax db > > tax > > > > Connection TAB > > Database List: emtpy > > Default User Name: informix Use Default Login = unchecked Host Name: > > server's IP address Service Name: 1525 > > Server Name: pei > > Protocol type: sesoctcp > > > > Logon to INFORMIX window... > > > > Database Name: tax > > Host Name: server's IP address > > User Name: informix > > Password: informix's password > > > > Warning window... > > > > [DataDirect][ODBC Informix driver]Invalid attribute > > in connection string: Description.[DataDirect][ODBC Informix > > driver][Informix]Attempt to connect to database server (pei) failed. > > [DataDirect][ODBC Informix driver]Connection refused > > > > > > If I check the "Use Default Login" checkbox, and try to test the connection, > > I get: > > > > Test Connection Error > > > > [DataDirect][ODBC Informix driver][Informix]Attempt@@N