How to make odbc queries on db's on the same server, but registered to different domains?

I have two domains (A and B) hosted on the same server. I need to query sql db's on one domain from the other domain.

I thought it should be as easy as this, but it's not finding the db.

From Domain A:

SELECT

*

FROM table

</CFQUERY>

Thanks!

This topic has been closed for replies.

Community Expert

I am curious what your ColdFusion version is.

Participating Frequently

If I am understanding you correction.. You have 2 domains each with their own databases and you want domain A to make calls to domain B's database?

If that is the case you should have 2 datasources setup in CF. All you would need to do is have domain A use domain B's datasource.

Also, DBSERVER is a depreciated attribute and doesn't work anymore.

HTH,

--Dave

Sign up