MDAC 2.5 SDK - OLE DB Testing

Part 2: Formatted Output

This is a sample of the entire trace output, formatted for readability.

Starting Log

--> CREATE INSTANCE of Data Source Object (0x01291958)
Process = 0x00000041 
Thread = 0x00000170 
CREATE INSTANCE = 0x01291958 
Input Params = 2 
Provider ID: Microsoft OLE DB Provider for SQL Server {0C7FF16C-38E3-11D0-97AB-00C04FC2AD98}
IUnknown *pUnkOuter = 0x00000000
REFIID riid = 0x0042a178

--> IDBInitialize::QueryInterface (0x01291970)
Process = 0x00000041 
Thread = 0x00000170 
DataSource = 0x01291970 
Input Params = 1 
Provider ID: Microsoft OLE DB Provider for SQL Server {0C7FF16C-38E3-11D0-97AB-00C04FC2AD98}
REFIID riid = 0x0042a178

<-- IDBInitialize::QueryInterface (0x01291970) = S_OK
Process = 0x00000041 
Thread = 0x00000170 
DataSource = 0x01291970 
Exec Time = < 0.1ms 
Output Params = 1 
Provider ID: Microsoft OLE DB Provider for SQL Server {0C7FF16C-38E3-11D0-97AB-00C04FC2AD98}
void **ppvObject = 0x0012f608

<-- CREATE INSTANCE of Data Source Object (0x01291958) = S_OK
Process = 0x00000041 
Thread = 0x00000170 
CREATE INSTANCE = 0x01291958 
Exec Time = 2.64ms 
Output Params = 1 
Provider ID: Microsoft OLE DB Provider for SQL Server {0C7FF16C-38E3-11D0-97AB-00C04FC2AD98}
void **ppv = 0x0012f608

--> IUnknown::Release (0x01291970)
Process = 0x00000041 
Thread = 0x00000170 
DataSource = 0x01291970 
Input Params = 0 
Provider ID: Microsoft OLE DB Provider for SQL Server {0C7FF16C-38E3-11D0-97AB-00C04FC2AD98}
<-- IUnknown::Release (0x01291970) = 1
Process = 0x00000041 
Thread = 0x00000170 
DataSource = 0x01291970 
Exec Time = < 0.1ms 
Output Params = 0 
Provider ID: Microsoft OLE DB Provider for SQL Server {0C7FF16C-38E3-11D0-97AB-00C04FC2AD98}

--> IDBInitialize::QueryInterface (0x0129199c)
Process = 0x00000041 
Thread = 0x00000170 
DataSource = 0x01291970 
Input Params = 1 
Provider ID: Microsoft OLE DB Provider for SQL Server {0C7FF16C-38E3-11D0-97AB-00C04FC2AD98}
REFIID riid = 0x0042a178

<-- IDBInitialize::QueryInterface (0x0129199c) = S_OK
Process = 0x00000041 
Thread = 0x00000170 
DataSource = 0x01291970 
Exec Time = < 0.1ms 
Output Params = 1 
Provider ID: Microsoft OLE DB Provider for SQL Server {0C7FF16C-38E3-11D0-97AB-00C04FC2AD98}
void **ppvObject = 0x0012f63c

--> IDBInitialize::Release (0x0129199c)
Process = 0x00000041 
Thread = 0x00000170 
DataSource = 0x01291970 
Input Params = 0 
Provider ID: Microsoft OLE DB Provider for SQL Server {0C7FF16C-38E3-11D0-97AB-00C04FC2AD98}

<-- IDBInitialize::Release (0x0129199c) = 1
Process = 0x00000041 
Thread = 0x00000170 
DataSource = 0x01291970 
Exec Time = < 0.1ms 
Output Params = 0 
Provider ID: Microsoft OLE DB Provider for SQL Server {0C7FF16C-38E3-11D0-97AB-00C04FC2AD98}

--> IDBProperties::QueryInterface (0x0129199c)
Process = 0x00000041 
Thread = 0x00000170 
DataSource = 0x01291970 
Input Params = 1 
Provider ID: Microsoft OLE DB Provider for SQL Server {0C7FF16C-38E3-11D0-97AB-00C04FC2AD98}
REFIID riid = 0x0042a188

<-- IDBProperties::QueryInterface (0x0129199c) = S_OK
Process = 0x00000041 
Thread = 0x00000170 
DataSource = 0x01291970 
Exec Time = < 0.1ms 
Output Params = 1 
Provider ID: Microsoft OLE DB Provider for SQL Server {0C7FF16C-38E3-11D0-97AB-00C04FC2AD98}
void **ppvObject = 0x0012f7fc

