Page 1 of 1

audit login/audit logout

Posted: Thu 03 Nov 2005 10:32
by Horst
I am profiling my application using sql profiler and discovered entries like that

audit login
-- network protocol: TCP/IP
set quoted_identifier on
set implicit_transactions off
set cursor_close_on_commit off
set ansi_warnings on
set ansi_padding on
set ansi_nulls on
set concat_null_yields_null on
set language us_english
set dateformat mdy
set datefirst 7

Then there is my statement
select .......

followed by an

AUDIT LOGOUT

Can anybody tell me why these messages appear although I am already logged in for hours. It would be understandable to me when it appears when logging in but not during processing data and there is no pattern visible to me when it occurs.

Thanks in advance

Posted: Fri 04 Nov 2005 10:55
by Ikar
Do you use FetchAll = False?

audit login/audit logout

Posted: Fri 04 Nov 2005 11:00
by Horst
No, FetchAll is set to TRUE

Posted: Fri 04 Nov 2005 13:19
by Ikar
Do you use False for every dataset?

If yes please send us (sdac*crlab*com) a complete small sample to demonstrate it and include script to create server objects. Also specify
- Exact version of Delphi or C++ Builder
- Exact version of SDAC. You can see it in About sheet of TMSConnection Editor
- Exact version of Microsoft SQL Server and OLE DB provider that you use. You can see it in Info sheet of TMSConnection Editor

Posted: Mon 07 Nov 2005 08:23
by Horst
I use TRUE !! for every dataset, not FALSE

Posted: Tue 08 Nov 2005 07:46
by Ikar
Please send us (sdac*crlab*com) a complete small sample to demonstrate problem and include script to create server objects. Also specify
- Exact version of Delphi or C++ Builder
- Exact version of SDAC. You can see it in About sheet of TMSConnection Editor
- Exact version of Microsoft SQL Server and OLE DB provider that you use. You can see it in Info sheet of TMSConnection Editor