Re: dbaccess and SPL

On Thu, 1 Oct 1998, Nicole Guffey wrote: > 1. Can you call dbaccess and have it run a sql script (file.sql) > from SPL using SYSTEM? Yes, but... (a) it won't be fast, and (b) you may have to worry about the environment it receives. > 2. How I get dbaccess to connect to a specific informix server? You tell it to connect to the server you want it to connect to. Eg: dbaccess mydbase@myserver script > I am running dbaccess from a winnt workstation trying to connect to a > server on another machine. That might make it more difficult - the comment above works on Unix and should work on NT, but I don't know that it works on NT. > There is a server installed on the local > workstation, but it is offline and not in use. You need to set INFORMIXSERVER to the remote system, so it doesn't do anything with the local system. You can run into that sort of trouble on Unix too. > Dbaccess keeps trying > to connect to this local server even if I specify in the database name > "testdb@otherserver". The informixserver EV is set to the > otherserver, not the local one. Are you sure that the NT registry and SETNET32 etc are not getting in your way? I'd believe almost anything about any program and its environment on NT; Unix is downright user-friendly by comparison with NT once the defaults don't work. > I know I am missing something - but what? Environment, environment, environment... Yours, Jonathan Leffler (jleffler@informix.com) #include <witticism.h> Guardian of DBD::Informix v0.60 -- http://www.perl.com/CPAN Informix IDN for D4GL & Linux -- http://www.informix.com/idn