dcsimg
www.webdeveloper.com
Results 1 to 4 of 4

Thread: ASP code to retrieve and update two or more database in defferent location.

  1. #1
    Join Date
    Jan 2006
    Posts
    16

    ASP code to retrieve and update two or more database in defferent location.

    Hi gurus,
    Is it possible to retrieve and update SQL or access databases in different location? For instance "SELECT * From sometable" in www.abc.com and "UPDATE sometable WHERE ID=123" in www.xyz.com and ASP code was run on www.runcode.com? Please assume have all administrator privilege (including database settings) in those site. If this not working then does it have another way to perform similar outcome? Many thanks!

  2. #2
    Join Date
    Dec 2003
    Location
    England, UK
    Posts
    432
    so you're trying to get data to and from completely separate servers on different networks?

    if you are then maybe you could use web services to transfer the data. it would be fairly easy to create a couple of simple services to retrieve data and update it. even easier if you're using .net to do it...

  3. #3
    Join Date
    Jan 2006
    Posts
    16

    Regarding to previous question

    What you mean web services? Sorry for weak knowledge for that.

  4. #4
    Join Date
    Dec 2003
    Location
    England, UK
    Posts
    432
    web services are just web applications designed to be called from within other applications. the idea is to provide some functionality in the service and have client systems request it. in your case this functionality would be retrieving a load of data and then doing some updates.

    web services have no real user interface. they use xml as their file format and can be called using a http get or post request or using soap. some of these protocols are often disabled. because these technologies are all open standards then you can use these services to communicate between different types of machines.

    i imagine that you'll find loads of info on the subject of web services if you just type it into google.


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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



Recent Articles