Can you run multiple databases with single network server?

[Former Member]

Hi,

I created one database running as a network server, but after I created another database running on the same network server, I could only connect the previous one.

I want to know if this is possible and how to do it, but couldn't find any example online. I have tried this but the service wouldn't start.

dbsrv12 -n server "c:dbdatabase1.db" -n database1 "c:dbdatabase2.db" -n database2

Any idea?

[Former Member]

Thanks for all the helps! The issue has been resolved. Actually I should enter the parameters as follows:

-n server "c:\\db\\database1.db" -n database1 "c:\\db\\database2.db" -n database2"

not

dbsrv12 -n server "c:\\db\\database1.db" -n database1 "c:\\db\\database2.db" -n database2"

The extra "dbsrv12" caused the trouble(I was using GUI to set up the service).

The server log option works great too.

[Former Member]

Yes, multiple databases can be run on one instance of the SQL Anywhere server.

If that service is starting, add a console log output to the start command using the -o parameter (and optionally -on or -os to limit size) like so:

dbsrv12 -n myserver -o server_log.out mydb1.db -n mydb mydb2.db -n mydb2

The output log (server_log.out above) may identify why the server is unable to start.