can u give me the illustration of how to use the Ole object to store the image PRAVEED

Use ADODB to scan an image? Bottom line is -> you can't. That's not what ADODB does. Are you trying to capture an image from a video camera? If so, what kind? A QuickCam? For something like that, your going to need a SDK from the manufacturer of the camera to get at an image. Logitech has one that works with its line of QuickCams at http://developer.logitech.com. RageInTheMachine9532

In order to retrevie data from backend SQL server.... You need to follow this step 1)first go to Project-References-select "Microsoft ActiveX data objects 2.1 library 2)then declare this value Option Explicit Dim con As New ADODB.Connection Dim Rs As New ADODB.Recordset Dim Com As New ADODB.Command Private Sub Form_Load() con = New ADODB.Connection ConString = "provider=sqloledb;uid=;pwd=;Initial Catalog=;Data Source=" con.open Then you can write code for retreiving data.. make sure that you close connection each time when you open the connection. End Sub

Dim Con As New ADODB.Connection Dim Rs As New ADODB.Recordset Dim Com As New ADODB.Command Private Sub Form_Load() with Con .ConnectionString = "Data Provider=SQLOLEDB; Provider=MSDATASHAPE; uid=;pwd=; Initial Catalog=dbname; Server=server-name;" .Open end with With Com .ActiveConnection = Con .CommandType = adCmdText .CommandTimeout = 0 '//never time-out .CommandText = "SELECT * FROM table-name" End With Rs.Open Com Call Read '//sub defined below End Sub private sub Read() Rs.MoveFirst while not Rs.EOF Print Rs!Field-name1 '//print to screen - whatever.. Print Rs!Field-name2 . . Print Rs!Field-namen Rs.MoveNext wend end sub :rose::rose: