|
Home > Archive > SQL Anywhere database > October 2005 > Auto-starting and -stopping database in dbsrv service
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Auto-starting and -stopping database in dbsrv service
|
|
| Peter Simonsen 2005-10-27, 7:40 am |
| ASA 9.0.2.3044
Win XP/2K
We have a service-started dbsrv with two databases.
We need to be able to start a third database from
a user session from ODBC. So far this has started
a new engine on the same machine.
I would like to have this third database started
under the existing db engine.
The third database must be started and stopped
as needed (ie. Start automatically & Stop after
last disconnect).
Now, in the ODBC connection, I tried to simply
set the 3rd DBs servername to the existing
servername, without start line, and with
database name and file.
Unfortunately this still created a new engine,
and just left the service based engine unavailable.
Is my request possible or are we forced to run
two engines on the same machine?
TIA
regards/Peter Simonsen
| |
| Breck Carter [TeamSybase] 2005-10-27, 7:41 am |
| See the START DATABASE command.
Breck
On 24 Oct 2005 08:15:44 -0700, Peter Simonsen <"Peter Simonsen">
wrote:
>ASA 9.0.2.3044
>Win XP/2K
>
>We have a service-started dbsrv with two databases.
>We need to be able to start a third database from
>a user session from ODBC. So far this has started
>a new engine on the same machine.
>
>I would like to have this third database started
>under the existing db engine.
>
>The third database must be started and stopped
>as needed (ie. Start automatically & Stop after
>last disconnect).
>
>Now, in the ODBC connection, I tried to simply
>set the 3rd DBs servername to the existing
>servername, without start line, and with
>database name and file.
>Unfortunately this still created a new engine,
>and just left the service based engine unavailable.
>
>Is my request possible or are we forced to run
>two engines on the same machine?
>
>TIA
>
>regards/Peter Simonsen
--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
| |
| Peter Simonsen 2005-10-27, 7:41 am |
| Breck Carter [TeamSybase] wrote:
> See the START DATABASE command.
Thanks for your reply.
But I that would require recoding, which is not an option.
The application simply connect to DSN='my db',
so I need to do this in the ODBC profile.
Is it at all possible?
regards/Peter Simonsen
|
|
|
|
|