Forum Discussion

PeterMitcham's avatar
PeterMitcham
Occasional Contributor
10 years ago

ADODB - Syntax error when trying to open a recordset when using the adCmdTable parameter

Hi   I am trying to update a record in a sql server database table and when i try and open up a recordset using adCmdTable parameter i get the following syntax error.   Err.number: -2147217900 E...
  • PeterMitcham's avatar
    PeterMitcham
    10 years ago

    Well it would appear the problem relates to the datatype being passed, adodb.stream expects it to be a byte() array and its being passed as a variant (as per vb script).

     

    There were numerous examples of converting a variant to byte array available on forums\solutions sites etc, but i struggled to get them to work.

     

    I solved it finally by writing a console app that replicates the adodb stream process and it works fine.