CA SSO SQL Server Wire Protocol

Document ID : KB000032759
Last Modified Date : 14/02/2018
Show Technical Document Details

Summary

 When configuring an ODBC Data Source on a UNIX OS to connect to an MS SQL Data Source, the 'sqlserverwire.ini' data source template is used to configure the  'system_odbc.ini' file.  The template files are located in  <Siteminder_home>/db. 

The 'sqlserverwire.ini' data source template is a basic template.  

Example:

[ODBC Data Sources]
Siteminder Data Source=DataDirect 7.1 SQL Server Wire Protocol

[SiteMinder Data Source]
Driver=/opt/CA/siteminder/odbc/lib/NSsqls27.so
Description=DataDirect 7.1 SQL Server Wire Protocol
Database=Siteminder Data
Address=myhost, 1433
QuotedId=No
AnsiNPW=No
DMCleanup=2

 

The sample Data Source information includes the basic attributes necessary to establish a connection to the database.  Any additional features or settings supported by the ODBC server would require that the appropriate attribute be manually added to the Data Source.

Solution:

This is a list of all of the available Data Source attributes on the SQL Wire Protocol driver for MS SQL Server.


Driver=C:\\Program Files (x86)\\CA\\siteminder\\bin\\NSSQLS27.DLL
Description=
Database"=
PortNumber=
LogonID=
HostName=
WorkStationID=
Language=
ApplicationName=
PacketSize=-1
XMLDescribeType=-10
LoginTimeout=15
QueryTimeout=0
AnsiNPW=1
ApplicationUsingThreads=1
EnableQuotedIdentifiers=0
FetchTSWTZasTimestamp=0
FetchTWFSasTime=1
InitializationString=
AuthenticationMethod=1
GSSClient=native
EncryptionMethod=0
CryptoProtocolVersion=
TrustStore=
TrustStorePassword=
HostNameInCertificate=
ValidateServerCertificate=1
SnapshotSerializable=0
ReportCodepageConversionErrors=0
LoadBalancing=0
ConnectionRetryCount=0
ConnectionRetryDelay=3
AlternateServers=
AlwaysReportTriggerResults=0
FailoverMode=0
FailoverGranularity=0
FailoverPreconnect=0
Pooling=0
ConnectionReset=0
MaxPoolSize=100
MinPoolSize=0
LoadBalanceTimeout=0
EnableBulkLoad=0
BulkLoadFieldDelimiter=
BulkLoadRecordDelimiter=
BulkBinaryThreshold=32
BulkCharacterThreshold=-1
BulkLoadThreshold=2
BulkLoadBatchSize=1024
BulkLoadOptions=2
ExtendedOptions=

NOTE: The attributes in the example (above) reflect the hardcoded, default values.  Adding the attribute and modifying the value will override the default value with the user-designated value.