Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Sybase Server Under Vista - "Allow Service To Interact With Desktop"

5 posts in General Discussion (old) Last posting was on 2009-02-16 17:17:21.0Z
Christopher W. Harn Posted on 2009-02-12 14:17:57.0Z
From: "Christopher W. Harn" <harncw@hotmail.com>
Newsgroups: sybase.public.sqlanywhere
Subject: Sybase Server Under Vista - "Allow Service To Interact With Desktop"
Lines: 2
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
Importance: Normal
X-Newsreader: Microsoft Windows Live Mail 12.0.1606
X-MimeOLE: Produced By Microsoft MimeOLE V12.0.1606
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49942f95$1@forums-1-dub>
Date: 12 Feb 2009 06:17:57 -0800
X-Trace: forums-1-dub 1234448277 10.22.241.152 (12 Feb 2009 06:17:57 -0800)
X-Original-Trace: 12 Feb 2009 06:17:57 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere:246
Article PK: 866690

Sybase 9.0.2.XXXX (Recent EBFs)

So Microsoft in their infinite wisdom no longer allows a service to interact
with the desktop under Vista...

I'm sure they have their reasons, and from what little I read they looked
like pretty good ones, but I really liked having that pretty little icon in
the bottom right hand corner...

I do understand that since we no longer get the server console window, that
dbconsole.exe is now my friend, but honestly he is kinda scraggly looking.

What have other people done, to get around this?

1) Just dealt with it?
2) Added the server start to the startup folder, for the user?

...

3) any other ideas?


Christopher W. Harn Posted on 2009-02-12 22:03:20.0Z
From: "Christopher W. Harn" <harncw@hotmail.com>
Newsgroups: sybase.public.sqlanywhere
References: <49942f95$1@forums-1-dub>
Subject: Re: Sybase Server Under Vista - "Allow Service To Interact With Desktop"
Lines: 1
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
Importance: Normal
X-Newsreader: Microsoft Windows Live Mail 12.0.1606
X-MimeOLE: Produced By Microsoft MimeOLE V12.0.1606
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49949ca8$1@forums-1-dub>
Date: 12 Feb 2009 14:03:20 -0800
X-Trace: forums-1-dub 1234476200 10.22.241.152 (12 Feb 2009 14:03:20 -0800)
X-Original-Trace: 12 Feb 2009 14:03:20 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere:247
Article PK: 866689

darn this the quiet group still?...
I gonna have to cross post this to sybase.public.sqlanywhere.general?

"Christopher W. Harn" <harncw@hotmail.com> wrote in message
news:49942f95$1@forums-1-dub...
> Sybase 9.0.2.XXXX (Recent EBFs)
>
> So Microsoft in their infinite wisdom no longer allows a service to
> interact with the desktop under Vista...
>
> I'm sure they have their reasons, and from what little I read they looked
> like pretty good ones, but I really liked having that pretty little icon
> in the bottom right hand corner...
>
> I do understand that since we no longer get the server console window,
> that dbconsole.exe is now my friend, but honestly he is kinda scraggly
> looking.
>
> What have other people done, to get around this?
>
> 1) Just dealt with it?
> 2) Added the server start to the startup folder, for the user?
>
> ...
>
> 3) any other ideas?
>
>
>


"Chris Keating [Sybase iAnywhere]" <keating_no Posted on 2009-02-13 02:50:56.0Z
From: "Chris Keating [Sybase iAnywhere]" <keating_no@spam_sybase.com>
User-Agent: Thunderbird 2.0.0.19 (Windows/20081209)
MIME-Version: 1.0
Newsgroups: sybase.public.sqlanywhere
Subject: Re: Sybase Server Under Vista - "Allow Service To Interact With Desktop"
References: <49942f95$1@forums-1-dub> <49949ca8$1@forums-1-dub>
In-Reply-To: <49949ca8$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4994e010@forums-1-dub>
Date: 12 Feb 2009 18:50:56 -0800
X-Trace: forums-1-dub 1234493456 10.22.241.152 (12 Feb 2009 18:50:56 -0800)
X-Original-Trace: 12 Feb 2009 18:50:56 -0800, vip152.sybase.com
Lines: 53
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere:248
Article PK: 866688

You should generally permit 1 to 2 business days for a response, even
for an active forum.

If you have feedback for improvements to the dbconsole tool, please post
those to the futures forum or submit enhancement requests
(case-express.sybase.com).

