topic 回應： Re: Import image to labVIEW from MSSQL in LabVIEW

Import image to labVIEW from MSSQL

shingy — Sun, 26 Apr 2009 17:14:43 GMT

Dear all ,

i have some trouble about import the image from the SQL server by using labview

database connectivity toolset . How can i read the image in the Database ? as the image

is encoded by binary.

Thank all

Re: Import image to labVIEW from MSSQL

MikeS81 — Mon, 27 Apr 2009 07:39:58 GMT

Hi shingy,

you should store it temporary on your harddisk. You can load it from there with the "normal" Picture functions.

Which format has your image?

Mike

回應： Re: Import image to labVIEW from MSSQL

shingy — Mon, 27 Apr 2009 08:29:36 GMT

hi mike ,

in fact , i want to import the image to the labview from the SQL database , but the image datatype is varbinary( Max ) ,

i don;t know how i can show this image and show it in the labview after i use database connectivity toolset to get the information of this image

my image is jpg.

is there any demo to do this ?

Thanks

Re: 回應： Re: Import image to labVIEW from MSSQL

MikeS81 — Mon, 27 Apr 2009 08:33:55 GMT

Hi shingy,

you can read image from the database and store it to a file. You should be able to read the data like all other entries from the database. Store it as *.jpg and load it with "read jpg file.vi".

Mike