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.

From: massimomm

Newsgroups: sybase.public.sqlanywhere.general

Subject: SQL Logging SQL Statement

Date: 20 Apr 2010 02:38:38 -0700

I use ASA 7 so I'd like to know if there is a way to logging the sql instruction that database server dbsrv7, receive from clients?

I need this because a client that use odbc connection after performing an insert into a table, the client receive the Message: "SQL truncate". I need to know the field on the table that generate this warning!!

Thanks in advance Massimo

asked 20 Apr '10, 10:11

Breck%20Carter's gravatar image

Breck Carter
26.6k418576824
accept rate: 21%


The tool that does this is called "request-level logging" and in V7 you have to enable it from the command line when you start the server, using the -zr (and optionally -zo) command line switch.

You can also enable ODBC tracing at the client in order to track down this type of problem.

permanent link

answered 20 Apr '10, 10:48

Glenn%20Paulley's gravatar image

Glenn Paulley
10.7k568104
accept rate: 43%

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:

×101

question asked: 20 Apr '10, 10:11

question was seen: 1,040 times

last updated: 20 Apr '10, 10:48