Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2003
    Posts
    454

    Unhappy Unanswered: How to send the form to different website

    When a user submits a registration form, all data from the form will be saved in my database which is MSSQL server 2000. At the same time, I want to send the data to the other website located on the different server. Does anyone have any idea about it? Thanks in advance.
    Last edited by gyuan; 01-07-04 at 12:59.

  2. #2
    Join Date
    Jun 2003
    Location
    USA
    Posts
    1,032
    Perhaps on the other Web site have a page that can take a querystring and enter that data into the database. And on the first Web site have a popup window link to the second Web site with directions for the user to click the link to enter the data into the other site (and then the user can close the window).

    It's clunky but at least it's something.
    J. Paul Schmidt, Freelance Web and Database Developer
    www.Bullschmidt.com
    Access Database Sample, Web Database Sample, ASP Design Tips

  3. #3
    Join Date
    Feb 2002
    Posts
    2,232
    What do you mean when you say "I want to send the data to the other website located on the different server" ? Do you mean to another sql server instance ?

  4. #4
    Join Date
    Dec 2003
    Posts
    454

    co-registration

    Originally posted by rnealejr
    What do you mean when you say "I want to send the data to the other website located on the different server" ? Do you mean to another sql server instance ?
    That's the co-registration project. When a user submits a registration form on website A, the user's info needs to be sent to another website B and to be stored into B's database which is located on another database server.

  5. #5
    Join Date
    Jul 2003
    Location
    Penang, Malaysia
    Posts
    212
    You can write your ASP script to update 2 SQL Server databases

    or

    You can replicate table data from 1 SQL Server instance 2 the other.

    or

    You can do a link server from SQL Server 1 to 2 and do a join view.
    Patrick Chua
    LBMS ( Learn By My Self) NPQ ( No paper Qualification )

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •