1 Reply Latest reply on Oct 17, 2013 6:31 AM by acline3

    Can cfdbinfo retrieve tables for Linked SQL Servers?

    nazcek

      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?