2 Replies Latest reply on Jan 3, 2016 2:39 AM by BKBK

    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:


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



      FROM table