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? asked 25 Apr '13, 18:21 bravestone Mark Culp |
You can run up to 254 databases on the same network database server. To connect to a specific database you need to specify the database name in the client connection string. For example, using your database server command line,
Other connection examples can be found in the documentation. The complete list of connection parameters can be found here. I would recommend that you read through these pages and become familiar with them. Note the reason that you were able to connect to the first database is that the first database started on the server is the default database if no databasename (dbn) is specified in the connection string. HTH answered 25 Apr '13, 19:27 Mark Culp |
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. answered 25 Apr '13, 19:21 Tyson Lewis |
Thanks for all the helps! The issue has been resolved. Actually I should enter the parameters as follows:
not
The extra "dbsrv12" caused the trouble(I was using GUI to set up the service).
The server log option works great too.