Skip to main content
Inspiring
January 20, 2021
Question

SQL server data source with ApplicationIntent = ReadOnly

  • January 20, 2021
  • 1 reply
  • 813 views

For a DataSource on the Admin page that is a Microsoft SQL connection, I need to set the ApplicationIntent to ReadOnly.

 

We are running on an old CF10 version (upgrade scheduled for later this year), so is the only way to do this is by entering the Connection String value in the DataSource advanced options?

(and of course only selecting the Read tick boxes below it, turning off the update, insert, etc)

 

(and if it is, any typical examples would be really useful).

    This topic has been closed for replies.

    1 reply

    Community Expert
    January 20, 2021

    Yes, the only way to do this is to specify ApplicationIntent and Initial Catalog in the advanced connection string options.

     

    ApplicationIntent=ReadOnly; Initial Catalog=DBName;

     

    Dave Watts, Eidolon LLC

    Dave Watts, Eidolon LLC
    Inspiring
    February 11, 2021

    I tried this - but it returned error 15316

    (it works fine if I removed ApplicationIntent=ReadOnly from the connection string).

    Our version of ColdFusion is 10,0,18,296330, and I read in another article that you need ColdFusion 10 update 11 for this to work (from https://tracker.adobe.com/#/view/CF-3630461).  Is this true, or is there a workaround I can use.