Subject | Re: FireBird Service and Batch Script |
---|---|
Author | Richard Thomas |
Post date | 2006-04-14T20:55:30Z |
Good Evening Helen:
You Wrote:
DDL scripts, written in Notepad. DOS batch files, with command-line
calls to isql to run (-input) the scripts. This takes care of the
metadata creation.
OK, so I might run a script to set directory path, call isql and ReDirect
isql input from another batch file and output to a text file for easy
reading with my screen reader?
You Wrote:
You don't need a script to run Firebird: just set it up as a service
and it will be waiting for you. Down the track, when you have
applications to run, you can use the embedded server for single-user
deployment - again, nothing to do to "run firebird" - you don't even
change any program code if you do it right.
I installed Super Server using defaults. I have a Guardian service default
instance and a Super Server default instance listed in my system Admin
services.
Also:
fbguard.exe and fbserver.exe are listed in the Windows Task Manager.
This indicates, I think, I have the "Firebird Service" running - Phew!
Programming Language to execute DML and SQL commands will be Liberty Basic:
The interface will be ODBC using standard ODBC32 API calls using the free
ODBC Driver downloaded from the Firebird Download Page or the GeminiDriver
offered by Aleksey.
Note: I might also be able to use this setup to process DDL Statements in
place of Scripting the DDL - Not sure yet.
As for Embedded, well that's another day.
I don't believe it, but with your help I'm starting to get a finger-nail
hold on some concepts!
Have a very nice evening Helen,:
Rick Farmington Mich. USA
You Wrote:
DDL scripts, written in Notepad. DOS batch files, with command-line
calls to isql to run (-input) the scripts. This takes care of the
metadata creation.
OK, so I might run a script to set directory path, call isql and ReDirect
isql input from another batch file and output to a text file for easy
reading with my screen reader?
You Wrote:
You don't need a script to run Firebird: just set it up as a service
and it will be waiting for you. Down the track, when you have
applications to run, you can use the embedded server for single-user
deployment - again, nothing to do to "run firebird" - you don't even
change any program code if you do it right.
I installed Super Server using defaults. I have a Guardian service default
instance and a Super Server default instance listed in my system Admin
services.
Also:
fbguard.exe and fbserver.exe are listed in the Windows Task Manager.
This indicates, I think, I have the "Firebird Service" running - Phew!
Programming Language to execute DML and SQL commands will be Liberty Basic:
The interface will be ODBC using standard ODBC32 API calls using the free
ODBC Driver downloaded from the Firebird Download Page or the GeminiDriver
offered by Aleksey.
Note: I might also be able to use this setup to process DDL Statements in
place of Scripting the DDL - Not sure yet.
As for Embedded, well that's another day.
I don't believe it, but with your help I'm starting to get a finger-nail
hold on some concepts!
Have a very nice evening Helen,:
Rick Farmington Mich. USA