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?

    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!