--> IDBProperties::SetProperties (0x012919c0)
Process = 0x00000041 
Thread = 0x00000170 
DataSource = 0x01291970 
Input Params = 2 
Provider ID: Microsoft OLE DB Provider for SQL Server {0C7FF16C-38E3-11D0-97AB-00C04FC2AD98}
ULONG cPropertySets = 1
DBPROPSET rgPropertySets[cPropertySets] = 1242848

<-- IDBProperties::SetProperties (0x012919c0) = S_OK
Process = 0x00000041 
Thread = 0x00000170 
DataSource = 0x01291970 
Exec Time = 0.31ms 
Output Params = 0 
Provider ID: Microsoft OLE DB Provider for SQL Server {0C7FF16C-38E3-11D0-97AB-00C04FC2AD98}

--> IDBInitialize::Initialize (0x0129199c)
Process = 0x00000041 
Thread = 0x00000170 
DataSource = 0x01291970 
Input Params = 0 
Provider ID: Microsoft OLE DB Provider for SQL Server {0C7FF16C-38E3-11D0-97AB-00C04FC2AD98}

<-- IDBInitialize::Initialize (0x0129199c) = S_OK
Process = 0x00000041 
Thread = 0x00000170 
DataSource = 0x01291970 
Exec Time = 42.63ms 
Output Params = 0 
Provider ID: Microsoft OLE DB Provider for SQL Server {0C7FF16C-38E3-11D0-97AB-00C04FC2AD98}

--> IDBProperties::Release (0x012919c0)
Process = 0x00000041 
Thread = 0x00000170 
DataSource = 0x01291970 
Input Params = 0 
Provider ID: Microsoft OLE DB Provider for SQL Server {0C7FF16C-38E3-11D0-97AB-00C04FC2AD98}

<-- IDBProperties::Release (0x012919c0) = 1
Process = 0x00000041 
Thread = 0x00000170 
DataSource = 0x01291970 
Exec Time = < 0.1ms 
Output Params = 0 
Provider ID: Microsoft OLE DB Provider for SQL Server {0C7FF16C-38E3-11D0-97AB-00C04FC2AD98}

--> IDBCreateSession::QueryInterface (0x0129199c)
Process = 0x00000041 
Thread = 0x00000170 
DataSource = 0x01291970 
Input Params = 1 
Provider ID: Microsoft OLE DB Provider for SQL Server {0C7FF16C-38E3-11D0-97AB-00C04FC2AD98}
REFIID riid = 0x0042a1a8

<-- IDBCreateSession::QueryInterface (0x0129199c) = S_OK
Process = 0x00000041 
Thread = 0x00000170 
DataSource = 0x01291970 
Exec Time = < 0.1ms 
Output Params = 1 
Provider ID: Microsoft OLE DB Provider for SQL Server {0C7FF16C-38E3-11D0-97AB-00C04FC2AD98}
void **ppvObject = 0x0042eac4

--> IDBCreateSession::CreateSession (0x012919a4)
Process = 0x00000041 
Thread = 0x00000170 
DataSource = 0x01291970 
Input Params = 3 
Provider ID: Microsoft OLE DB Provider for SQL Server {0C7FF16C-38E3-11D0-97AB-00C04FC2AD98}
IUnknown *pUnkOuter = 0x00000000
REFIID riid = 0x0012fcf8
IUnknown **ppDBSession = 0x0042eac8

--> ISessionProperties::QueryInterface (0x01296ae0)
Process = 0x00000041 
Thread = 0x00000170 
Session = 0x01296ae0 
Input Params = 1 
Provider ID: Microsoft OLE DB Provider for SQL Server {0C7FF16C-38E3-11D0-97AB-00C04FC2AD98}
REFIID riid = 0x0042a128

<-- ISessionProperties::QueryInterface (0x01296ae0) = S_OK
Process = 0x00000041 
Thread = 0x00000170 
Session = 0x01296ae0 
Exec Time = < 0.1ms 
Output Params = 1 
Provider ID: Microsoft OLE DB Provider for SQL Server {0C7FF16C-38E3-11D0-97AB-00C04FC2AD98}
void **ppvObject = 0x0042eac8

--> IUnknown::Release (0x01296ae0)
Process = 0x00000041 
Thread = 0x00000170 
Session = 0x01296ae0 
Input Params = 0 
Provider ID: Microsoft OLE DB Provider for SQL Server {0C7FF16C-38E3-11D0-97AB-00C04FC2AD98}

