neuwirth
asked on
Insert into IMAGE column
I need to insert binary data into IMAGE column with SQL.
I cann't use ADO, ODBC, OLE DB or DB Library.
I know, that I have to use INSERT INTO or WRITETEXT or BULK INSERT.
My question is this:
In my application I've binary data stored in variable. I'd like to use SQL to insert this data into SQL server. But how? I cann't use sql="INSERT INTO MyTable (ImageColumn) values (" & MyBinaryValue & ")". This failed.
Thx
I cann't use ADO, ODBC, OLE DB or DB Library.
I know, that I have to use INSERT INTO or WRITETEXT or BULK INSERT.
My question is this:
In my application I've binary data stored in variable. I'd like to use SQL to insert this data into SQL server. But how? I cann't use sql="INSERT INTO MyTable (ImageColumn) values (" & MyBinaryValue & ")". This failed.
Thx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.