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
30.8k308456665
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.9k1650
accept rate: 29%

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,159 times

last updated: 28 Sep '11, 09:55