• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
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

Copy link to clipboard

Copied

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!

Views

239

Translate

Translate

Report

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

Copy link to clipboard

Copied

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

Votes

Translate

Translate

Report

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

Copy link to clipboard

Copied

LATEST

I am curious what your ColdFusion version is.

Votes

Translate

Translate

Report

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
Documentation