<-- IUnknown::Release (0x01296ae0) = 1
Process = 0x00000041 
Thread = 0x00000170 
Session = 0x01296ae0 
Exec Time = < 0.1ms 
Output Params = 0 
Provider ID: Microsoft OLE DB Provider for SQL Server {0C7FF16C-38E3-11D0-97AB-00C04FC2AD98}

<-- IDBCreateSession::CreateSession (0x012919a4) = S_OK
Process = 0x00000041 
Thread = 0x00000170 
DataSource = 0x01291970 
Exec Time = 0.10ms 
Output Params = 0 
Provider ID: Microsoft OLE DB Provider for SQL Server {0C7FF16C-38E3-11D0-97AB-00C04FC2AD98}

--> IDBCreateCommand::QueryInterface (0x01296b44)
Process = 0x00000041 
Thread = 0x00000170 
Session = 0x01296ae0 
Input Params = 1 
Provider ID: Microsoft OLE DB Provider for SQL Server {0C7FF16C-38E3-11D0-97AB-00C04FC2AD98}
REFIID riid = 0x0042a1b8

<-- IDBCreateCommand::QueryInterface (0x01296b44) = S_OK
Process = 0x00000041 
Thread = 0x00000170 
Session = 0x01296ae0 
Exec Time = < 0.1ms 
Output Params = 1 
Provider ID: Microsoft OLE DB Provider for SQL Server {0C7FF16C-38E3-11D0-97AB-00C04FC2AD98}
void **ppvObject = 0x0012ff28

--> IDBCreateCommand::CreateCommand (0x01296b0c)
Process = 0x00000041 
Thread = 0x00000170 
Session = 0x01296ae0 
Input Params = 3 
Provider ID: Microsoft OLE DB Provider for SQL Server {0C7FF16C-38E3-11D0-97AB-00C04FC2AD98}
IUnknown *pUnkOuter = 0x00000000
REFIID riid = 0x0012fce8
IUnknown **ppCommand = 0x0012ff24

--> ICommandText::QueryInterface (0x01296d48)
Process = 0x00000041 
Thread = 0x00000170 
Command = 0x01296d48 
Input Params = 1 
Provider ID: Microsoft OLE DB Provider for SQL Server {0C7FF16C-38E3-11D0-97AB-00C04FC2AD98}
REFIID riid = 0x0042a228

<-- ICommandText::QueryInterface (0x01296d48) = S_OK
Process = 0x00000041 
Thread = 0x00000170 
Command = 0x01296d48 
Exec Time = < 0.1ms 
Output Params = 1 
Provider ID: Microsoft OLE DB Provider for SQL Server {0C7FF16C-38E3-11D0-97AB-00C04FC2AD98}
void **ppvObject = 0x0012ff24

--> IUnknown::Release (0x01296d48)
Process = 0x00000041 
Thread = 0x00000170 
Command = 0x01296d48 
Input Params = 0 
Provider ID: Microsoft OLE DB Provider for SQL Server {0C7FF16C-38E3-11D0-97AB-00C04FC2AD98}

<-- IUnknown::Release (0x01296d48) = 1
Process = 0x00000041 
Thread = 0x00000170 
Command = 0x01296d48 
Exec Time = < 0.1ms 
Output Params = 0 
Provider ID: Microsoft OLE DB Provider for SQL Server {0C7FF16C-38E3-11D0-97AB-00C04FC2AD98}

<-- IDBCreateCommand::CreateCommand (0x01296b0c) = S_OK
Process = 0x00000041 
Thread = 0x00000170 
Session = 0x01296ae0 
Exec Time = 0.27ms 
Output Params = 0 
Provider ID: Microsoft OLE DB Provider for SQL Server {0C7FF16C-38E3-11D0-97AB-00C04FC2AD98}

--> ICommandText::SetCommandText (0x01296e08)
Process = 0x00000041 
Thread = 0x00000170 
Command = 0x01296d48 
Input Params = 2 
Provider ID: Microsoft OLE DB Provider for SQL Server {0C7FF16C-38E3-11D0-97AB-00C04FC2AD98}
REFGUID rguidDialect = 0x0012fce8
LPCOLESTR pwszCommand = 0x00429c08

