Re: Informix Connect

On Tue, 20 Apr 2004 17:32:51 -0400, Paul Watson wrote: > I thought SCO Unix was originally based on Xenix which was owned (??) by > Mircosoft SCO Xenix and SCO UNIX are different code bases. SCO Xenix WAS derived from the original MS Xenix for IBM XT, but SCO UNIX was a pure port of System V.4. Art S. Kagel > "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 dri