The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

Strangely enough i find that SQL nywhere is still running after I shutdown my Powerbuilder App even though I disconnect from the DB before closing. Is there a SQL syntax to shutdown?

Windows 7 pro - SQLAnywhere 11 - Powerbuilder 11.5

Thanks,

Melvyn Polatchek

asked 27 Sep '11, 11:44

MelvynP's gravatar image

MelvynP
90669
accept rate: 0%


Besides Chris's suggestion, there are the STOP DATABASE and the STOP SERVER (until v11: STOP ENGINE) statements. I guess in your situation both database and engine are still running...

permanent link

answered 27 Sep '11, 12:05

Volker%20Barth's gravatar image

Volker Barth
29.3k287438644
accept rate: 32%

edited 27 Sep '11, 12:06

Thanks guys

Mel

(28 Sep '11, 09:52) MelvynP
Replies hidden

If so, feel free to accept one of these anwers...

(28 Sep '11, 09:55) Volker Barth

Check your ODBC Database tab setting for "Stop database after last disconnect". If that is checked, there might be other connections that remain open on the database.

permanent link

answered 27 Sep '11, 11:55

Chris%20Keating's gravatar image

Chris Keating
2.4k1444
accept rate: 22%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×90

question asked: 27 Sep '11, 11:44

question was seen: 1,069 times

last updated: 28 Sep '11, 09:55