Re: DB_E_ERRORSINCOMMAND Exception(_com_error:: 'vtable')

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

What is the type of "queryStr"? If it's a char*, you must change it to
TCHAR* because Windows CE does not accept (except in very rare cases) ANSI
strings, only UNICODE.

--
João Paulo Figueira
Embedded MVP
http://nativemobile.blogspot.com/

"Prince" <princevictor.moses@xxxxxxxxx> wrote in message
news:1131429857.673774.47040@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Hi...
>
> In Embedded VC,While I execute an insertion query I am getting
> 'DB_E_ERRORSINCOMMAND' exception but the same query gets executed in
> Query Analyzer and connection string is correct..
> Wats the problem???
>
> Statements :
>
> queryStr = "INSERT INTO resalloc "
> "(BaseLineId, "
> "Restype, "
> "subType, "
> "ResId, "
> "schObjId, "
> "startDtm, "
> "endDtm, "
> "PlnorAct) values "
> "('', "
> "'PERSON', "
> "'" + bstrRoleId + "', "
> "'" + bstrResId + "', "
> "'" + bstrNewId + "', "
> "'" + bstrPlndStart + "', "
> "'" + bstrPlndEnd + "', "
> "'P')" ;
>
>
> pConn->Execute(queryStr, NULL, adExecuteNoRecords);
>
>
>
>
> Looking forward for the reply...
> Thanx in advance...
>
>
> Regards,
> Prince
>


.

Relevant Pages

  • Re: My function returns true but my code does not execute
    ... >John Moore wrote: ... >Then you can't use array values like that in strings. ... I changed the query to read like this: ... I wrote this function to execute 2 more functions IF this query ...
    (comp.lang.php)
  • Re: Finally which ORM tool?
    ... manipulate the linq query IF you're executing it at that moment. ... simply because the declaration construction was with 'CHOPS'. ... implement IEnumerablebut had an Execute() method which gave back ...
    (microsoft.public.dotnet.languages.csharp)
  • RE: SQL stored procedure executing twice
    ... I wasn't aware that DLookupwould execute the "domain" more than once. ... caused the stored procedure to execute twice. ... Dim stDocName As String ... My pass-thru query properties ...
    (microsoft.public.access.modulesdaovba)
  • Re: Clarification on DBI module
    ... You get the same results for the second execute because the record buffer in the statment handle is not cleaned out because no execute took place. ... The sql query can have bind variables or they may not have. ... Ahhh...imagining that irresistible "new car" smell? ...
    (perl.dbi.users)
  • RE: Running action function from SELECT query
    ... Yes ADO can execute queries saved in an Access database. ... I do not know how ADO.NET works, but the developer tells me he is able to ... At any rate, I can call just a function from a query, like this: ...
    (microsoft.public.access.modulesdaovba)