Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

How to enable OLEDB trace?

2 posts in General Discussion Last posting was on 2003-05-15 21:24:23.0Z
BG Posted on 2003-05-15 15:40:15.0Z
From: BG
Date: Thu, 15 May 2003 11:40:15 -0400
Newsgroups: ianywhere.public.general
Subject: How to enable OLEDB trace?
Message-ID: <D64CE32C675A765B0056156F85256D27.0056157C85256D27@webforums>
Lines: 8
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub ianywhere.public.general:1020
Article PK: 2993

Hello,
I'm trying to connect to SQL Anywhere DB from .NEt environment via SYBASE
OLEDB data provider. Is there any way to enable trace for this provider to
see what is being send to the database?
Thank you
BG


Jason Hinsperger Posted on 2003-05-15 21:24:23.0Z
From: "Jason Hinsperger" <NOJason_HinspergerSPAM@hotmail.com>
References: <D64CE32C675A765B0056156F85256D27.0056157C85256D27@webforums>
Subject: Re: How to enable OLEDB trace?
Date: Thu, 15 May 2003 17:24:23 -0400
Lines: 31
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Message-ID: <#nLPUjyGDHA.284@forums-1-dub>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: hinsperg-pc1.sybase.com 172.31.143.226
Path: forums-1-dub!forums-master.sybase.com!forums-1-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:1023
Article PK: 2991

You can try using the DEBUG and FILE connection parameters in your connect
string (see the docs for details), but this will give you mostly connection
related information.
There is no tracing facility that will tell you exactly what oledb calls are
being made.

You can turn on request level logging on the database server to see what sql
statements are being passed to it.

--
Jason Hinsperger
International and Sustaining Engineering
iAnywhere Solutions

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer
--

<BG> wrote in message
news:D64CE32C675A765B0056156F85256D27.0056157C85256D27@webforums...
> Hello,
> I'm trying to connect to SQL Anywhere DB from .NEt environment via SYBASE
> OLEDB data provider. Is there any way to enable trace for this provider to
> see what is being send to the database?
> Thank you
> BG
>
>