Re: Informix Connect

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 > to connect to database server (pei) failed. > > Then I click on "OK", and I get: > > Test Connection Error > > [DataDirect][ODBC Informix driver][Informix]Connection > refused > > Then I click on "OK", and I get: > > [DataDirect][ODBC Informix driver]Invalid attribute > in connection string: Description. > > > other > -------- > While looking for info that would help me, I did come across a couple@

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 to connect to database server (pei) failed. Then I click on "OK", and I get: Test Connection Error [DataDirect][ODBC Informix driver][Informix]Connection refused Then I click on "OK", and I get: [DataDirect][ODBC Informix driver]Invalid attribute in connection string: Description. other -------- While looking for info that would help me, I did come across a couple responses to questions similar to my problem. The responses mentioned something about permission for remote access. I don't have a clue how to check this, assuming it's really even a consideration. Thanks so much for your help... Tom On Mon, 19 Apr 2004 20:35:05 -0400, Dave Kosenko <dkosenko@no5pam.hotmail.com> wrote: >On Mon, 19 Apr 2004 16:55:12 -0400, Tom <tsmith@eastpointcity.org> >wrote: > >>I'm having a problem connecting to my db due to the fact that my >>Informix SE (v7.23) wants to talk via (SETLITCP). Any new ODBC driver >>I try wants to talk via (SESOCTCP). Does anyone know if an old >>version of Informix Connect will talk via TLI? The oldest I can find >>on IBM's website is v2.80.TC1. And it won't talk TLI either. >> >>Thanks in advance, >> >>Tom > >If memory serves, on the Windows side you could never specify TLI as@@

What does the release notes say the connection should be? I don't have a Sco box. Have you started sqlexecd ? I would expect the Unix end to be pei setlitcp eptsco sqlexec with a line in /etc/services for sqlexec at the PC end I tend to start with DBPing if it doesn't just work. If DBPing doesn't work then nothing else will Tom wrote: > > Great. Here goes... > [cutting] > 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 Looks OK, I tend to run regcopy after changing setnet32 > > 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 Is sqlexecd listening on the port, you can use netstat -a on server to check. [cutting] -- Paul Watson # Oninit Ltd # Growing old is mandatory Tel: +44 1436 672201 # Growing up is optional Fax: +44 1436 678693 # Mob: +44 7818 003457 # www.oninit.com #