Image upload on multiple servers using classical ASP or VBscript

25 pts.
Tags:
VBScript
We have two servers for load balencing, But when we have logged in from one server and upload an image to the server by using simple image upload functionality all work fine but when we try to view image through another server then it doesn't show. Because we store a path of image to DB and image get stored to a specific server. Please give me a way to upload image to both the servers simaltanously, in VBscript or classical ASP(ASP 3.0)
ASKED: December 30, 2008  8:32 AM
UPDATED: December 30, 2008  11:20 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

SwapnilD,

You should be able to handle this on the backend. You can write a DB trigger that
copies the image “record” to the other database after it is committed. Considering that you did not
describe the database software you are you using then we can’t speak to this more specifically.

I would have hoped that you would be using a 3 tier architecture, i.e., 2 servers to load balance web
applications [1], another server that has the database [2] and the client software (browser,thin client, thick
thick client, whatever) [3]. In this manner you only have to have one place a record has to be
maintained.

If you insist on having a DB on both servers then they should be mirrored. That is, the database
software that is used will do this record copying function for you “automagically”. MSSQL Server
has mirroring capability; Oracle server has this functionality as well but this would be done either
using Oracle’s RAC technology or one of the 2 databases would be in a standby-read-only mode
that is near-time, not real-time (it uses log shipping from the “hot” database to keep records
up-to-date).

Otherwise, as stated, the best way to handle this is by writing a database trigger on
each database server that fires off a copy of the image record to the database on the other server
after the image creation transaction is committed on whichever database server handles the inital
transaction.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • SwapnilD
    [...] news by unknown « Free adober reader speed up Download - adober reader speed up Software Free [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following