Skip to main content
Known Participant
August 2, 2008
Question

two sites connecting to one CF DSN

  • August 2, 2008
  • 3 replies
  • 690 views
Hi I am not sure is this a coldfsion thing only or more a database connectivity issue.

I have a site which has a table and I connect to it via a ColdFusion DSN

I have another website (diff Domain), and I would like this to connect to the same database on the above site. Is this possible? If so how would i do this?

I tried by just placing the above DSN and username, password, but it says the DSN could not be found...

Could someone help?

Thanks

Peter
This topic has been closed for replies.

3 replies

BKBK
Community Expert
Community Expert
November 13, 2008
I have another website (diff Domain), and I would like this to connect to the same database on the above site. Is this possible?
Yes.

If so how would i do this?
Just configure each site's DSN as you would normally do as if it was alone.

I tried by just placing the above DSN and username, password, but it says the DSN could not be found...
Then there was a mistake in the configuration, which would have occurred with just one site.

Inspiring
October 29, 2008
We do it, but we host ourselves. If you are being hosted, maybe they are doing some security thing that is foiling your efforts.
Inspiring
August 4, 2008
pmayadun wrote:
>
> Could someone help?
>


Different sites...

Different hosts or the same host?

Different servers or the same server?

Different ColdFusion instances or the same instance?


Any other words what is the relationship between these two domains to
each other and the ColdFusion server with the desired DSN?
Participant
October 28, 2008
Different sites.
Same host.
Same server.
One site is for students.
One site is for faculty.
Some publication content is the same for both; some not.
Students purchase through e-commerce site.
Faculty login and download for free.

Thanks, Charlie