Ok, so I have a website that I'm making that has read-only access to a different website's database information (to list the names of communities and the lots within them) and I am making a tracker-thingy for the website (the one with read-only access) that involves making their own list of stuff and updating it...
Basically I need something that can get the community's id and name and the lot id from the other database and then make it's own list of information on the localhost database like the stage of construction, who (which user-id number from the localhost) is doing the electrical, etc.
Is there a way to connect to two different databases for the same page and then only update the information to one of them?
Sure. Your server-side language will have some mechanism for establishing a connection. You just do that twice with different variables/handles and connection strings or parameters.
ADDENDUM: Though, some DBMS's also support a mechanism "linked server" mechanism, wherein you can writing your queries against database A, which has access to remote database B as if it were just another instance on the local machine. In that case, you'd establish a single connection from your page/application and simply refer to the remote database tables using their full, long-form names. I know SQL Server supports this. (Not sure if MySQL does.)
Multiple Database Sources??
Reply With Quote
Bookmarks