audit login/audit logout

Horst · Post by **Horst** » Thu 03 Nov 2005 10:32

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

Ikar · Post by **Ikar** » Fri 04 Nov 2005 10:55

Do you use FetchAll = False?

Horst · Post by **Horst** » Fri 04 Nov 2005 11:00

No, FetchAll is set to TRUE

Ikar · Post by **Ikar** » Fri 04 Nov 2005 13:19

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

Horst · Post by **Horst** » Mon 07 Nov 2005 08:23

I use TRUE !! for every dataset, not FALSE

Ikar · Post by **Ikar** » Tue 08 Nov 2005 07:46

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