Possible to access cross-domain??

They have: 7 posts

Joined: Jul 2006

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's picture

He has: 2,145 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

They have: 7 posts

Joined: Jul 2006

Great, I'll give it a try...

openmind's picture

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 Wink

Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.