Hi,

I have developed an OLE DB provider, and although using a
OleDbCommandBuilder generates the UPDATE and DELETE statements correctly and
without error, using the Data Adapter Configuration Wizard fails.

I have dug deep into the Microsoft.VSDesigner.dll library, and narrowed down
the error in the CommandGenerator class within the
Microsoft.VSDesigner.Data.VS namespace.  Specifically the call to QryAddFltr
interface method of the Query.CQryAuto COM class (found in the vdt70.dll).

Internally, a CCUException is being thrown.

There seems to be a different code path when using the MSSQL OLE DB provider
in the CDaVinciQueryProxyStateLoader::PqsnFromExpressionServices method (I
am only able to look at the asm obviously, so here is a small excerpt):

51F4AF13  call        CDaVinciQueryParser::PqsnParseExpression (51F47200h)

The result of the above call when using MSSQL is that the cmp eax, 61h below
is false (as eax is 32h).  When our provider is called, the result of eax IS
61h, and then the je PqsnFromExpressionServices is followed.  Why the
difference, and what do we need to do to fix this - or why would the
exception be thrown?

51F4AF18  mov         esi,eax
51F4AF1A  mov         eax,dword ptr [esi+4]
51F4AF1D  cmp         eax,61h
51F4AF20  je
CDaVinciQueryProxyStateLoader::PqsnFromExpressionServices+91h (51F4ACD0h)

Any help from MSFT would be greatly appreciated.

Cheers,

Stuart