Running dbsrv9 as a service
Kumar Manuel
as a service?
TIA,
--
Kumar
Reg Domaratzki
Database Administration Utilities
The Service Creation utility
Managing services using the dbsvc command-line utility
--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup
iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL
"Kumar Manuel" <kumar...@activitylinksystems.com> wrote in message
news:412a48f0$1@forums-1-dub...
Kumar Manuel
Thanks for the input. I'm still kind of struggling to get this to work.
1st off, I can't find any reference in the v9 on-line docs, but I can in v
8.0.2 Collection. I've looked through that and have gotten it down to the
error saying "Specified Database Not Found"
If anyone can help, I'd appreciate it. Here is my Delphi Code using Native
DB Components:
with DataBase do
begin
LoginDatabase := DataBasePathAndName;
if Asta3NativeDBServiceForm.cbDBasService.checked then
ServerParams := 'start=dbsvc [-q] [-y] -d ALProService
"dbsrv9.exe" -gp4096 -x "tcpip" -o\ServerLog ' <<< This Not Working
else
ServerParams := 'start=dbsrv9.exe -gp4096 -x "tcpip" -o\ServerLog';
<<< This works fine
Connected := true;
end;
Thanks,
-k-
"Reg Domaratzki" <Spam_bad...@ianywhere.com> wrote in message
news:412a4e28@forums-2-dub...
Chris Keating (iAnywhere Solutions)
dbsvc -y -as -q -s automatic -t Network -w ASAService "C:\program
files\sybase\sql anywhere 9\win32\dbsrv9.exe" -x tcpip -c 8m "C:\Program
Files\Sybase\SQL Anywhere 9\asademo.db"
To start the service once created,
dbsvc -w ASAService
I am at a complete loss as to what you are doing in this code. So my
questions are
What is the purpose of the START= in the ServerParms?
What is the purpose of the brackets []? The brackets in the usage for an ASA
utility indicates optional parameters.
What is the -d for? You are already using the -y option.
"Kumar Manuel" <kumar...@activitylinksystems.com> wrote in message
news:412d9e64$1@forums-2-dub...
Jim Cullison
When using ASA as a service with NativeDB, all you need to set in the
TASASession component is the LoginEngineName, LoginDatabase, ClientParams,
and ServerType. If your service starts with the following options:
-x tcpip
-n ServerName
"c:\databasepath\yourdatabase.db" -n databasename
"C:\databasepath\seconddatabase.db" -n seconddatabase
Then your ASASession1 code would look like this:
ASASession1.ServerType := stClient;
ASASession1.ClientParams := 'commlinks=tcpip()';
ASASession1.LoginEngineName := 'ServerName';
ASASession1.LoginDatabase := 'databasename';
dbsvc is intended to be run once to install the service, it's just a
utility... it automates the process of creating a service, which you can do
manually in Sybase Central (Click Adaptive Server Anywhere 9 plugin icon,
Click Services tab, etc)
Then you could run dbsvc to start the service the first time, or use Windows
service control panel, or do cmd line "net start ASANYs_YourServiceName".
Note that ASANYs_ will change to ASANYe if you use dbeng instead of dbsrv.
So to sum up, dbsvc should be run during your install/config process, then
connect to the service as a Client from Delphi.
You should probably check out the .pdf that comes with NativeDB, it has some
great info. You can also get help on their Yahoo group.
http://groups.yahoo.com/group/nativedb/ The developer there, Harald, knows
Sybase and Delphi extremely well.
HTH,
Jim
P.S. I'm jealous you live and work in Hawaii. (I poked around on your
website).
Kumar Manuel
"Jim Cullison" <cullisonj_AT_@posim_DOT_.net> wrote in message
news:412e009a$1@forums-1-dub...