Re: Cannot create/access database on NFS mount.

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/linux_faq/english/iolfaq-5.html#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/linux_faq/english/iolfaq-5.html#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_servernamedemo_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.)