Is it possible to house a database on on server location and access it with coldfusion from a second location that isn't on the same server?
We have two seperate sites that need to access the same database and use the same payment gateway, is this possible?
Greg K posted this at 21:46 — 17th July 2006.
He has: 1,665 posts
Joined: Nov 2003
I can only speak for mySQL, but as long as the database is set up right, you can do this. If this is on a hosted server, ask them to set it up for you. If it is your own server, then add a user for the remoe access. Preferably the remote system has a static IP address so you can restrict the access to that server only.
-Greg
[This space intentionally left blank]
Cool Geek Supplies: www.ThinkGeek.com
careyr69 posted this at 22:02 — 17th July 2006.
They have: 7 posts
Joined: Jul 2006
Great, I'll give it a try...
openmind posted this at 20:06 — 19th July 2006.
He has: 945 posts
Joined: Aug 2001
Yep certainly possible as long as the CF DSN is set up in the administrator to point at the MySQL IP address and they allow external connections of course