storing image in sql server 7.0
-
how do i store an image in sql server 7.0 selected by user in a vb 6.0 form. please help....
jabey -
Hi jabalshah,
quote:
how do i store an image in sql server 7.0 selected by user in a vb 6.0 form. please help....take a look at the ADO Stream Object and the image data type or search this site on this.
There are countless threads about this
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
I would be carefull storing blobs in 7.
Way back when we used 7 to store images, SQL would only run for a couple weeks then require a reboot. Not sure if the latest SP has fixed this problem but SQL used to run out of memory.
The images were accessed OFTEN (Every few seconds) and it was a large table.
Would it not be better to store the images in the NT FS and store the path to the image in SQL?
Cheers,
Crispin
Something as incredibly simple as
binary still gives you too many options
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply