MSSQL - Need to Code Connection Attributes Manually On Windows With Provider String.

[David Briars]

I have a requirement to read a High Availability MSSQL database.

To read a HA MSSSQL database I need to set the following connection parm:

ApplicationIntent=ReadOnly At the moment here is my code:

ENGINE SQLMSS SET CONNECTION_ATTRIBUTES TESTPCONN XYZPCORPDB02HA.xyznt01.xyz.orgPRDCORPMS/,;'PRDCORP',;'ApplicationIntent=ReadOnly'

 

ENGINE SQLMSS SET DEFAULT_CONNECTION TESTPCONN

 

SQL SQLMSS PREPARE SQLOUT FOR

SELECT TOP 10 CALENDAR_DATE

FROM PRDCORP.CORP.XYZ_CALENDAR;

END

 

TABLE FILE SQLOUT

PRINT *

ENDThis code is giving me an error saying that the attribute value pair'ApplicationIntent=ReadOnly' is part of the database name.

Can someone assist with the syntax for coding for the provider string

I am looking at the 'Adapter Administration' manual, and not seeing how to fix the SET CONNECTION_ATTRIBUTES command.

[Rodrigo Allende]

Hi David.

Thank you for reaching TIBCO Community.

 

A case was opened in our TIBCO Support portal, and the resolution was tosurround the database name is single quotes, then a colon and then the parm to pass surrounded in single quotes.

Your string would look like this:

ENGINE SQLMSS SET CONNECTION_ATTRIBUTES TESTPCONN NFAPCORPDB02HA.nfant01.futures.orgPRDCORPMS/,;'PRDCORP':'ApplicationIntent=ReadOnly'Hope this information answers your inquiry.