LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Trying to write an bmp to Access with SQl toolkit

I try to insert an bmp to Microsoft Access into an datatyp OLE-Object field with a INSERT or UPDATE SQL statement with the LabView SQL-Toolkit. I didn't get a solution at this time, I always get an error statement from the SQL-Toolkit.
Thanks a lot, Uli
0 Kudos
Message 1 of 4
(2,884 Views)
I was able to write BMP data to an Access OLE_Object field with the Database Connectivity Toolkit. When you mention the SQL Toolkit do you mean this current one or the "old" SQL Toolkit that was obsoleted when LabVIEW 6.0 was released?

What error are you receiving?

Another thing to look at is what exactly is the data when you have it in LabVIEW? Is it in a picture control, a BMP file, a 2D Array, an IMAQ image? When I was testing this, I used the Read BMP File subVI to read in a BMP, then I used the Draw Flattened Pixmap to display that BMP in a picture control. When I wrote the data to the database, I can write either the image data cluster or the pixmap information to the OLE-Object field and successfully read it back and convert it to the original format
. How are you accessing that image when it's in Access? That might help decide what type of LabVIEW data to write. The OLE-Object type is really just a binary data type that can store any kind of information.
0 Kudos
Message 2 of 4
(2,884 Views)
I'm using LabView Version 6.1 and the SQL Toolkit Version 3.0.
When I write the data to Access as a 8 bit pixmap array or directly as a picture control I used the vi "Cluster to Insert SQL Template".
I receive the error: "Error 400 occurred. Description: Parse Control Data - ERROR, can't parse that. Unknown data type code - 64." Abort or more Info Button are displayed.
Thanks Uli
0 Kudos
Message 3 of 4
(2,884 Views)
I'm using LabView Version 6.1 and the SQL Toolkit Version 3.0.
When I write the data to Access as a 8 bit pixmap array or directly as a picture control I used the vi "Cluster to Insert SQL Template".
I receive the error: "Error 400 occurred. Description: Parse Control Data - ERROR, can't parse that. Unknown data type code - 64." Abort or more Info Button are displayed.
Thanks Uli
0 Kudos
Message 4 of 4
(2,884 Views)