windows 7 services fails to start dbsrv10

[Former Member]

I am running two (2) server engines. I am experiencing a problem with them starting on windows 7. As follows in a InstallServers.bat file.

dbsvc -t Network -s Automatic -as -sn "Servername1" -sd "ServerName1" -y -w "ServerName1" "D:\\Engine\\sqlany10\\win32\\dbsrv10.exe" -c 10p -ti 0 -tl 0 -n Server1 D:\\Engine\\data\\DataBase1.db

dbsvc -t Network -s Automatic -as -sn "Server2" -sd "Server2" -y -w "Server2" "C:\\Program Files\\SQL Anywhere 10\\win32\\dbsrv10.exe"  -n Server2 D:\\Engine\\data\\DataBase2.db 

Sometimes they both start, sometimes Server1 starts, sometimes Server2 starts. If Server1 is started and running, Server2 fails to start,automaticlly or manually. Please notice they are using dbsrv10.exe from different locations. One the application1 location and the other the default installation location. Two different applications. Seems to work okay on the XP machines (SP3).

Am I over looking something, gray hair getting int he way, or am I doing it completely wrong?

Thanks for taking a look,

George

[Breck_Carter]

Try adding -o file1.txt and -o file2.txt to capture any diagnostics that might be available (IMO all engines should have -o).

Try specifying -x tcpip(port=nnnnn) on each command line to avoid the possibility that the engines are getting annoyed while they fight to open the same port. Normally the "second" server will pick another port, and this suggestion is just a guess.

[Breck_Carter]

re "Am I over looking something, gray hair getting int he way...": Windows services are one of The Dark Arts, often incomprehensible to us Muggles 🙂

[VolkerBarth]

Besides Breck's hints, I'm not sure whether running two SQL Anywhere installations with the same major version on one box might lead to these problems - officially it is not supported, cf. this FAQ...

If both programs are running in parallel, I would think they could use DLLs from the other installation - AFAIK, DLLs using shared memory are still more easily "shared" than usual ones - which lead to the Side-by-side DLLs disussion.

---

Therefore another test would be to use the same executable in both command lines:)

[Breck_Carter]

Good idea! Don't know if the dbsvc -rs option would help but it can't hurt http://dcx.sybase.com/index.html#1001/en/dbdaen10/da-dbsvc-service-dbutilities.html

[MCMartin]

Have a look at the event log, if the db server can't start it writes the reason into the event log.

[Former Member]

Thanks all. Interesting this has no issues on XP. I am having some difficulty locating how to actually read the log file. InSybase Central I see "view log" and it is blank. WHat I find with goodle is that the log file can not be read with out special programs.... which does not sound right. Is there a link to an instruction on how to read the log file/ is there a difference between the db.log and if there is an error.log? I am new to all this on Sybase, I need a point in the right direction. Mucho Appreciated George

[Breck_Carter]

If you specify dbsrv10 -o c:whateverfilename.txt then the engine will create a text file c:whateverfilename.txt containing a copy of all the console messages that are normally invisible for services. This file is often called a "log" file which irritates me beyond words (grrrrr!) because it gets confused with the transaction log file db.log. And no, you can't read the transaction log without translating it first, but that's NOT the file you care about.

The -o file goes wherever you say to put it... and with a service that can be a challenge when the account being used has limited file access rights.

XP is vastly different from Windows 7, and at this point you have no idea why the service is failing... that is your first step... specify dbsrv10 -o c:whateverfilename.txt

Also, please go back and re-read the other comments (since you missed this suggestion earlier)

[Breck_Carter]

If you are asking about the event log, that's not a file at all, but a Windows thing (which also existed in XP).

See Control Panel - Administrative Tools - Computer Management - System Tools - Event Viewer... good luck, I've never found it to be any use solving SQL Anywhere problems, but you could be luckier than me (Martin clearly is 🙂