Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 ADO Recordset Binds with Binaries

Author  Topic 

KarinsDad
Starting Member

17 Posts

Posted - 2002-06-05 : 11:50:24
I created a class to allow me to do ADO Recordset Binds.

For integers, chars, varchars, bits, dates, etc. it works like a champ.

But, if I try to use it with binary or varbinary, it doesn't work.

It allows me to read data from the database (say data entered in via Query Analyzer), but it doesn't let me insert data. It comes up with error 80040E21 on the AddNew method and returns a value of 2 (Value couldn't be converted for reasons other than sign mismatch or data overflow) in the status parameter.

Does anyone have any experience with this?

Has anyone actually gotten binary to work with OLE DB and ADO recordset binds (SQL Server 7.0, Visual C++ 6.0)?

   

- Advertisement -