Oninit cdi / Archive
Talk to an expert →

utility like dbaccess

Posted in 2007

Summary

Poster asked for a dbaccess-like client tool he could install on a Solaris box to query an Informix 10 engine running on another machine. Suggestions: sqlcmd from the IIUG software repository, and adbaccess from the Aubit4GL project. One reply noted dbaccess itself works remotely via dbname@server or by setting INFORMIXSERVER, but others pointed out dbaccess ships with the engine, not the client SDK, so it requires an engine install (and arguably a licence) on the client box — though some sites do install IDS purely to get dbaccess. No single answer was marked as accepted.

Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.

Topics: Installation, Setup & Upgrades, Server Administration, Platform-Specific Issues

mohitanchlia@gmail.com — — source: Usenet: comp.databases.informix

Version: IDS 10 Is there a utility that I can download and install which is like dbaccess that can run on solaris box and can connect to informix engine running on some other box.

↪ replying to mohitanchlia@gmail.com
Fernando Nunes — — source: Usenet: comp.databases.informix

mohitanchlia@gmail.com wrote: > Version: IDS 10 > > Is there a utility that I can download and install which is like > dbaccess that can run on solaris box and can connect to informix > engine running on some other box. Check for sqlcmd on IIUG. Regards -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently...

↪ replying to mohitanchlia@gmail.com
Fernando Ortiz — — source: Usenet: comp.databases.informix

On Dec 3, 12:27 pm, mohitanch...@gmail.com wrote: > Version: IDS 10 > > Is there a utility that I can download and install which is like > dbaccess that can run on solaris box and can connect to informix > engine running on some other box. You can also try adbaccess from the aubit4gl project http://aubit4gl.sf.net Regards

↪ replying to mohitanchlia@gmail.com
iiug@perrior.net — — source: Usenet: comp.databases.informix

On 3 Dec, 18:27, mohitanch...@gmail.com wrote: > Version: IDS 10 > > Is there a utility that I can download and install which is like > dbaccess that can run on solaris box and can connect to informix > engine running on some other box. ... what's wrong with using dbaccess <dbname>@<remotemachinesoc> ? or export INFORMIXSERVER=<remotemachine> and so on?

↪ replying to iiug@perrior.net
Thomas J. Girsch — — source: Usenet: comp.databases.informix

> ... what's wrong with using > dbaccess <dbname>@<remotemachinesoc> ? Won't work if you don't have a database engine installed on the local box. dbaccess is bundled with the engine, not with the tools. So if you don't have an engine license for a client box, you can't run it on the remote (client) server.

↪ replying to Thomas J. Girsch
Neil Truby — — source: Usenet: comp.databases.informix

"Thomas J. Girsch" <tgirsch@NOSPAM.gmail.com> wrote in message news:8eWdnR3lK4Nrs8vanZ2dnUVZ_vjinZ2d@comcast.com... >> ... what's wrong with using >> dbaccess <dbname>@<remotemachinesoc> ? > > Won't work if you don't have a database engine installed on the local box. > dbaccess is bundled with the engine, not with the tools. So if you don't > have an engine license for a client box, you can't run it on the remote > (client) server. I know plenty of sites who do install IDS on the "remote" server precisely so that they can use dbaccess in this way in a multi-tiered structure. No database server is created nor is it intended ever that they will do so; the product is installed simply for the dbaccess functionality. I suppose technically that this might be a breach of the licence agreement though I think it very unlikely that IBM would try to enforce it in these circumstances.

Glossary