Forum Discussion

PeterMitcham's avatar
Occasional Contributor
9 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
    9 years ago

    Well it would appear the problem relates to the datatype being passed, 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.