User (Legacy) Posted May 13, 2004 Report Share Posted May 13, 2004 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.