Generally, I see "interact with desktop" used for short-term diagnostics
-- the database is at risk of being shutdown when there is an icon in
the system tray. You could certainly start the engine in the startup
folder but that would not mimic what a service delivers. A service
starts when the operating system starts whereas the startup folder
requires an user login for the engine to start.

Is the database engine intended to service a multiuser or standalone
environment? Running as a service for multiuser reduces the need to
active involvement in ensuring the database is online -- services can be
configured to restart when a problem is detected. For standalone, you
could simply take advantage of the autostart capability or the startup
folder.

Christopher W. Harn wrote:
> darn this the quiet group still?...
> I gonna have to cross post this to sybase.public.sqlanywhere.general?
>
> "Christopher W. Harn" <harncw@hotmail.com> wrote in message
> news:49942f95$1@forums-1-dub...
>> Sybase 9.0.2.XXXX (Recent EBFs)
>>
>> So Microsoft in their infinite wisdom no longer allows a service to
>> interact with the desktop under Vista...
>>
>> I'm sure they have their reasons, and from what little I read they
>> looked like pretty good ones, but I really liked having that pretty
>> little icon in the bottom right hand corner...
>>
>> I do understand that since we no longer get the server console window,
>> that dbconsole.exe is now my friend, but honestly he is kinda scraggly
>> looking.
>>
>> What have other people done, to get around this?
>>
>> 1) Just dealt with it?
>> 2) Added the server start to the startup folder, for the user?
>>
>> ...
>>
>> 3) any other ideas?
>>
>>
>>


Christopher W. Harn Posted on 2009-02-13 14:04:48.0Z
From: "Christopher W. Harn" <harncw@hotmail.com>
Newsgroups: sybase.public.sqlanywhere
References: <49942f95$1@forums-1-dub> <49949ca8$1@forums-1-dub> <4994e010@forums-1-dub>
Subject: Re: Sybase Server Under Vista - "Allow Service To Interact With Desktop"
Lines: 1
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
Importance: Normal
X-Newsreader: Microsoft Windows Live Mail 12.0.1606
X-MimeOLE: Produced By Microsoft MimeOLE V12.0.1606
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49957e00$1@forums-1-dub>
Date: 13 Feb 2009 06:04:48 -0800
X-Trace: forums-1-dub 1234533888 10.22.241.152 (13 Feb 2009 06:04:48 -0800)
X-Original-Trace: 13 Feb 2009 06:04:48 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere:249
Article PK: 866691

Sorry for my impatience.

Our implementations are both multi user and standalone. I would prefer to
install as a service even at the standalones for the sake of consistency.

I agree with the console being a risk of server shutdown (I am guilty of
doing that accidentally at least more than once), but yet my users and I
have grown to know and love that little icon in the bottom right hand
corner. I will miss him.

"Chris Keating [Sybase iAnywhere]" <keating_no@spam_sybase.com> wrote in
message news:4994e010@forums-1-dub...
> You should generally permit 1 to 2 business days for a response, even for
> an active forum.
>
> If you have feedback for improvements to the dbconsole tool, please post
> those to the futures forum or submit enhancement requests
> (case-express.sybase.com).
>
> Generally, I see "interact with desktop" used for short-term
> diagnostics -- the database is at risk of being shutdown when there is an
> icon in the system tray. You could certainly start the engine in the
> startup folder but that would not mimic what a service delivers. A service
> starts when the operating system starts whereas the startup folder
> requires an user login for the engine to start.
>
> Is the database engine intended to service a multiuser or standalone
> environment? Running as a service for multiuser reduces the need to active
> involvement in ensuring the database is online -- services can be
> configured to restart when a problem is detected. For standalone, you
> could simply take advantage of the autostart capability or the startup
> folder.
>
>
>
> Christopher W. Harn wrote:
>> darn this the quiet group still?...
>> I gonna have to cross post this to sybase.public.sqlanywhere.general?
>>
>> "Christopher W. Harn" <harncw@hotmail.com> wrote in message
>> news:49942f95$1@forums-1-dub...
>>> Sybase 9.0.2.XXXX (Recent EBFs)
>>>
>>> So Microsoft in their infinite wisdom no longer allows a service to
>>> interact with the desktop under Vista...
>>>
>>> I'm sure they have their reasons, and from what little I read they
>>> looked like pretty good ones, but I really liked having that pretty
>>> little icon in the bottom right hand corner...
>>>
>>> I do understand that since we no longer get the server console window,
>>> that dbconsole.exe is now my friend, but honestly he is kinda scraggly
>>> looking.
>>>
>>> What have other people done, to get around this?
>>>
>>> 1) Just dealt with it?
>>> 2) Added the server start to the startup folder, for the user?
>>>
>>> ...
>>>
>>> 3) any other ideas?
>>>
>>>
>>>


