DB_E_ERRORSOCCURED on Execute w/out properties or errorinfo
Dee Holtsclaw <[email protected]> Wed, 26 Feb 2003 20:33:59 -0500
| Newsgroups | gmane.comp.windows.devel.oledb.devel |
|---|---|
| Message-ID | <[email protected]> |
I'm about at my wits end again. Took working code and added the option of
opening the database connection using service components. This, of course,
broke everything but I'm having trouble figuring out why. There is really
only a couple of places I need to use the service components but I'd much
prefer orthoganlity than to hack in a bunch of exceptions...
When the query is executed, it returns DB_E_ERRORSOCCURRED. In the process
two exceptions are thrown and caught within the OLEDB library. Although the
interface says it supports ErrorInfo (InterfaceSupportsErrorInfo returns
S_OK), the call to GetErrorInfo returns S_FALSE and the IErrorInfo interface
pointer is NULL. Additionally, requesting DBPROPSET_PROPERTIESINERROR
returns nothing and getting the whole list shows not at single one with a
problem. Since the query works without the Service Components, there's got
to be something else going on here. Anyone have any ideas?
Thanks
Ciao,
Dee
<DEBUGDUMP>
CSelectDlg::CSelectDlg() -- Created
DB: 1 "Sample", Components=0xffffffff, Shape=no
Testing provider's init interfaces
Checking interfaces for 022B2DF0:
{00000000-0000-0000-C000-000000000046} -- IUnknown
{00000003-0000-0000-C000-000000000046} -- IMarshal
{0000010b-0000-0000-C000-000000000046} -- IPersistFile
{0000010c-0000-0000-C000-000000000046} -- IPersist
Loaded exports for 'C:\WINNT\system32\comsvcs.dll'
Loaded exports for 'C:\WINNT\system32\NETAPI32.DLL'
Loaded exports for 'C:\WINNT\system32\secur32.dll'
Loaded exports for 'C:\WINNT\system32\netrap.dll'
Loaded exports for 'C:\WINNT\system32\samlib.dll'
Loaded exports for 'C:\WINNT\system32\ws2_32.dll'
Loaded exports for 'C:\WINNT\system32\ws2help.dll'
Loaded exports for 'C:\WINNT\system32\WLDAP32.DLL'
Loaded exports for 'C:\WINNT\system32\dnsapi.dll'
Loaded exports for 'C:\WINNT\system32\wsock32.dll'
Loaded exports for 'C:\WINNT\system32\txfaux.dll'
Loaded exports for 'C:\WINNT\system32\msdtcprx.dll'
Loaded exports for 'C:\WINNT\system32\mtxclu.dll'
Loaded exports for 'C:\WINNT\system32\CLUSAPI.DLL'
Loaded exports for 'C:\WINNT\system32\RESUTILS.DLL'
Loaded exports for 'C:\WINNT\system32\USERENV.DLL'
{0C733A7A-2A1C-11CE-ADE5-00AA0044773D} -- IDBDataSourceAdmin
{0C733A8A-2A1C-11CE-ADE5-00AA0044773D} -- IDBProperties
{0C733A8B-2A1C-11CE-ADE5-00AA0044773D} -- IDBInitialize (default)
{0C733A95-2A1C-11CE-ADE5-00AA0044773D} -- IDBAsynchStatus
{DF0B3D60-548F-101B-8E65-08002B2BD119} -- ISupportErrorInfo
Done: Found 9 interfaces supported of 7024 registered
Propset #0: DBPROPSET_DBINIT {C8B522BC-5CF3-11CE-ADE5-00AA0044773D} (7
properties)
-----------------PropID----------------- POptions PStatus- Value
0009 DBPROP_AUTH_PASSWORD 0 0 {"" VT_BSTR}
003b DBPROP_INIT_DATASOURCE 0 0
{"\\TESTSVR\testdata\Sample.mdb" VT_BSTR}
003f DBPROP_INIT_MODE 0 0 {19 VT_I4}
0040 DBPROP_INIT_PROMPT 0 0 {4 VT_I2}
00ba DBPROP_INIT_LCID 0 0 {1033 VT_I4}
0041 DBPROP_INIT_PROTECTION_LEVEL 1 1 {5 VT_I2}
00f8 DBPROP_INIT_OLEDBSERVICES 0 0 {-1 VT_I4}
Propset #1: DBPROPSET_JETOLEDB_DBINIT {82CF8156-9B40-11D0-9EBD-00C04FC2C2E0}
(2 properties)
-----------------PropID----------------- POptions PStatus- Value
0106 DBPROP_JETOLEDB_DATABASELOCKMODE 0 0 {1 VT_I4}
0100 DBPROP_JETOLEDB_DATABASEPASSWORD 0 0 {"foobar"
VT_BSTR}
Testing provider's session interfaces
Checking interfaces for 022B4614:
{00000000-0000-0000-C000-000000000046} -- IUnknown
{06210E88-01F5-11D1-B512-0080C781C384} -- IService
{0C733A1D-2A1C-11CE-ADE5-00AA0044773D} -- IDBCreateCommand
{0C733A5F-2A1C-11CE-ADE5-00AA0044773D} -- ITransactionLocal
{0C733A68-2A1C-11CE-ADE5-00AA0044773D} -- IIndexDefinition
{0C733A69-2A1C-11CE-ADE5-00AA0044773D} -- IOpenRowset (default)
{0C733A75-2A1C-11CE-ADE5-00AA0044773D} -- IGetDataSource
{0C733A7B-2A1C-11CE-ADE5-00AA0044773D} -- IDBSchemaRowset
{0C733A85-2A1C-11CE-ADE5-00AA0044773D} -- ISessionProperties
{0C733A86-2A1C-11CE-ADE5-00AA0044773D} -- ITableDefinition
{0FB15084-AF41-11CE-BD2B-204C4F4F5020} -- ITransaction
{DF0B3D60-548F-101B-8E65-08002B2BD119} -- ISupportErrorInfo
Done: Found 12 interfaces supported of 7024 registered
Generated SQL: 'SELECT Chart.Reference, Chart.R_ID, Account, Description,
Acct_Type, Sign_CR FROM Chart'
Loaded exports for 'C:\Program Files\Common Files\System\msadc\msadce.dll'
Loaded 'C:\Program Files\Common Files\System\msadc\msadcer.dll', no matching
symbolic information found.
First-chance exception in TestRun.exe (KERNEL32.DLL): 0xE06D7363: Microsoft
C++ Exception.
First-chance exception in TestRun.exe (KERNEL32.DLL): 0xE06D7363: Microsoft
C++ Exception.
ANOMALY! The interface (ICommand) reports S_OK for ISEI but GetErrorInfo
returned 0x1!
Error Reported:
HResult: 0x80040e21 (DB_E_ERRORSOCCURRED)
Location: C:\Projects\Core\sqlgen.cpp(1665)
***** ICommand -- PropertiesInError ***** (hr=0x0, nSets=0)
NO PROPERTY SETS RETURNED
***** ICommand -- ALL Properties ***** (hr=0x0, nSets=2)
Propset #0: DBPROPSET_ROWSET {C8B522BE-5CF3-11CE-ADE5-00AA0044773D} (78
properties)
-----------------PropID----------------- POptions PStatus- Value
007c DBPROP_IConnectionPointContainer 1 0 {true VT_BOOL}
0087 DBPROP_ISupportErrorInfo 1 0 {true VT_BOOL}
005a DBPROP_OWNUPDATEDELETE 0 0 {true VT_BOOL}
0059 DBPROP_OWNINSERT 0 0 {true VT_BOOL}
0058 DBPROP_OTHERUPDATEDELETE 0 0 {true VT_BOOL}
0015 DBPROP_CANSCROLLBACKWARDS 0 0 {true VT_BOOL}
0012 DBPROP_CANFETCHBACKWARDS 0 0 {true VT_BOOL}
0066 DBPROP_REMOVEDELETED 0 0 {true VT_BOOL}
0082 DBPROP_IRowsetLocate 0 0 {true VT_BOOL}
0085 DBPROP_IRowsetScroll 0 0 {true VT_BOOL}
0080 DBPROP_IRowsetIdentity 0 0 {true VT_BOOL}
00f9 DBPROP_IRowsetRefresh 0 0 {true VT_BOOL}
0002 DBPROP_ABORTPRESERVE 1 0 {false VT_BOOL}
000d DBPROP_BLOCKINGSTORAGEOBJECTS 1 0 {true VT_BOOL}
000e DBPROP_BOOKMARKS 1 0 {true VT_BOOL}
000f DBPROP_BOOKMARKSKIPPED 1 0 {false VT_BOOL}
0010 DBPROP_BOOKMARKTYPE 1 0 {1 VT_I4}
0011 DBPROP_CACHEDEFERRED 1 0 {false VT_BOOL}
0013 DBPROP_CANHOLDROWS 1 0 {false VT_BOOL}
0021 DBPROP_COLUMNRESTRICT 1 0 {true VT_BOOL}
0023 DBPROP_COMMITPRESERVE 1 0 {true VT_BOOL}
002a DBPROP_DEFERRED 1 0 {true VT_BOOL}
002b DBPROP_DELAYSTORAGEOBJECTS 1 0 {true VT_BOOL}
002f DBPROP_IMMOBILEROWS 1 0 {false VT_BOOL}
0043 DBPROP_LITERALBOOKMARKS 1 0 {false VT_BOOL}
0044 DBPROP_LITERALIDENTITY 1 0 {false VT_BOOL}
0047 DBPROP_MAXOPENROWS 1 0 {1 VT_I4}
0048 DBPROP_MAXPENDINGROWS 1 0 {1 VT_I4}
0049 DBPROP_MAXROWS 1 0 {0 VT_I4}
004d DBPROP_MAYWRITECOLUMN 1 0 {true VT_BOOL}
004e DBPROP_MEMORYUSAGE 1 0 {0 VT_I4}
0052 DBPROP_NOTIFICATIONPHASES 1 0 {27 VT_I4}
0056 DBPROP_ORDEREDBOOKMARKS 1 0 {false VT_BOOL}
0057 DBPROP_OTHERINSERT 1 0 {false VT_BOOL}
0063 DBPROP_QUICKRESTART 1 0 {true VT_BOOL}
0065 DBPROP_REENTRANTEVENTS 1 0 {false VT_BOOL}
0067 DBPROP_REPORTMULTIPLECHANGES 1 0 {true VT_BOOL}
0068 DBPROP_ROWRESTRICT 1 0 {false VT_BOOL}
0069 DBPROP_ROWTHREADMODEL 1 0 {1 VT_I4}
0074 DBPROP_TRANSACTEDOBJECT 1 0 {true VT_BOOL}
0075 DBPROP_UPDATABILITY 1 0 {0 VT_I4}
0077 DBPROP_STRONGIDENTITY 1 0 {false VT_BOOL}
0079 DBPROP_IAccessor 1 0 {true VT_BOOL}
007a DBPROP_IColumnsInfo 1 0 {true VT_BOOL}
007b DBPROP_IColumnsRowset 1 0 {true VT_BOOL}
007e DBPROP_IRowset 1 0 {true VT_BOOL}
007f DBPROP_IRowsetChange 1 0 {false VT_BOOL}
0081 DBPROP_IRowsetInfo 1 0 {true VT_BOOL}
0084 DBPROP_IRowsetResynch 1 0 {false VT_BOOL}
0086 DBPROP_IRowsetUpdate 1 0 {false VT_BOOL}
0088 DBPROP_ILockBytes 1 0 {false VT_BOOL}
0089 DBPROP_ISequentialStream 1 0 {true VT_BOOL}
008a DBPROP_IStorage 1 0 {false VT_BOOL}
008b DBPROP_IStream 1 0 {false VT_BOOL}
009f DBPROP_IRowsetIndex 1 0 {false VT_BOOL}
00ab DBPROP_NOTIFYCOLUMNSET 1 0 {3 VT_I4}
00ad DBPROP_NOTIFYROWDELETE 1 0 {3 VT_I4}
00ae DBPROP_NOTIFYROWFIRSTCHANGE 1 0 {3 VT_I4}
00af DBPROP_NOTIFYROWINSERT 1 0 {3 VT_I4}
00b1 DBPROP_NOTIFYROWRESYNCH 1 0 {3 VT_I4}
00b2 DBPROP_NOTIFYROWSETRELEASE 1 0 {3 VT_I4}
00b3 DBPROP_NOTIFYROWSETFETCHPOSITIONCHA 1 0 {3 VT_I4}
00b4 DBPROP_NOTIFYROWUNDOCHANGE 1 0 {3 VT_I4}
00b5 DBPROP_NOTIFYROWUNDODELETE 1 0 {3 VT_I4}
00b6 DBPROP_NOTIFYROWUNDOINSERT 1 0 {3 VT_I4}
00b7 DBPROP_NOTIFYROWUPDATE 1 0 {3 VT_I4}
00bb DBPROP_APPENDONLY 1 0 {false VT_BOOL}
00bc DBPROP_CHANGEINSERTEDROWS 1 0 {true VT_BOOL}
00bd DBPROP_RETURNPENDINGINSERTS 1 0 {false VT_BOOL}
00c2 DBPROP_IConvertType 1 0 {true VT_BOOL}
00c6 DBPROP_NOTIFICATIONGRANULARITY 1 0 {2 VT_I4}
00e7 DBPROP_ACCESSORDER 1 0 {2 VT_I4}
00ec DBPROP_LOCKMODE 1 0 {1 VT_I4}
00ef DBPROP_SERVERDATAONINSERT 1 0 {true VT_BOOL}
0117 DBPROP_IRowsetCurrentIndex 1 0 {false VT_BOOL}
00cc DBPROP_IRowsetFind 1 0 {false VT_BOOL}
00d2 DBPROP_FINDCOMPAREOPS 1 0 {27 VT_I4}
0104 DBPROP_CLIENTCURSOR 1 0 {true VT_BOOL}
Propset #1: DBPROPSET_JETOLEDB_ROWSET {A69DE420-0025-11D0-BC9C-00C04FD705C2}
(13 properties)
-----------------PropID----------------- POptions PStatus- Value
00ec DBPROP_JETOLEDB_VALIDATEONSET 1 0 {false VT_BOOL}
00ed DBPROP_JETOLEDB_FATCURSORMAXROWS 1 0 {0 VT_I4}
00ee DBPROP_JETOLEDB_ENABLEFATCURSOR 1 0 {false VT_BOOL}
00ef DBPROP_JETOLEDB_BULKPARTIAL 1 0 {0 VT_I4}
00f2 DBPROP_JETOLEDB_ODBCPASSTHROUGHCONN 1 0 {"" VT_BSTR}
00fd DBPROP_JETOLEDB_ODBCPASSTHROUGH 1 0 {false VT_BOOL}
00fe **Unknown** 1 0 {0 VT_I4}
00ff **Unknown** 1 0 {0 VT_I4}
0102 DBPROP_JETOLEDB_STOREDQUERY 1 0 {false VT_BOOL}
0107 DBPROP_JETOLEDB_LOCKGRANULARITY 1 0 {2 VT_I4}
010c DBPROP_JETOLEDB_BULKNOTRANSACTIONS 1 0 {0 VT_I4}
0117 DBPROP_JETOLEDB_INCONSISTENT 1 0 {true VT_BOOL}
0119 DBPROP_JETOLEDB_PASSTHROUGHBULKOP 1 0 {false VT_BOOL}
Chart::CreateRowset failed to open Rowset, hr=0x80040e21, ThreadId=0x39c
CSelectDlg::~CSelectDlg() -- DESTROYED
</DEBUGDUMP>
You can read messages from the OLEDB_DEV archive, unsubscribe from OLEDB_DEV,
or subscribe to other DevelopMentor lists at http://discuss.develop.com.