Discussion Locked

file conversion

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi,
I am Using Ms-Sql 7.0 and there is a table having a column of IMAGE DATATYPE to store Binary Data.

Now ALL I WANT TO DO IS..

1) CONVERT ANY OF THE FILES THAT ARE EXISTING ON MY HARD DRIVE INTO BINARY FORMAT

2) INSERT THE SAME INTHE COLUMN OF THE TABLE

HOW DO I GO ABOUT DOING THIS..?

IF IT REQUIRES SCRIPTING PLEASE CAN ANY ONE PASS ON THAT SCRIPT TO ME..?

PLEASE HELP

JOHN BOSCO

5 replies

by kashifidrees

hi Friend:
Never use Picturs inside SQL Server 7.0 if u are using ADO and VB. because OLE object is used for the storage of pictures in the database both SQL Server and the Access.
And OLE does not Support ADO.
However just paste OLE control on the form.
attach the picture to it and connect it to the datavase through DAO. Picture will be automatically inserted into the database.
i have already successfully performed this process. If u have any further queries, u can contact me at:
kashifidrees@yahoo.com

This discussion is closed to new replies.