Help! I've read every post on this board, and looked over a number of
documents. sqlhosts is reconfigured and running, listening on 1536.
What am I doing wrong?

(Connecting from XP SP2, using both IBM's ODBC and OpenLinks, same
result, to AIX 4.x.)

i have no idea what you try to accomplish ....
sqlhosts is reconfigured ... assume you mean sqlexecd?? or ids.

please clarify

Superboer


laurin1 schreef:

> Help! I've read every post on this board, and looked over a number of
> documents. sqlhosts is reconfigured and running, listening on 1536.
> What am I doing wrong?
>
> (Connecting from XP SP2, using both IBM's ODBC and OpenLinks, same
> result, to AIX 4.x.)

Yes, sqlhosts is reconfigured per
http://www.iiug.org/resources/linux/...s1_remote_conn.

I'm trying to open an ODBC connection from a Windows XP SP2 machine to
an IBM AIX/Informix machine.

Initially, laurin1 wrote:
> Help! I've read every post on this board, and looked over a number of
> documents. sqlhosts is reconfigured and running, listening on 1536.
> What am I doing wrong?
>
> (Connecting from XP SP2, using both IBM's ODBC and OpenLinks, same
> result, to AIX 4.x.)

When asked to clarify by superboer:
> i have no idea what you try to accomplish ....
> sqlhosts is reconfigured ... assume you mean sqlexecd?? or ids.

laurin1 responded:
> Yes, sqlhosts is reconfigured per
> http://www.iiug.org/resources/linux/...s1_remote_conn.
>
> I'm trying to open an ODBC connection from a Windows XP SP2 machine to
> an IBM AIX/Informix machine.

Now, laurin1 posts from a German domain (t-online.de), so we have to
make allowances for English not being his/her native language. I think
it is fair to assume that 'reconfigure' means the same as 'configure'.

http://www.catb.org/~esr/faqs/smart-questions.html

OK - what are we faced with?

Apparently, we have a Windows XP PC with, presumably, ODBC drivers
installed on it. It isn't clear whether the connectivity on the PC is
set up correctly.

We also have an IBM AIX 4.x machine - which should, therefore, have been
upgraded by now - and it is running some version of the Informix server
on it. We have no idea whether it is SE or IDS, but it is more likely
to be IDS than SE. It matters; there are lots of differences in the setup.

Assuming IDS is running, the next question is: is IDS configured to
support network connections? Is there an oltlitcp or olsoctcp server
name configured in the sqlhosts file on the Unix machine? Is it
listening on port 1536? What does the sqlhosts file entry on the Unix
box actually look like? What about the DBSERVERNAME and DBSERVERALIASES
in the ONCONFIG file? If you changed these recently, did you also
restart IDS since changing the configuration?

So, we come back to the Windows configuration? Have you established
that the SETNET32 entries are correct? The Linux FAQ may not be as
helpful for Windows and AIX as you'd like. Can any process on the
Windows machine connect to IDS on the AIX box? Exactly what error
messages are you getting? Can you get ESQL/C programs to run, or to
diagnose different error messages?

--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler@earthlink.net, jleffler@us.ibm.com
Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/

Well, I got it work, but just to clarify:

I'm not posting from t-online.de (where'd you get that from.) I'm
posting from Dallas, TX. Yes, i did mean reconfigure as sqlhosts is
already configured and i changed it to match what the site i indicated
told me to.

No, we are not going to upgrade it (too much money.) It's SE, not IDS.
I configured sqlhosts to use sesoctcp, just like the website told me
to. It was listening on 1536. sqlhosts looks like:

#************************************************* *************************
#
# INFORMIX SOFTWARE, INC.
#
# PROPRIETARY DATA
#
# THIS DOCUMENT CONTAINS TRADE SECRET DATA WHICH IS THE PROPERTY
OF
# INFORMIX SOFTWARE, INC. THIS DOCUMENT IS SUBMITTED TO
RECIPIENT IN
# CONFIDENCE. INFORMATION CONTAINED HEREIN MAY NOT BE USED,
COPIED OR
# DISCLOSED IN WHOLE OR IN PART EXCEPT AS PERMITTED BY WRITTEN
AGREEMENT
# SIGNED BY AN OFFICER OF INFORMIX SOFTWARE, INC.
#
# THIS MATERIAL IS ALSO COPYRIGHTED AS AN UNPUBLISHED WORK UNDER
# SECTIONS 104 AND 408 OF TITLE 17 OF THE UNITED STATES CODE.
# UNAUTHORIZED USE, COPYING OR OTHER REPRODUCTION IS PROHIBITED
BY LAW.
#
#
# Title: sqlhosts.demo
# Sccsid: @(#)sqlhosts.demo 9.2 7/15/93 15:20:45
# Description:
# Default sqlhosts file for running demos.
#
#************************************************* *************************

