Re: NT (db)access to solaris server
Actually, I really *meant* it when I wrote that I want to load a file from the
command line. The SQL Editor (aside form lacking in its own right) does me no
good for command line entry of a program. Currently I'm writing a simple ESQL/C
proggy to pipe a file into an informix db on a different OS, but am having
trouble with building and executing dynamic sql.
If you're interested, see my other post in the newsgroup.
Rob
Schaeflein, Paul wrote:
> The ROM tools include an SQL Editor. In the SQL Editor, use File|Open to
> load my_sql_file.sql
>
> -----Original Message-----
> From: Robert Bresner [SMTP:rbresner@olf.com]
> Sent: Wednesday, February 11, 1998 5:52 PM
> To: informix-list@iiug.org
> Subject: NT (db)access to solaris server
>
> Howdy...
> I've got an Informix 7.23 Solaris version installed.
> I want to load a file into it from the command line, using the likes of
>
> dbaccess my_db@my_server - < my_sql_file.sql
>
> The catch is, I want to do it from NT. DBAccess doesn't exist on NT,
> because
> I have not (and don't intend to) installed the NT Informix server. Also,
> it's
> been rumoured
> that DBAccess.exe on NT cannot connect to a Solaris Informix server
> anyway. So.
>
> 1. Can a windows version of DBAccess connect to a non-windows
> Informix
> server and load,
> via the command line, an sql file?
> 2. If (1), how do I installed DBAccess without installing the entire
> Informix server on NT?
>
> I've installed Informix-CLI, -ESQL/C, -NET, -CONNECT, and even the ROM
> admin
> tools. No DBAccess there.
>
> Thanks in advance for any help.
>
> Rob
> rbresner@olf.com