Connecting to multiple databases

[simplyblue]

Hi,
I'm quite sure i've seen this somewhere in the forum but i can't seem to find it now. So, sorry i have to ask this again..
I have 2 databases residing on 2 servers. Can my asp codes on one server connect to the database on the other server?

[Morgoth]

I don't know what the answer was on the last post asking about that sort of question, but I think it is impossible to connect to another db on another server.
When I get home today, I am going to look into connecting to a db on another server using some sort of virtual link, and see if I can do something, but I think people are unable to do this sort of thing, I think it protects agaist someone else trying to steal the db's information.

[simplyblue]

I heard that it can be done by polling... but what kind of polling? what exactly is it? hmm....

[csmajor231]

Are the server on a local network, if they are what type of DataBase are you using.

This is possible but the only trick is you need to make sure the User Accounts have the same password and also have access to the databases.

If you are using MS SQL it is very easy, all you need to do is create a user on the database servers and connect them like you normally would. Each server would needs its own ODBC connection though to each database. If you need any more help just let me know

[simplyblue]

The servers are not on local networks. We are using Access at the moment, but might be switching over to MS SQL if there really is a need to.
Thanks for offering your help csmajor1234 :) Will definately look for you if I need any more help. :)

[csmajor231]

Because they are not on a local network, you would need to set up something like a VPN, you need some way to communicate securely between the front end website and the backend database servers, if you are unable to authenticate with Access it will not let you complete the task at hand...this is a good thing because that means no one else can get into your data

[simplyblue]

oh no.. this seems complicated...