Chart Template Export

[User (Legacy)]

Hi~

I'm trying to export to an OLE Stream object in VB for ChartFX

Client-Server. The API Guide show it is possible

but there isn't any sample.

Please, Say anything wrong in my code and Help me.

_______________________________________________

    Dim strCon As String

    Dim strSQL As String

    Dim objStream As Stream

    Dim objCon As ADODB.Connection

    tmpFile = "c:\tmp\chtmp"

    strCon = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security

Info=False;Initial Catalog=iOLAP_Admin;Data Source=."

    ChartFX1.Export CHART_CFXOLEFILE, objStream

    strSQL = "INSERT INTO chttemp(template) VALUES('" & objStream & "')"

    Set objCon = New ADODB.Connection

    objCon.Open strCon

    objCon.Execute strSQL

    objCon.Close

    Set objCon = Nothing

    Set objStream = Nothing