Re: Informix Connect

Posted in 2004

Topics: Error Codes & Troubleshooting, Connectivity: ODBC / JDBC / .NET

Tom — Wed, 21 Apr 2004 12:45:06 -0400 — source: Usenet: comp.databases.informix

On Wed, 21 Apr 2004 17:32:14 +0100, Paul Watson <paul@oninit.com> wrote: >Have you got a firewall in the way ??? > Not between me and this box. We are both behind our firewall. >Tom wrote: >> >> On Wed, 21 Apr 2004 16:15:36 +0100, Paul Watson <paul@oninit.com> >> wrote: >> >> >Tom wrote: >> >> >> >> On Tue, 20 Apr 2004 21:33:28 +0100, Paul Watson <paul@oninit.com> >> >> wrote: >> >> >> >> >What does the release notes say the connection should be? I don't >> >> >have a Sco box. >> >> >> >> I don't understand what you mean. >> > >> >In $INFORMIXDIR/release/*/*/ there should be a number of files, >> >look for the engine release note and see what the connection should be >> > >> >> >> >> > >> >> >Have you started sqlexecd ? >> >> >> >> Yes. >> > >> >Did you export the environment when you started it. When you run >> >netstat -a can you see the listener on the port? Is it the port >> >you are expecting? Telnet to <ip> <port>, you should get a >> >connection closed message. >> > >> No, but it was running when I telneted into it. (It's set up to >> bounce itself every night.) >> >> As I mentioned in my earlier msg, I see both "pei" and "pei2" when I >> use the netstat -a command. But nowhere do I see any mention of what >> port they're listening on. >> >> As for telnetting to it: >> >> C:\\ >> > telnet 10.254.2.10 1525 >> Connecting To 10.254.2.10...Could not open connection to the host, on >> port 1525: Connect failed >> >> >> >> >> > >> >> >I would expect the Unix end to be >> >> > >> >> >pei setlitcp eptsco sqlexec >> >> > >> >> >with a line in /etc/services for sqlexec >> >> > >> >> >> >> You mean like: >> >> >> >> sqlexec 1525/tcp # INFORMIX SQLexec DAEMON >> >> sqlexe2 1526/tcp # INFORMIX SQLexec DAEMON >> >> sqlexe3 1527/tcp # INFORMIX SQLexec DAEMON >> >> sqlexe4 1528/tcp # INFORMIX SQLexec DAEMON >> >> >> >> >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 >> >> >> >> Under the TCPIP TAB >> >> [ ip found ] 0 >> >> 9:18:35 AM : Ping IP 10.254.2.10 [ ip found ] 0 RoundTrip Time 7 ms >> >> Packet Size 11 bytes Hello There >> >> 9:18:35 AM : Fully Qualified HostName: 10.254.2.10 >> >> 9:18:35 AM : This Host has no Aliases >> >> 9:18:35 AM : Host IP Address(s) retrieved >> >> >> >> In Service and Port information >> >> (note - only service name worked, not port #) >> >> 9:19:57 AM : Service Name retrieved Sucessfully! >> >> 9:19:57 AM : This Service has no Aliases >> >> >> >> Under the Native Connect TAB >> >> SQLSTATE = 08004 >> >> SQLCODE = -908 >> >> >> >> 08004 means "Data source rejected establishment of connection"? >> > >> >The ODBC testing will not work 'cos of the above. It's not something >> >dumb like a mixture of case is it? >> > >> >> >> >> Under the COM+ TAB >> >> DSN=PentIBMtax;UID=informix;PWD=######## >> >> ATTEMPTING TO MAKE A CONNECTION >> >> CONNECTION FAILED >> >> -2147217843 >> >> [Informix][Informix ODBC Driver][Informix]Attempt to connect to >> >> database server (pei) failed. >> > >> >[cutting]

↪ replying to Tom

Paul Watson — Wed, 21 Apr 2004 17:55:02 +0100 — source: Usenet: comp.databases.informix

Is the PC XP with a firewalled lan connection? Tom wrote: > > On Wed, 21 Apr 2004 17:32:14 +0100, Paul Watson <paul@oninit.com> > wrote: > > >Have you got a firewall in the way ??? > > > Not between me and this box. We are both behind our firewall. > > >Tom wrote: > >> > >> On Wed, 21 Apr 2004 16:15:36 +0100, Paul Watson <paul@oninit.com> > >> wrote: > >> > >> >Tom wrote: > >> >> > >> >> On Tue, 20 Apr 2004 21:33:28 +0100, Paul Watson <paul@oninit.com> > >> >> wrote: > >> >> > >> >> >What does the release notes say the connection should be? I don't > >> >> >have a Sco box. > >> >> > >> >> I don't understand what you mean. > >> > > >> >In $INFORMIXDIR/release/*/*/ there should be a number of files, > >> >look for the engine release note and see what the connection should be > >> > > >> >> > >> >> > > >> >> >Have you started sqlexecd ? > >> >> > >> >> Yes. > >> > > >> >Did you export the environment when you started it. When you run > >> >netstat -a can you see the listener on the port? Is it the port > >> >you are expecting? Telnet to <ip> <port>, you should get a > >> >connection closed message. > >> > > >> No, but it was running when I telneted into it. (It's set up to > >> bounce itself every night.) > >> > >> As I mentioned in my earlier msg, I see both "pei" and "pei2" when I > >> use the netstat -a command. But nowhere do I see any mention of what > >> port they're listening on. > >> > >> As for telnetting to it: > >> > >> C:\\ > >> > telnet 10.254.2.10 1525 > >> Connecting To 10.254.2.10...Could not open connection to the host, on > >> port 1525: Connect failed > >> > >> >> > >> >> > > >> >> >I would expect the Unix end to be > >> >> > > >> >> >pei setlitcp eptsco sqlexec > >> >> > > >> >> >with a line in /etc/services for sqlexec > >> >> > > >> >> > >> >> You mean like: > >> >> > >> >> sqlexec 1525/tcp # INFORMIX SQLexec DAEMON > >> >> sqlexe2 1526/tcp # INFORMIX SQLexec DAEMON > >> >> sqlexe3 1527/tcp # INFORMIX SQLexec DAEMON > >> >> sqlexe4 1528/tcp # INFORMIX SQLexec DAEMON > >> >> > >> >> >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 > >> >> > >> >> Under the TCPIP TAB > >> >> [ ip found ] 0 > >> >> 9:18:35 AM : Ping IP 10.254.2.10 [ ip found ] 0 RoundTrip Time 7 ms > >> >> Packet Size 11 bytes Hello There > >> >> 9:18:35 AM : Fully Qualified HostName: 10.254.2.10 > >> >> 9:18:35 AM : This Host has no Aliases > >> >> 9:18:35 AM : Host IP Address(s) retrieved > >> >> > >> >> In Service and Port information > >> >> (note - only service name worked, not port #) > >> >> 9:19:57 AM : Service Name retrieved Sucessfully! > >> >> 9:19:57 AM : This Service has no Aliases > >> >> > >> >> Under the Native Connect TAB > >> >> SQLSTATE = 08004 > >> >> SQLCODE = -908 > >> >> > >> >> 08004 means "Data source rejected establishment of connection"? > >> > > >> >The ODBC testing will not work 'cos of the above. It's not something > >> >dumb like a mixture of case is it? > >> > > >> >> > >> >> Under the COM+ TAB > >> >> DSN=PentIBMtax;UID=informix;PWD=######## > >> >> ATTEMPTING TO MAKE A CONNECTION > >> >> CONNECTION FAILED > >> >> -2147217843 > >> >> [Informix][Informix ODBC Driver][Informix]Attempt to connect to > >> >> database server (pei) failed. > >> > > >> >[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 #

↪ replying to Paul Watson

Tom — Wed, 21 Apr 2004 14:29:39 -0400 — source: Usenet: comp.databases.informix

Yes, it is XP. No, the firewall is not enabled. I haven't played with it at all. (I had to ask one of the other guys where the heck it was so I could check it!) I wanted to check, just to make sure that Gateway didn't do anything with it. They didn't. On Wed, 21 Apr 2004 17:55:02 +0100, Paul Watson <paul@oninit.com> wrote: >Is the PC XP with a firewalled lan connection? > >Tom wrote: >> >> On Wed, 21 Apr 2004 17:32:14 +0100, Paul Watson <paul@oninit.com> >> wrote: >> >> >Have you got a firewall in the way ??? >> > >> Not between me and this box. We are both behind our firewall. >> >> >Tom wrote: >> >> >> >> On Wed, 21 Apr 2004 16:15:36 +0100, Paul Watson <paul@oninit.com> >> >> wrote: >> >> >> >> >Tom wrote: >> >> >> >> >> >> On Tue, 20 Apr 2004 21:33:28 +0100, Paul Watson <paul@oninit.com> >> >> >> wrote: >> >> >> >> >> >> >What does the release notes say the connection should be? I don't >> >> >> >have a Sco box. >> >> >> >> >> >> I don't understand what you mean. >> >> > >> >> >In $INFORMIXDIR/release/*/*/ there should be a number of files, >> >> >look for the engine release note and see what the connection should be >> >> > >> >> >> >> >> >> > >> >> >> >Have you started sqlexecd ? >> >> >> >> >> >> Yes. >> >> > >> >> >Did you export the environment when you started it. When you run >> >> >netstat -a can you see the listener on the port? Is it the port >> >> >you are expecting? Telnet to <ip> <port>, you should get a >> >> >connection closed message. >> >> > >> >> No, but it was running when I telneted into it. (It's set up to >> >> bounce itself every night.) >> >> >> >> As I mentioned in my earlier msg, I see both "pei" and "pei2" when I >> >> use the netstat -a command. But nowhere do I see any mention of what >> >> port they're listening on. >> >> >> >> As for telnetting to it: >> >> >> >> C:\\ >> >> > telnet 10.254.2.10 1525 >> >> Connecting To 10.254.2.10...Could not open connection to the host, on >> >> port 1525: Connect failed >> >> >> >> >> >> >> >> > >> >> >> >I would expect the Unix end to be >> >> >> > >> >> >> >pei setlitcp eptsco sqlexec >> >> >> > >> >> >> >with a line in /etc/services for sqlexec >> >> >> > >> >> >> >> >> >> You mean like: >> >> >> >> >> >> sqlexec 1525/tcp # INFORMIX SQLexec DAEMON >> >> >> sqlexe2 1526/tcp # INFORMIX SQLexec DAEMON >> >> >> sqlexe3 1527/tcp # INFORMIX SQLexec DAEMON >> >> >> sqlexe4 1528/tcp # INFORMIX SQLexec DAEMON >> >> >> >> >> >> >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 >> >> >> >> >> >> Under the TCPIP TAB >> >> >> [ ip found ] 0 >> >> >> 9:18:35 AM : Ping IP 10.254.2.10 [ ip found ] 0 RoundTrip Time 7 ms >> >> >> Packet Size 11 bytes Hello There >> >> >> 9:18:35 AM : Fully Qualified HostName: 10.254.2.10 >> >> >> 9:18:35 AM : This Host has no Aliases >> >> >> 9:18:35 AM : Host IP Address(s) retrieved >> >> >> >> >> >> In Service and Port information >> >> >> (note - only service name worked, not port #) >> >> >> 9:19:57 AM : Service Name retrieved Sucessfully! >> >> >> 9:19:57 AM : This Service has no Aliases >> >> >> >> >> >> Under the Native Connect TAB >> >> >> SQLSTATE = 08004 >> >> >> SQLCODE = -908 >> >> >> >> >> >> 08004 means "Data source rejected establishment of connection"? >> >> > >> >> >The ODBC testing will not work 'cos of the above. It's not something >> >> >dumb like a mixture of case is it? >> >> > >> >> >> >> >> >> Under the COM+ TAB >> >> >> DSN=PentIBMtax;UID=informix;PWD=######## >> >> >> ATTEMPTING TO MAKE A CONNECTION >> >> >> CONNECTION FAILED >> >> >> -2147217843 >> >> >> [Informix][Informix ODBC Driver][Informix]Attempt to connect to >> >> >> database server (pei) failed. >> >> > >> >> >[cutting]