How do i store image path in Database(Access)

[indhu]

storing images into database and latter fetching it shows a error. so what i thought is instead of storing the image directly into the database its better to store the image path. but my problem is how to store the image path into the database?can you give me an example

[rolfk]

indhu wrote:

> storing images into database and latter fetching it shows a error. so
> what i thought is instead of storing the image directly into the
> database its better to store the image path. but my problem is how to
> store the image path into the database?can you give me an example

Convert it to a string with Path To String conversion function?

Rolf Kalbermatter

[Jeremy_L]

Hi,

When you attempted to store the images into access, did you store them as BLOBs? If so, there are some good sites out there (Google for "storing images in Access") that talk about doing it this way versus just doing image paths. If you prefer to stick with image paths, however, then that is simply just using the Path To String VI to make the string and then send it into the db using the insert data vi from the DB Connectivity Toolset. Then, just store all of your images in a predefined directory that maintains the path from the database entries.

Jeremy L.
National Instruments

[indhu]

I'm able to store the image path into DB but the problem arises while retrieving it. will you please help me out?