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">
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.
I am curious what your ColdFusion version is.