SQL Anywhere


All I wanna do is "Log Expensive Queries" in Version 11... why does it have to be so hard?


After almost a day of trying (not just because of http://sqlanywhere-forum.sap.com/questions/1238/dbunload-sql-error-feature-alter-remote-table-not-implemented) I gave up trying to do Application Profiling using a separate profiling database and checked "Save tracing in this database" (emphasis mine).

But even that fails...

An error has occurred - tracing was not attached to the database.
ATTACH TRACING could not connect to the tracing database
[Sybase][ODBC Driver][SQL Anywhere]ATTACH TRACING could not connect to the tracing database
SQLCODE: -1097

Yes, the connection string is perfect... after all, Sybase Central is already connected to "this database".

How is that even possible? ...for ATTACH TRACING to not connect to a LOCAL database Sybase Central is already connected to?

Yes, there is a lot of funky stuff in "this database"... and one of the funky things is that it's started with the dbsrv11 -sb 0 option.

For a good reason, normally.

Remove that, and Application Profiling can proceed... I hope... :)


Gosh, I love 9.0.2!


asked 20 Oct '10, 19:11

Breck%20Carter's gravatar image

Breck Carter
accept rate: 20%

edited 20 Oct '10, 19:28

Be the first one to answer this question!
toggle preview

Follow this question

By Email:

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



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:


question asked: 20 Oct '10, 19:11

question was seen: 1,981 times

last updated: 20 Oct '10, 19:28