Login    Forum    Search    FAQ   Blog

Board index » Server Side Development » SQL




 Page 1 of 1 [ 6 posts ] 



Author Message
 Post subject: sql server, images, webservice
 Post Posted: Sat Nov 21, 2009 2:01 pm 
Offline

Joined: Sat Feb 21, 2009 11:57 am
Posts: 40
Hi all,

I need some advice on a particular problem. Here's the situation:
I have a database (sql server 2000) with a table, let's call it tblTable. In tblTable there is a field called Image1 of datatype varchar and this field contains the path of images stored in the files system.

I want to create a web service (.NET 2.0) that would query get data 4m the
tblTable addin da original images nd not da image path. The web
service wwould have a func dat gets da data nd then returns a dataset
which comsists of da image. This image would then be saved in 2 anothr
db (not in the file system but in the database itself).

In the db dat consists of the tblTable, how could I return da
actual image as part of the select query. The query would be in a stord
procedure and would be the calld by da webservice 2 populate a dataset.

Thanks in advance'

_________________
Login: yes
Password: i dont have one
password is incorrect

Login: yes
Password: incorrect


Top 
 Post subject: Re: sql server, images, webservice
 Post Posted: Sat Nov 21, 2009 2:01 pm 
Offline

Joined: Sat Feb 21, 2009 11:06 am
Posts: 1794
if ur webservice gets da paths 2 da images 4m the SQL Server, it
could easily get at da bytes of da file usin the apis in da
System.IO namespace


Top 
 Post subject: Re: sql server, images, webservice
 Post Posted: Sat Nov 21, 2009 2:01 pm 
Offline

Joined: Sat Feb 21, 2009 11:57 am
Posts: 40
How abt if da web service resides in anothr server than da db?

_________________
Login: yes
Password: i dont have one
password is incorrect

Login: yes
Password: incorrect


Top 
 Post subject: Re: sql server, images, webservice
 Post Posted: Sat Nov 21, 2009 2:02 pm 
Offline

Joined: Sat Feb 21, 2009 1:08 pm
Posts: 549
that works fine. what was the important is da web service needs
access 2 da server where da images reside.

Are u storin da paths as UNC r local paths in da data base ? my
suggestion only works well if UNC.


Top 
 Post subject: Re: sql server, images, webservice
 Post Posted: Sat Nov 21, 2009 2:02 pm 
Offline

Joined: Sat Feb 21, 2009 11:57 am
Posts: 40
what was saved is da relative path in relation to the app root path.
example: "/Folder1/Pic123.jgp"

_________________
Login: yes
Password: i dont have one
password is incorrect

Login: yes
Password: incorrect


Top 
 Post subject: Re: sql server, images, webservice
 Post Posted: Sat Nov 21, 2009 2:02 pm 
Offline

Joined: Sat Feb 21, 2009 1:08 pm
Posts: 549
then you could make dat root path a network share, give da
web service perms to read 4m da share, and da web service could
be able to open the files using System.IO methods.


Top 
Display posts from previous:  Sort by  
 
 Page 1 of 1 [ 6 posts ] 




Board index » Server Side Development » SQL


Who is online

Users browsing this forum: No registered users and 2 guests

 
 

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron