ASP code to retrieve and update two or more database in defferent location.
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!
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...
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.