"Volker Barth" <No_VBarth Posted on 2009-02-16 17:17:21.0Z
From: "Volker Barth" <No_VBarth@Spam_GLOBAL-FINANZ.de>
Newsgroups: sybase.public.sqlanywhere
References: <49942f95$1@forums-1-dub> <49949ca8$1@forums-1-dub> <4994e010@forums-1-dub> <49957e00$1@forums-1-dub>
Subject: Re: Sybase Server Under Vista - "Allow Service To Interact With Desktop"
Lines: 92
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1933
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1933
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49999fa1$1@forums-1-dub>
Date: 16 Feb 2009 09:17:21 -0800
X-Trace: forums-1-dub 1234804641 10.22.241.152 (16 Feb 2009 09:17:21 -0800)
X-Original-Trace: 16 Feb 2009 09:17:21 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere:251
Article PK: 866692

Sounds like your users would like to use a (now invisible) service and still
have a "monitor tool icon" that is displayed in the system tray to show
whether the database server is up and running?

I.e. have a small app that checks periodically whether
a) the database server is reachable (via pinging or dblocate or the like) or
b) a database connection can be established (via connecting/disconnection or
having a long lasting connection and use WAITFOR... or check for ODBC's
SQL_ATTR_CONNECTION_DEAD or the like)?

Just a few quick thoughts :)

Volker

"Christopher W. Harn" <harncw@hotmail.com> wrote in
news:49957e00$1@forums-1-dub...
> Sorry for my impatience.
>
> Our implementations are both multi user and standalone. I would prefer to
> install as a service even at the standalones for the sake of consistency.
>
> I agree with the console being a risk of server shutdown (I am guilty of
> doing that accidentally at least more than once), but yet my users and I
> have grown to know and love that little icon in the bottom right hand
> corner. I will miss him.
>
>
>
> "Chris Keating [Sybase iAnywhere]" <keating_no@spam_sybase.com> wrote in
> message news:4994e010@forums-1-dub...
> > You should generally permit 1 to 2 business days for a response, even
for
> > an active forum.
> >
> > If you have feedback for improvements to the dbconsole tool, please post
> > those to the futures forum or submit enhancement requests
> > (case-express.sybase.com).
> >
> > Generally, I see "interact with desktop" used for short-term
> > diagnostics -- the database is at risk of being shutdown when there is
an
> > icon in the system tray. You could certainly start the engine in the
> > startup folder but that would not mimic what a service delivers. A
service
> > starts when the operating system starts whereas the startup folder
> > requires an user login for the engine to start.
> >
> > Is the database engine intended to service a multiuser or standalone
> > environment? Running as a service for multiuser reduces the need to
active
> > involvement in ensuring the database is online -- services can be
> > configured to restart when a problem is detected. For standalone, you
> > could simply take advantage of the autostart capability or the startup
> > folder.
> >
> >
> >
> > Christopher W. Harn wrote:
> >> darn this the quiet group still?...
> >> I gonna have to cross post this to sybase.public.sqlanywhere.general?
> >>
> >> "Christopher W. Harn" <harncw@hotmail.com> wrote in message
> >> news:49942f95$1@forums-1-dub...
> >>> Sybase 9.0.2.XXXX (Recent EBFs)
> >>>
> >>> So Microsoft in their infinite wisdom no longer allows a service to
> >>> interact with the desktop under Vista...
> >>>
> >>> I'm sure they have their reasons, and from what little I read they
> >>> looked like pretty good ones, but I really liked having that pretty
> >>> little icon in the bottom right hand corner...
> >>>
> >>> I do understand that since we no longer get the server console window,
> >>> that dbconsole.exe is now my friend, but honestly he is kinda scraggly
> >>> looking.
> >>>
> >>> What have other people done, to get around this?
> >>>
> >>> 1) Just dealt with it?
> >>> 2) Added the server start to the startup folder, for the user?
> >>>
> >>> ...
> >>>
> >>> 3) any other ideas?
> >>>
> >>>
> >>>