Skip to main content
Participant
October 17, 2013
Question

Can cfdbinfo retrieve tables for Linked SQL Servers?

  • October 17, 2013
  • 1 reply
  • 511 views

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?

This topic has been closed for replies.

1 reply

Participant
October 17, 2013

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