Help On Next Step(Kind of Urgent)

[scorpion53061]

Mission:

To pull images off the D:\Kelly\Images drive where SQL Server is and send to
user using a vb.net windows app(internet application).

I created a table called images3 which consists of:

1 ITEMNO varchar 50 0
0 IMAGEPATH varchar 50 1

ImagePath is where the images are stored on the hard drive of the SQL Server
Machine so it would be like
D:\Kelly\Images\koh1000.jpg for instance.

Eventually what is suppose to happen is the user clicks an item number in a
vb.net windows app and SQL is called to give the corresponding image.

Please help me to get there....

I was told that storing images directly in SQL is a bad idea if you are
wondering why I am doing it this way.

 

[mountain man]

Mission:

To pull images off the D:\Kelly\Images drive where SQL Server is and send to
user using a vb.net windows app(internet application).

I created a table called images3 which consists of:

1 ITEMNO varchar 50 0
0 IMAGEPATH varchar 50 1

ImagePath is where the images are stored on the hard drive of the SQL Server
Machine so it would be like
D:\Kelly\Images\koh1000.jpg for instance.

Eventually what is suppose to happen is the user clicks an item number in a
vb.net windows app and SQL is called to give the corresponding image.

Please help me to get there....

I was told that storing images directly in SQL is a bad idea if you are
wondering why I am doing it this way.

1) The user clicks a line item in the app corresponding to the item.
2) The app queries SQL for the path, given the itemno.
3) SQL passes back to the app the imagepath.
4) The app will launch some image display software associated
with the image file (.jpg) extention, using the filename supplied at 1.




Does the app have to be integrated into an exiting suite?
I already have an app that does this.

See:
www.mountainman.com.au/software/southwind
search for "document management system"


email for further info.

 

[scorpion53061]

When I replied to you in bounced back as undeliverable.