--- In [email protected], Thomas Steinmaurer <ts@...> wrote: > > > I have a problem calling isql.exe from a windows batch file, which is > > called from a running service. > > > > I wrote a simple java program, which calls a windows batch script with a > > parameter: > > System.exec("c:\Temp\hook.cmd foo"). > > > > The batch script first writes a select statement into a file using the > > parameter: > > echo select if from users where name = 'foo'>> c:\Temp\statement.sql > > ...and second calls the isql.exe command with the file as input > > parameter and an output parameter to write the result > > <PATH_TO_FIREBIRD_BIN>\isql.exe -user sysdba -password masterkey > > <PATH_TO_DB>\database.fdb -i c:\temp\statement.sql -o c:\temp\result.txt > > I run this Java program from a console, it works just perfect, I have > > the results in the result.txt. Great! > > Installing the Java program as a windows service, the result.txt remains > > empty. The hook.cmd is called, the statement.sql is generated, but > > then... there are no results in the result.txt. > > > > Has anybody an idea? Had anybody a problem like this? > > Has this something to do with "current user" if the application runs as > > a Service (Which is SYSTEM)? There is not possible to connect with isql > > if the user is not the current windows user? > > > > Any help or clue would be greatly appreciated! Thanks. > > Try to use a remote connection string, even if Firebird is running > locally. E.g. > > localhost:<PATH_TO_DB>\database.fdb > > > Perhaps this helps. > > -- > With regards, > Thomas Steinmaurer > http://www.upscene.com/ >
Hi Thomas, unfortunately the remote connection string doesn't work. Thanks anyway. Zs.
