Jump to content
The ibi Community has moved to a new platform: Please Sign In and choose Forgot Password to continue

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


David Briars

Recommended Posts

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.

Link to comment
Share on other sites

  • 3 weeks later...

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.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
  • Create New...