SQL Anywhere database - Start database automatically always enabled , cannot be changed

Author

Start database automatically always enabled , cannot be changed

Peter Stojkovic

2005-10-28, 7:23 am

ASA 9.02 Build 3124

In the ODBC-Driver Interface on TAB-Page 'DATBASE'
there are two checkboxes
1. Start database automatically
2. Stop database after last disconnect

I want switch OFF "Start database automatically"., but the field is always
'READ-Only' (gray)

How can I switch OFF the checkbox ??

THX
Peter Stojkovic

Breck Carter [TeamSybase]

2005-10-28, 7:23 am

I agree that it is irritating. I almost never want either of the boxes
checked, and the warning dialog about "The Autostop parameter is
turned off" is truly annoying. But that's off topic...

I believe that when "Start database automatically" is greyed-out, it
does not apply... when the Start line and Database file entries are
both empty, there is nothing that can be started.

You can un-grey it by typing an 'x' or whatever in one of the other
columns, then uncheck it... I used to do this in my Adrian Monk phase,
but it would sometimes come back checked later.

Breck

On 28 Oct 2005 01:56:56 -0700, "Peter Stojkovic"
<Peter.Stojkovic@gmx.net> wrote:

>ASA 9.02 Build 3124
>
>
>In the ODBC-Driver Interface on TAB-Page 'DATBASE'
>there are two checkboxes
>1. Start database automatically
>2. Stop database after last disconnect
>
>
>I want switch OFF "Start database automatically"., but the field is always
>'READ-Only' (gray)
>
>How can I switch OFF the checkbox ??
>
>THX
>Peter Stojkovic
>

--
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

Greg Fenton

2005-10-28, 7:23 am

Breck Carter [TeamSybase] wrote:
>
> I believe that when "Start database automatically" is greyed-out, it
> does not apply... when the Start line and Database file entries are
> both empty, there is nothing that can be started.
>

An alternative is to not use the ODBC manager to create the DSN, but to
use the command-line "dbdsn" utility:

c:> cd \path\to\my\database

c:> dbdsn -wu test_a -cw -c
" uid=dba;pwd=sql;eng=
myeng;dbf=asademo. db;astop=no;astart=n
o"

[ and that's a heck of a lot faster than the whole using-the-mouse
thingy :-) ]

If you'd like a way to change the defaults for new ODBC DSNs, I
recommend posting the suggestion to
sybase.public.sqlanywhere. product_futures_disc
ussion

Hope this helps,
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/

Sponsored Links