#1. I am not trying to insert or update a record. I am trying to update the data inside of a chart object that is inside the image field of a SQLServer table

#2. According to:
http://support.microsoft.com/support/kb/articles/Q191/1/03.asp,

"The OLE Container Control is not designed to work with the ADO Data Control"

So I cannot bind the data.

I tried this code, but this does not work:

dim ch as Graph.Chart

' this is without bound control
set ch = rs.fields("my_general_field").value

However, adLongVarBinary will not go into the object ! But the same field does show up in Crystal Reports as a graph !


However, if I could only get the above line to work, I can continue with the following (I know this part works - when I am not using ADO to populate the chart object):

ch.Application.DataSheet.Range("A0") = "SERIES1"
ch.Application.DataSheet.Range("B0") = "SERIES2"
ch.application.datasheet.("01") = "Jan"
ch.application.datasheet.("02") = "Feb"
ch.application.datasheet.("A1") = 25
ch.application.datasheet.("B1") = 29


' with a bound control, this should be the code, but as I said before, ADO and OLEBound dont mix:
set OLE1.object = rs.fields("my_general_field").value