?
Solved

how automatic shutdown  ?

Posted on 2005-03-03
5
Medium Priority
?
304 Views
Last Modified: 2013-12-26
Hi,
Currently a user has reported there stand alone database connection does not shut down upon exiting our application. I verified that the automatically shut down database option is checked in the ODBC configuration.
DB icon can still been in the task bar.

How can I make db shut down automatically while exiting application. I have PowerBuilder10 n Adaptive Server Anywhere7.

Thanks
Maha
0
Comment
Question by:mahalakshmi_s
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 33

Expert Comment

by:sajuks
ID: 13455983
In your application close event , ;ve a code liLe
if isvalid(sqlca) disconnect using sqlca;
//this assumes that ur 'ving sqlca as ur transaction object.
Note that if u've started it as a service it will remain in the taskbar ( as it should ).
0
 

Author Comment

by:mahalakshmi_s
ID: 13458622
thanks for ur response..guess u r the only one in PB section...
cld u pls explain me further ? how can i shut down n remove the service from task bar ? need more explanation pls or give me some link if u cant type.

tq
M
0
 
LVL 18

Expert Comment

by:diasroshan
ID: 13464688
working on it ....
0
 
LVL 18

Accepted Solution

by:
diasroshan earned 2000 total points
ID: 13464761
Hi,

create a .bat file and write...

dbstop -c "eng=SERVER;uid=dba;pwd=SQL"


and in ur close event call this .bat file...
Run("dbstop.bat",minimized!)

hope thats what u were lookin for... now ur service is stopped and removed from the task bar

NOTE: 'dbstop' stops the server

do ask if u need more assistance...

Cheers,
Rosh
0
 

Author Comment

by:mahalakshmi_s
ID: 13476365
Rosh,
Tq for ur help. Will work it on today n get back to u.
M
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In our object-oriented world the class is a minimal unit, a brick for constructing our applications. It is an abstraction and we know well how to use it. In well-designed software we are not usually interested in knowing how objects look in memory. …
Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
The viewer will learn how to use and create keystrokes in Netbeans IDE 8.0 for Windows.
The viewer will learn how to use and create new code templates in NetBeans IDE 8.0 for Windows.
Suggested Courses
Course of the Month12 days, 22 hours left to enroll

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question