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

[raehm]

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:

<CFQUERY datasource="datasource on domain B" DBSERVER="serverurl for domain B" username="username" password="!password">

SELECT

*

FROM table

</CFQUERY>

Thanks!

[Dave Ferguson]

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

[BKBK]

I am curious what your ColdFusion version is.