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

Can cfdbinfo retrieve tables for Linked SQL Servers?

New Here ,
Oct 17, 2013 Oct 17, 2013

Copy link to clipboard

Copied

I am looking at using cfdbinfo tag that can introspect a Linked SQL Server Setup.

The server setup is as follows:

Coldfusion as a datasource cftest that points to SQL Server A

SQL Server A has an established link to SQL Server B

I can query using cfquery information from server B by going

Select * from SERVERB.Database.dbo.table

However, this tag setup does not return the name of the table

<cfdbinfo type="columns" name="test" table="table" />

This errors out as the table does not exists.

Any Advice?

Views

484

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
New Here ,
Oct 17, 2013 Oct 17, 2013

Copy link to clipboard

Copied

LATEST

Also experiencing this issue, any help would be greatly appreciated!

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