Dear Bruce, I fear I've (a) not responded previously, and (b) don't have very much to add at the moment. With luck, you've long since solved the problem.
If the esqltest and/or esqlbasic program, when built on the Linux box, cannot connect to the server, there's no hope that Perl + DBI + DBD::Informix will be able to do so. So, we can at least reduce the issue to 'sort out the Linux to Solaris connectivity'; once you've done that, the Perl will almost certainly be trivial. Have you checked on any box other than the Solaris box that you can connect to the Solaris copy of IDS from off the box? If you only have the two machines, you're stuck, and maybe none of them have CSDK either. We need to check that the IDS server on the Solaris box is set up with network connections - you need either DBSERVERNAME or one of the DBSERVERALIASES to reference an oltlitcp connection - that's correct on Solaris, but not on Linux where you should be using olsoctcp (read the CSDK release notes and machine notes). In fact, that's most likely the problem - wrong protocol name. Yes - olsoctcp on Linux talks to oltlitcp on Solaris quite happily. One day it'll be fixed so that olsoctcp is equivalent to oltlitcp and it won't matter which you use in the sqlhosts file. Assuming you have the network server alias up - can you connect to it on the Solaris box. Yes, it's a loopback connection, but if that fails, then there's something weird on the Solaris side. OK - I think the OLSOCTCP vs OLTLITCP is the problem. If it's not, pay attention to the other commentary, and get back to me with any additional information you can. On 5/17/05, Bruce Lysik <[EMAIL PROTECTED]> wrote: > > Thanks for the response. Sorry it's been so long since I replied. (Too many > projects, too little time.) > > > > I'm running into a problem trying to build DBD::Informix on > > a Redhat ES3 host, with a > > > database on a Solaris 9 host. > > > > > > Client: RedHat ES3, 2.4.21-15.0.4.ELsmp, perl v5.8.0, Informix > > > clientsdk.2.90.UC1.LINUX installed. Trying to install > > DBD-Informix-2005.01 > > > > > > Database server: Solaris 9, Informix 9.40.UC4 > > > > Thanks for this much information. > > (More requested information) > > INFORMIXSERVER=flydev > > >grep flydev /opt/informix/etc/sqlhosts > flydev oltlitcp devdb1 informix_1525 > > >grep 1525 /etc/services > informix_1525 1525/tcp > > I don't have any NLS or LC_* variables set in my environment. > > onconfig.flydev on devdeb1 contains: > DBSERVERNAME flydev > > > Have you managed to get any ESQL/C program to connect to your database > > server from your Linux box? I suspect not. > > You suspect correctly. I compiled the sample program that comes with > DBD::Informix and that didn't connect properly either. > > Results of infxmsg -25507: > >./infxmsg -25507 > Unknown error message -25507. > > Definitely odd that it's returning a negative number for this error. > > Using dbaccess and the 'monfly' user, the DBA can connect to the stores > database and do operations on it. > > Please let me know if you need any more information. The DBA is not > available this week, but I can probably poke around and find stuff. Thanks > again! > > -- > Bruce Z. Lysik <[EMAIL PROTECTED]> > > > The information contained in this message (including any attachments) may be > confidential. This message (including any attachments) is intended to be read > only by the recipient(s) to whom it is addressed. If the reader of this > message is not the intended recipient, you are on notice that any > distribution of this message, in any form, is strictly prohibited. If you > have received this message in error, please immediately notify the sender > and/or Shutterfly by telephone at (650) 610-5200 and delete or destroy any > copy of this message (including any attachments). > -- Jonathan Leffler #include <disclaimer.h> Guardian of DBD::Informix v2003.04 -- see http://dbi.perl.org "I don't suffer from insanity; I enjoy every minute of it!"
