|
Home > Archive > SQL Anywhere database > December 2005 > How start database ?
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 |
How start database ?
|
|
| Fantom 2005-12-16, 7:23 am |
| Hi
In LAN i may 2 computers : serwer and client.
On clinet I install ASA serwer network.
Database engine on serwer is off.
How i may start database from client on serwer (application use interface
ODBC) when i want connect with this database ? And when i disconnected,
database must close.
Fantom
| |
| Chris Keating(iAnywhere Solutions) 2005-12-16, 7:23 am |
| First off, why? If you only have a single user interacting with the
database as very specific times, you should consider just running the
personal server which will remove the overhead of the network.
That said, it is not possible to start a process on a different machine
as part of a connection. If you absolutely need to do this, you will
need to find some way to start a process on another machine. Unless you
want to provide your application user permissions that allow them to
launch remote processes...
Perhaps if you can explain why you need this requirement so that we can
better understand the need?
--
Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8
********************
********************
********************
*****************
Sign up today for your copy of the SQL Anywhere Studio 9 Developer Edition
and try out the market-leading database for mobile, embedded and small to
medium sized business environments for free!
http://www.ianywhere.com/promos/deved/index.html
********************
********************
********************
*****************
iAnywhere Solutions http://www.iAnywhere.com
** Please only post to the newsgroup
** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use Case Express to report bugs http://case-express.sybase.com
********************
********************
********************
*****************
| |
| Fantom 2005-12-16, 9:23 am |
| > First off, why? If you only have a single user interacting with the
> database as very specific times, you should consider just running the
> personal server which will remove the overhead of the network.
But i bought network server, and i dont want buy next personal server.
> That said, it is not possible to start a process on a different machine
> as part of a connection. If you absolutely need to do this, you will
> need to find some way to start a process on another machine. Unless you
> want to provide your application user permissions that allow them to
> launch remote processes...
>
> Perhaps if you can explain why you need this requirement so that we can
> better understand the need?
Application first copy the file of database to disk, and after that it try
to connect to this database, work on data in this database and close
(shutdown engine, because file is in use). This file is copy to for example
archive. And again, and again ..... And at end i get ten different files.
Fantom
| |
| Chris Keating(iAnywhere Solutions) 2005-12-16, 9:23 am |
| Why not leave the network server engine running? You can then start and
stop databases on that running engine as you require. Attempting to
start and stop the engine on a different machine is a complex task and
not one that can be solved in ASA.
While I understand that you bought the network server, you are
describing a single user operation so it seems like overkill to use the
network server. Besides, the network server is more expensive that a
single user engine. Anyways, it was just a question and using the
personal server in this context could simplify the operation that you
are trying to do.Now that said, if you are attempting to have several
machines connect to this server and you are simply trying to reduce the
licensing requirements, you would not be able to use the personal server
for that purpose so the network server would and should be used.
--
Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8
********************
********************
********************
*****************
Sign up today for your copy of the SQL Anywhere Studio 9 Developer Edition
and try out the market-leading database for mobile, embedded and small to
medium sized business environments for free!
http://www.ianywhere.com/promos/deved/index.html
********************
********************
********************
*****************
iAnywhere Solutions http://www.iAnywhere.com
** Please only post to the newsgroup
** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use Case Express to report bugs http://case-express.sybase.com
********************
********************
********************
*****************
| |
| Fantom 2005-12-19, 3:23 am |
| > Why not leave the network server engine running? You can then start and
> stop databases on that running engine as you require. Attempting to
> start and stop the engine on a different machine is a complex task and
> not one that can be solved in ASA.
But possible ? How ?
> While I understand that you bought the network server, you are
> describing a single user operation so it seems like overkill to use the
> network server. Besides, the network server is more expensive that a
> single user engine. Anyways, it was just a question and using the
> personal server in this context could simplify the operation that you
> are trying to do.Now that said, if you are attempting to have several
> machines connect to this server and you are simply trying to reduce the
> licensing requirements, you would not be able to use the personal server
> for that purpose so the network server would and should be used.
But to this server is connected several users. I need network serwera ASA.
Fantom
| |
| Chris Keating(iAnywhere Solutions) 2005-12-19, 7:23 am |
| It is possible. However, it generally requires a network administrator
level authority to perform. That level of permission is not likely to be
provided to an application.
Why are you reluctant to leave an ASA engine running?
--
Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8
********************
********************
********************
*****************
Sign up today for your copy of the SQL Anywhere Studio 9 Developer Edition
and try out the market-leading database for mobile, embedded and small to
medium sized business environments for free!
http://www.ianywhere.com/promos/deved/index.html
********************
********************
********************
*****************
iAnywhere Solutions http://www.iAnywhere.com
** Please only post to the newsgroup
** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use Case Express to report bugs http://case-express.sybase.com
********************
********************
********************
*****************
|
|
|
|
|