My server is an SCO Open Server Release 5.0.5, with Informix SE 7.23.
I'm trying to access the data via ODBC, and I'm told that I need some
"extra" software, like Informix Connect. The trouble is that it
doesn't appear to support the protocol that I need (setlitcp). The
only version I can get from IBM's website is 2.8x. I was hoping that
perhaps an earlier version would support the version I need. Anyone
know where I can get/try an earlier version?

I've tried changing the protocol from "setlitcp" to "sesoctcp". THAT
didn't work either. (All I changed was the entries in the sqlhosts
file.) My sqlhosts file has:

pei setlitcp eptsco sqlexec
pei2 setlitcp eptsco sqlexe2

Could I "add" the protocol I need? Is there a way I can tell if it's
available?

Is there anything [else] I want/need on the server side so I can talk
to my db with ODBC drivers for Informix, on my client? It's been so
long, I don't know how to tell, and I have no docs whatsoever.

Any help is much appreciated.

Thanks,

Tom

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

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

I still can't connect to my Informix databases. The answer APPEARS
that I need to change the current "setlitcp" protocol to "sesoctcp".
But when I tried just substituting 'soc' for 'tli', it broke the app.

Would anyone know how I can check to see if I can in fact add the
'soc' protocol? And what all I have to do to accomplish it?

Thanks in advance,

Tom

On Thu, 08 Apr 2004 16:46:05 -0400, Tom <tsmith@eastpointcity.org>
wrote:

>My server is an SCO Open Server Release 5.0.5, with Informix SE 7.23.
>I'm trying to access the data via ODBC, and I'm told that I need some
>"extra" software, like Informix Connect. The trouble is that it
>doesn't appear to support the protocol that I need (setlitcp). The
>only version I can get from IBM's website is 2.8x. I was hoping that
>perhaps an earlier version would support the version I need. Anyone
>know where I can get/try an earlier version?
>
>I've tried changing the protocol from "setlitcp" to "sesoctcp". THAT
>didn't work either. (All I changed was the entries in the sqlhosts
>file.) My sqlhosts file has:
>
>pei setlitcp eptsco sqlexec
>pei2 setlitcp eptsco sqlexe2
>
>Could I "add" the protocol I need? Is there a way I can tell if it's
>available?
>
>Is there anything [else] I want/need on the server side so I can talk
>to my db with ODBC drivers for Informix, on my client? It's been so
>long, I don't know how to tell, and I have no docs whatsoever.
>
>Any help is much appreciated.
>
>Thanks,
>
>Tom
>

I still don't think you started the sqlexecd deamon yet.

Log in as root,

set up your standard SE profile (Informixdir , informixserver, path
....)

and then run, from the command line, $INFORMIXDIR/lib/sqlexecd

You may want to check out some of the "Logging" options on this
command as it can help identify other problems. I think this is
documented in the SE administrators guide.

Once you have successfully started that service (ps -eaf | grep
sqlexec), if your clients are on PCs, try running the ilogin demo app
and if that fails, let us know the error number/message

If the service doesn't start, again, let us know the error message you
are receiving.









Tom <tsmith@eastpointcity.org> wrote in message news:<60pd70p76egjdidcnfl8jbrl3i2otsqiu0@4ax.com>. ..
> 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
>
> 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
>
> I still can't connect to my Informix databases. The answer APPEARS
> that I need to change the current "setlitcp" protocol to "sesoctcp".
> But when I tried just substituting 'soc' for 'tli', it broke the app.
>
> Would anyone know how I can check to see if I can in fact add the
> 'soc' protocol? And what all I have to do to accomplish it?
>
> Thanks in advance,
>
> Tom
>
> On Thu, 08 Apr 2004 16:46:05 -0400, Tom <tsmith@eastpointcity.org>
> wrote:
>
> >My server is an SCO Open Server Release 5.0.5, with Informix SE 7.23.
> >I'm trying to access the data via ODBC, and I'm told that I need some
> >"extra" software, like Informix Connect. The trouble is that it
> >doesn't appear to support the protocol that I need (setlitcp). The
> >only version I can get from IBM's website is 2.8x. I was hoping that
> >perhaps an earlier version would support the version I need. Anyone
> >know where I can get/try an earlier version?
> >
> >I've tried changing the protocol from "setlitcp" to "sesoctcp". THAT
> >didn't work either. (All I changed was the entries in the sqlhosts
> >file.) My sqlhosts file has:
> >
> >pei setlitcp eptsco sqlexec
> >pei2 setlitcp eptsco sqlexe2
> >
> >Could I "add" the protocol I need? Is there a way I can tell if it's
> >available?
> >
> >Is there anything [else] I want/need on the server side so I can talk
> >to my db with ODBC drivers for Informix, on my client? It's been so
> >long, I don't know how to tell, and I have no docs whatsoever.
> >
> >Any help is much appreciated.
> >
> >Thanks,
> >
> >Tom
> >