Write/Read JPG image to Access Data Base

[lmontoya]

I'm Trying to Write and Read JPG's images to Access data base.

1.- first way to do it is to convert the image to Text string and save into a column (in this case to "imagen"), but the maximum size must be less than 255 bytes (according with returned error) and other error than i'm getting is sintaxis errors (but i'm sure is ok because if I put some text into that field works but not the text from JPG image. 

2.- the other method is changing the "imagen" field to OLE object (you can open the data base annexed and change the column "imagen" to OLE object into "Consulta" data base. In this case I don't know how to convert the JPG image to Ole Object and concatenat into the other fields.

Please see the zip file annexed.

Thank you guys...

[lmontoya]

No body can Help me?  still have the same problem...

[cosmin]

Hi,

it's straight forward, change to OLE type and write the jpeg string. It will be a BLOB in access database.

cosmin

[lmontoya]

Sorry, but I don't understand.

there is a zip file with all, can you show me how?

Thank you

[cosmin]

Hi,

attached is the modified version. There were some mistakes regarding your SQL statement as well.

You can continue from here.

cosmin

[lmontoya]

Cosmin:...

Can you save it in LabView8.6?

Thank you

[lmontoya]

Any body can change the last Zip file from LabView 2009 to 8.6?

Thank you

[G_K]

Hi, Please find the modified LV8.6 version VIs attached.  There are some vis has password protection so i couldnt able to downconvert fully. But i hope that the attached version will solve your problem.

[cosmin]

Hi,

attached is the 8.6 version, with all subvi's.

cosmin