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

Hi Stuart,

We noticed you have posted a same message in the group
microsoft.public.data.oledb, we will work on it and reply you in that
group, please check it later...


Thanks for your understanding!

Best regards,

Gary Chang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------

Excellent sir, thank you!

Cheers,

Stuart

[quoted text, click to view]