demo_on onipcshm on_hostname on_servername
demo_se seipcpip se_hostname sqlexec
rehabmgrnew seipcpip rehabmgrnew sqlexec
rm5 sesoctcp rehabmgrnew sqlexecd


I can't find an ONCONFIG file. No, no restarts. I've checked and
rechecked the Setnet32 entries. Before no processes could connect. What
is ESQL/C?

I'm not even sure why it wasn't working the first time, as I quit
messing with the settings and configured everything like the website i
indicated told me to, which is what I did the first time (and it didn't
work.) Now it's working.

I asked the question without giving much information in order to get
some fresh information on the subject, as i'd exhausted all my
resources.

Thanks for covering all that, as it may help me in the future.

laurin1 wrote:
> Well, I got it work, but just to clarify:
>
> I'm not posting from t-online.de (where'd you get that from.)

Dunno - sorry. I misread something.

> I'm posting from Dallas, TX. Yes, i did mean reconfigure as sqlhosts
> is already configured and i changed it to match what the site i
> indicated told me to.

OK.

> No, we are not going to upgrade it (too much money.) It's SE, not IDS.
> I configured sqlhosts to use sesoctcp, just like the website told me
> to. It was listening on 1536. sqlhosts looks like:

The information about SE vs IDS is critical.

> demo_on onipcshm on_hostname on_servername
> demo_se seipcpip se_hostname sqlexec
> rehabmgrnew seipcpip rehabmgrnew sqlexec
> rm5 sesoctcp rehabmgrnew sqlexecd
>
>
> I can't find an ONCONFIG file.

With SE, there is no such file - it is an IDS file.

The r5 entry is interesting; if you use it, your client code will run
sqlexecd, which will go into the background, so this one client will
fail. But the clients that follow will have an sqlexecd available.
Hmmm; interesting.

> No, no restarts. I've checked and
> rechecked the Setnet32 entries. Before no processes could connect. What
> is ESQL/C?

ESQL/C is a programming language. Clearly, it's not what you're using.
But then the question is - what are you using? Presumably, ODBC or one
of the other MS database access tool sets (ADO, OLEDB, .NET).

Have you got sqlexecd running on the Unix host? If not, you need it.

> I'm not even sure why it wasn't working the first time, as I quit
> messing with the settings and configured everything like the website i
> indicated told me to, which is what I did the first time (and it didn't
> work.) Now it's working.

Glad it is running - I'm not sure what you've done to get it working,
and I don't think my help made the difference.

--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler@earthlink.net, jleffler@us.ibm.com
Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/

Your input does help me understand better though.

Seeing as I'm not sure how I got it working, and I really need to
understand this better. Can you explain this comment more:

"he r5 entry is interesting; if you use it, your client code will run
sqlexecd, which will go into the background, so this one client will
fail. But the clients that follow will have an sqlexecd available.
Hmmm; interesting. "

BTW, I'm using Access and PHP via ODBC (actually PHP has an Informix
lib, but i have to recompile for that and I'm not sure I'm ready to
tackle that.)

Hello Laurin, Jonathan,


>> I'm not posting from t-online.de (where'd you get that from.)

>Dunno - sorry. I misread something.

i recently moved to Germany...

anyways:

as far as i can see it's a SE so you probably started sqlexecd as root
with the enviroment set properly; eq INFORMIXDIR, DBPATH etc

started like

$INFORMIXDIR/lib/sqlexecd rm5

on unix check it using dbaccess -->> choose connection and choose rm5

then all should work i saw that you got it working so you filled in
setnet32 correctly.

hope the above clarifys bits and pieces

This:
> (actually PHP has an Informix
> lib, but i have to recompile for that and I'm not sure I'm ready to
> tackle that.)
is Jonathan's department...

however connecting from windowze or a different machine will stil
require the setup
you have done to get odbc to work....

See you

Superboer




--
laurin1 schreef:

> Your input does help me understand better though.
>
> Seeing as I'm not sure how I got it working, and I really need to
> understand this better. Can you explain this comment more:
>
> "he r5 entry is interesting; if you use it, your client code will run
> sqlexecd, which will go into the background, so this one client will
> fail. But the clients that follow will have an sqlexecd available.
> Hmmm; interesting. "
>
> BTW, I'm using Access and PHP via ODBC (actually PHP has an Informix
> lib, but i have to recompile for that and I'm not sure I'm ready to
> tackle that.)