how to store jpeg images in SQL server using NI database Connectivity Toolset. Can anyone please help me in this regard.

[Nitin_Bhandari]

Please tell how to store jpeg images in SQL Server using NI Database Connectivity Toolset.

[LV_Dan]

How about storing the images as files on a filesystem and then store the filepath to the images as a string in the databse?

Dan

[Nitin_Bhandari]

Storing Images as files is not a secured way. The images can be deleted by anyone. Can I directly store the images in the database?

[LV_Dan]

You can convert the images to a byte array and store the byte arrays in the database.  This is not recommended for storing large images or a large nmuber of images.  Most will recommend storing the path to a file on a filesystem as I previously suggested.

How about creating a more secure filesystem that is only accesible via your LabVIEW application?

Dan

[Nitin_Bhandari]

Thanks for suggestion. Can you please tell how to make a secure filesystem that is only accessible trough Labview?

[Yamaeda]

Set the secutiry options so Users group only has Read access, and the LV-programs account has Read+Write.

/Y

[Nitin_Bhandari]

The application has to be installed on many computers with different users and they also have to store images in the same folder. How can I make that folder secure? Therefore I have to store the images in SQL server. For that can anyone please help.

[Yamaeda]

http://www.w3schools.com/sql/sql_datatypes.asp

You setup a field as BLOB and store the binary of the picture there. Depending on the database it can be called differently as you can see in the link, in SQL server there's even a Image datatype.

/Y

[Nitin_Bhandari]

The NI Database connectivity toolset only have six data types in the create table VI i.e. String, Long, Single, Double, Date/Time, Binary. But it does not have BLOB data type. Even in the binary data type it does not store too much data of the image. It gives an exception error. Please help in this regard.

[Yamaeda]

You can write a sql statement and Execute query, that might be what's needed here.
/Y