Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

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

New Here ,
Jan 02, 2016 Jan 02, 2016

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!

300
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Engaged ,
Jan 02, 2016 Jan 02, 2016

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

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Jan 03, 2016 Jan 03, 2016
LATEST

I am curious what your ColdFusion version is.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Resources