Subject | RE: [firebird-support] 2.01 no default SYSDBA |
---|---|
Author | Leyne, Sean |
Post date | 2007-05-23T21:21:09Z |
Kyle,
Windows Host File script -- to allow you to define/associate a user
context to the execution of the batch file.
You can send your thanks to Microsoft, they have really clamped down of
the execution of 'unauthorized' functions.
I would recommend that you look into getting a distribution license for
a tool like IBEScript from IBExpert -- it does a great job for us in
running db scripts/trapping errors, etc...
A tool like it is a required item for any developer looking to deploy
FB/IB solutions.
Sean
P.S. Sorry Martijn, I wasn't sure if you had a similar tool... so I
didn't mention it.
> Any ideas why it would work from the command line, but not from scriptYou need to combine your batch file with a Windows Script File or
> called by bat?
Windows Host File script -- to allow you to define/associate a user
context to the execution of the batch file.
You can send your thanks to Microsoft, they have really clamped down of
the execution of 'unauthorized' functions.
I would recommend that you look into getting a distribution license for
a tool like IBEScript from IBExpert -- it does a great job for us in
running db scripts/trapping errors, etc...
A tool like it is a required item for any developer looking to deploy
FB/IB solutions.
Sean
P.S. Sorry Martijn, I wasn't sure if you had a similar tool... so I
didn't mention it.