Graphic from Pdox to SQL ?

#11

"Jim Hargan" <contactATharganonlineDOTcom (AT) nospam (DOT) net> wrote

Quote:

On Sun, 12 Nov 2006 10:39:31 +0100, Bjorn Sagbakken wrote:

Eventually I will use .NET for web-pages,
so I need to figure out how to store images into the SQL from that side
also.

At the risk of showing my ignorance of most of the topics discussed in
this
thread -- are you trying to serve images into web pages? If you are, you
realize that the web page won't contain the bits and bytes of the actual
image, but only the path (URL) to where the image is stored as a jpg, png,
or gif. So maybe you only need to store the images's URLs in your SQL
table, and not the images themselves. All you need to do for the images is
save them as jpegs and load them into a subdirectory on your web site
server, then store the paths to these images in the table.

What you describe is pretty much how our web-pages work at the time, the
images stored in a subdirectory and the SQL tables only the path. However, a
few yars ago I designed some ASP pages that presented images that were
stored in the SQL table itself. This worked very well, but I could not
upload the images through web-pages, but used a VB-application to do that.

This time I want the SQL-server to serve both the WEB-pages as well as the
Paradox application. I can surely go for images saved into subdirectories in
both cases, but I have experienced major access problems in the network,
because the Anonymous user from the webserver hardly should be given access
anywhere else in the network than the local directory on the webserver, and
on the other side; other users in the network (Paradox users) would not
normally have access to the company's webserver. At the moment I have an
experiment going on, where Paradox (with a higher user credential on the
network login) is copying files back and forth with an interval of a few
minutes. But this is messy workaround I rather would avoid.
So-images stored into the table itself is still my prefered idea.

#12

"Anders Jonsson" <gt3TakeThisAway (AT) bredband (DOT) net> wrote

Quote:

I have written a test-script in Paradox to copy the graphic from Pdox to
SQL, using tcursors and graphic variables.

Björn,

Try to use a binary variable instead of a graphic one.

I use readfromfile to get the image into a binary variable and then
tCursors to get it into the MSSQL table.

Thanks for the advise. I will check it out and report back here as soon as I
have tried it.

Bjorn

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Graphic from Pdox to SQL ?

comp.databases.paradox comp.databases.paradox

Re: Graphic from Pdox to SQL ? - 11-13-2006 , 01:46 PM

Re: Graphic from Pdox to SQL ? - 11-13-2006 , 01:47 PM