Problem connecting to IDS on Linux

I'm having a few problems.... My first question actually is quite straight forward, until recently I had never heard of 'I-Star'. Is I-Star required in order to connect to and IDS database on a Linux pc? I have installed the evaluation copy of IDS for Linux (9.40) , on Mandrake 10.1. It works fine locally, I have set up sqlhosts, the service in /etc/services file. I'm using the correct protocal etc (onsoctcp). Then, from a pc (again with the correct settings etc) I have set up an ODBC connection, click 'test connection' and it works file. However, if I do anything other than just try to tes the connection, i.e. Link tables from access, or use MS Query etc, it just freezes when I try to connect to the database. ilogin to my database works, but I believe that just tries a connect anyway, as I said, that seems to work. To complicate things, I am actually setting up an old New era 2.2 system to run on this pc (which is Win2000). However, the setnet settings are correct (the new era app I am setting up uses the direct sockets rather than going via odbc), again the 16bit ilogon will connect. But I just can't seem to do anything with the database. I tried running the local (on the pc) dbaccess and dbschema etc, to connect to the server database db_name@db_soc but it says that db_soc is not in the sqlhosts file. But it is, does it need to be there anyway locally? My answer may be back at the beginning of this message, when I asked what I-Star was, I have a feeling that it needs installing on the linux box, if it does where do I get it from? Its it actually the csdk? And if it is, my does my command cpio -icvdumB < FILEDOWNLOADEDFROMIBM.cpi keep giving me 'Junk' blocks. Any help on any of the above woudl be appreciated. Thanks Jamie

I-Star was integreated into the engine way back in the early 5.x days. I think -- maybe 5.3, or 5.2. Basically I-Star is the part of the engine which does a distributed query. If you are on 10.x, then I-Star is built into the engine. The network information (i.e. sqlhost info, etc) needs to be on the client. It is the client that is connecting to the database. <jamie.nash@xansa.com> wrote in message news:1107263729.854248.179620@c13g2000cwb.googlegroups.com... > I'm having a few problems.... > > My first question actually is quite straight forward, until recently I > had never heard of 'I-Star'. Is I-Star required in order to connect to > and IDS database on a Linux pc? > > I have installed the evaluation copy of IDS for Linux (9.40) , on > Mandrake 10.1. It works fine locally, I have set up sqlhosts, the > service in /etc/services file. I'm using the correct protocal etc > (onsoctcp). > > Then, from a pc (again with the correct settings etc) I have set up an > ODBC connection, click 'test connection' and it works file. > > However, if I do anything other than just try to tes the connection, > i.e. Link tables from access, or use MS Query etc, it just freezes when > I try to connect to the database. > > ilogin to my database works, but I believe that just tries a connect > anyway, as I said, that seems to work. > > > To complicate things, I am actually setting up an old New era 2.2 > system to run on this pc (which is Win2000). However, the setnet > settings are correct (the new era app I am setting up uses the direct > sockets rather than going via odbc), again the 16bit ilogon will > connect. But I just can't seem to do anything with the database. > > I tried running the local (on the pc) dbaccess and dbschema etc, to > connect to the server database db_name@db_soc but it says that db_soc > is not in the sqlhosts file. But it is, does it need to be there > anyway locally? > > My answer may be back at the beginning of this message, when I asked > what I-Star was, I have a feeling that it needs installing on the linux > box, if it does where do I get it from? Its it actually the csdk? And > if it is, my does my command cpio -icvdumB < FILEDOWNLOADEDFROMIBM.cpi > keep giving me 'Junk' blocks. > Any help on any of the above woudl be appreciated. > > Thanks > > Jamie >

Hi there :-) I never saw an odbc client or new era client "freeze" on connect. Are you sure you waited long enough? Putting the client into the servers hosts file can help sometimes (the server gets into a timeout in some versions of informix when trying to resolve the clients hostname - dont know about your version). ILogin does more than just connect in the 16 bit version also. It tries to play with the sports test database as far as I remember. Feel free do post your informix.ini settings (setnet). Maybe we can find something. btw: You tried with 16 bit, 16 bit odbc, 32 bit and 32 bit odbc, did I get that right? Cheers, Dirk -- -- Dirk Gunsthoevel IT Systemanalyse phone: +49 (0)251 28446-0 -- Hammer Str. 13 fax: +49 (0)251 28446-55 -- D-48153 Muenster http://www.GunCon.de/ -- "Toto, I don't think we're in Kansas anymore..." <jamie.nash@xansa.com> schrieb im Newsbeitrag news:1107263729.854248.179620@c13g2000cwb.googlegroups.com... > I'm having a few problems.... > > My first question actually is quite straight forward, until recently I > had never heard of 'I-Star'. Is I-Star required in order to connect to > and IDS database on a Linux pc? > > I have installed the evaluation copy of IDS for Linux (9.40) , on > Mandrake 10.1. It works fine locally, I have set up sqlhosts, the > service in /etc/services file. I'm using the correct protocal etc > (onsoctcp). > > Then, from a pc (again with the correct settings etc) I have set up an > ODBC connection, click 'test connection' and it works file. > > However, if I do anything other than just try to tes the connection, > i.e. Link tables from access, or use MS Query etc, it just freezes when > I try to connect to the database. > > ilogin to my database works, but I believe that just tries a connect > anyway, as I said, that seems to work. > > > To complicate things, I am actually setting up an old New era 2.2 > system to run on this pc (which is Win2000). However, the setnet > settings are correct (the new era app I am setting up uses the direct > sockets rather than going via odbc), again the 16bit ilogon will > connect. But I just can't seem to do anything with the database. > > I tried running the local (on the pc) dbaccess and dbschema etc, to > connect to the server database db_name@db_soc but it says that db_soc > is not in the sqlhosts file. But it is, does it need to be there > anyway locally? > > My answer may be back at the beginning of this message, when I asked > what I-Star was, I have a feeling that it needs installing on the linux > box, if it does where do I get it from? Its it actually the csdk? And > if it is, my does my command cpio -icvdumB < FILEDOWNLOADEDFROMIBM.cpi > keep giving me 'Junk' blocks. > Any help on any of the above woudl be appreciated. > > Thanks > > Jamie >

jamie.nash@xansa.com wrote: > I'm having a few problems.... > > My first question actually is quite straight forward, until recently I > had never heard of 'I-Star'. Is I-Star required in order to connect to > and IDS database on a Linux pc? No. I-Star was a separate version of the OnLine server with network access enabled, back in the days of (Turbo 1.10.03?) OnLine 4.0x, 4.1x, 5.0x and 5.1x. With OnLine 5.2x, we recognized that IDS 6.00 and above had long since provided I-Star functionality automatically, so you no longer have to buy I-Star as a separate product - OnLine 5.20 includes it as standard too. So I-Star is unnecessary for connecting to an IDS database on a Linux PC; it would have to be an OnLine database to be relevant. (And, as Madison said, you'd be running I-Star on the Linux box, not the Win2K PC which joins the discussion further down this message.) We still sometimes refer to the distributed query (cross-database, cross-server) functionality as I-Star. This is in part in deference to one of the early distributed databases, R*, generated by IBM. The same R that became DB2... > I have installed the evaluation copy of IDS for Linux (9.40) , on > Mandrake 10.1. It works fine locally, I have set up sqlhosts, the > service in /etc/services file. I'm using the correct protocal etc > (onsoctcp). Sounds good. > Then, from a pc (again with the correct settings etc) I have set up an > ODBC connection, click 'test connection' and it works file. Well, I suppose you can think a database server as a fine file - it's just not the conventional way of looking at it. :-) I'm assuming you mean a non-Linux PC? Are you sure you wouldn't be better off using a Linux PC? > However, if I do anything other than just try to tes the connection, > i.e. Link tables from access, or use MS Query etc, it just freezes when > I try to connect to the database. This sounds horribly like MS Windows. So, you probably don't have DB-Access available? Or any other ESQL/C application? > ilogin to my database works, but I believe that just tries a connect > anyway, as I said, that seems to work. Hmmm... not sure. > To complicate things, I am actually setting up an old New era 2.2 > system to run on this pc (which is Win2000). Why? I'm pretty sure NewEra was never certified on Win2K - especially not NewEra 2.2. You might be in with half a fighting chance with NewEra 3.x, but... > However, the setnet SETNET or SETNET32? > settings are correct (the new era app I am setting up uses the direct > sockets rather than going via odbc), again the 16bit ilogon will > connect. But I just can't seem to do anything with the database. What does that mean? You are using a 16-bit Windows 3.1-ish version of NewEra on Win2K, and you are using the ESQL/C connections instead of the ODBC connections? Is that NewEra really a 16-bit version? > I tried running the local (on the pc) dbaccess and dbschema etc, to > connect to the server database db_name@db_soc but it says that db_soc > is not in the sqlhosts file. But it is, does it need to be there > anyway locally? The (Win2K) PC needs to have the sqlhosts file or the equivalent information on it - it can't divine that it needs to connect to the Linux PC (they barely existed when NewEra 2.2 was created, at least as far as NewEra was concerned) to find out that it should be connecting to the database server running on said Linux PC. You need to look at SETNET (SETNET32) and related setups, as well as the ESQL/C Runtime - or NewEra runtime - libraries you are using. > My answer may be back at the beginning of this message, when I asked > what I-Star was, I have a feeling that it needs installing on the linux > box, if it does where do I get it from? Its it actually the csdk? I-Star is not (and never was) a part of CSDK. It is immaterial; your IDS server running with olsoctcp connections is ready and waiting for applications to connect to it. So, I-Star is not really a part of the answer. > And > if it is, my does my command cpio -icvdumB < FILEDOWNLOADEDFROMIBM.cpi > keep giving me 'Junk' blocks. On Linux, the '-c' to cpio means the opposite of '-c' on any other Unix-like platform. Omit it and you should be OK. The whole thing is unnecessary - but the cpio command should then work. > Any help on any of the above woudl be appreciated. I forget which version of ESQL/C was used with NewEra. I would think it was approximately equivalent to ESQL/C 6.00 for release 1.x and probably 7.1x or 7.2x for NewEra 2.2. Do you have GLS as part of your NewEra install ($INFORMIXDIR/gls)? If so, it is most likely a 7.2x version of ESQL/C - and not CSDK. If you don't have a GLS sub-directory, then you most likely have a 7.1x version of ESQL/C. Actually, it should not matter much; both are likely to be able to connect to IDS - whether 7.3x or 9.x - via a network connection. However, 7.1x ESQL/C - and applications built on it - have been out of support for most of this millennium. Doubly so, I would say, for 16-bit Windows versions. So, you should be operational, but unsupported. However, the connectivity depends critically on you getting everything right in the environment. SETNET32 is an improvement over SETNET (which isn't saying much). [I must get my NewEra manuals back from the lawyers - they're on a CD they took.] I'm not sure if I've dropped the hint that will solve your problem. I strongly recommend reengineering the application to get rid of NewEra. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/