<-- ICommandText::SetCommandText (0x01296e08) = S_OK
Process = 0x00000041 
Thread = 0x00000170 
Command = 0x01296d48 
Exec Time = 0.07ms 
Output Params = 0 
Provider ID: Microsoft OLE DB Provider for SQL Server {0C7FF16C-38E3-11D0-97AB-00C04FC2AD98}

--> ICommandText::Execute (0x01296e08)
Process = 0x00000041 
Thread = 0x00000170 
Command = 0x01296d48 
Input Params = 5 
Provider ID: Microsoft OLE DB Provider for SQL Server {0C7FF16C-38E3-11D0-97AB-00C04FC2AD98}
IUnknown *pUnkOuter = 0x00000000
REFIID riid = 0x0012fce0
DBPARAMS *pParams = 0x00000000
DBROWCOUNT *pcRowsAffected = 0x0012ff1c
IUnknown **ppRowset = 0x0042ead0

--> ICommandProperties::GetProperties (0x01296e20)
Process = 0x00000041 
Thread = 0x00000170 
Command = 0x01296d48 
Input Params = 4 
Provider ID: Microsoft OLE DB Provider for SQL Server {0C7FF16C-38E3-11D0-97AB-00C04FC2AD98}
const ULONG cPropertyIDSets = 1
const DBPROPIDSET rgPropertyIDSets[cPropertyIDSets] = 1243884
ULONG *pcPropertySets = 0x0012fb04
DBPROPSET **prgPropertySets = 0x0012fae8

<-- ICommandProperties::GetProperties (0x01296e20) = S_OK
Process = 0x00000041 
Thread = 0x00000170 
Command = 0x01296d48 
Exec Time = 0.09ms 
Output Params = 0 
Provider ID: Microsoft OLE DB Provider for SQL Server {0C7FF16C-38E3-11D0-97AB-00C04FC2AD98}

--> ICommandProperties::Release (0x01296e20)
Process = 0x00000041 
Thread = 0x00000170 
Command = 0x01296d48 
Input Params = 0 
Provider ID: Microsoft OLE DB Provider for SQL Server {0C7FF16C-38E3-11D0-97AB-00C04FC2AD98}

<-- ICommandProperties::Release (0x01296e20) = 1
Process = 0x00000041 
Thread = 0x00000170 
Command = 0x01296d48 
Exec Time = < 0.1ms 
Output Params = 0 
Provider ID: Microsoft OLE DB Provider for SQL Server {0C7FF16C-38E3-11D0-97AB-00C04FC2AD98}

--> IUnknown::Release (0x00000000)
Process = 0x00000041 
Thread = 0x00000170 
Rowset = 0x00000000 
Input Params = 0 
Provider ID: Microsoft OLE DB Provider for SQL Server {0C7FF16C-38E3-11D0-97AB-00C04FC2AD98}

<-- IUnknown::Release (0x00000000) = 0
Process = 0x00000041 
Thread = 0x00000170 
Rowset = 0x00000000 
Exec Time = < 0.1ms 
Output Params = 0 
Provider ID: Microsoft OLE DB Provider for SQL Server {0C7FF16C-38E3-11D0-97AB-00C04FC2AD98}

<-- ICommandText::Execute (0x01296e08) = 0x80040e14
Process = 0x00000041 
Thread = 0x00000170 
Command = 0x01296d48 
Exec Time = 3.10ms 
Output Params = 0 
Provider ID: Microsoft OLE DB Provider for SQL Server {0C7FF16C-38E3-11D0-97AB-00C04FC2AD98}

--> IDBCreateCommand::Release (0x01296b0c)
Process = 0x00000041 
Thread = 0x00000170 
Session = 0x01296ae0 
Input Params = 0 
Provider ID: Microsoft OLE DB Provider for SQL Server {0C7FF16C-38E3-11D0-97AB-00C04FC2AD98}

<-- IDBCreateCommand::Release (0x01296b0c) = 2
Process = 0x00000041 
Thread = 0x00000170 
Session = 0x01296ae0 
Exec Time = < 0.1ms 
Output Params = 0 
Provider ID: Microsoft OLE DB Provider for SQL Server {0C7FF16C-38E3-11D0-97AB-00C04FC2AD98}

--> ICommandText::Release (0x01296e08)
Process = 0x00000041 
Thread = 0x00000170 
Command = 0x01296d48 
Input Params = 0 
Provider ID: Microsoft OLE DB Provider for SQL Server {0C7FF16C-38E3-11D0-97AB-00C04FC2AD98}

<-- ICommandText::Release (0x01296e08) = 0
Process = 0x00000041 
Thread = 0x00000170 
Command = 0x01296d48