Documentation is wrong for "DSN-free ODBC connection" - parameter PWD

book

Article ID: 238824

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine

Issue/Introduction

The following syntax is specified in the description of a "DSN-free ODBC connection":

SQLDRIVERCONNECT=ODBCVAR=SNNNNNRN,Driver={SQL Server Native Client VERSION};Server=tcp:SRVNAME,PORT;Database=DBNAME;Uid=DBUSER;Pwd=DBPWD

example

[ODBC]
SQLDRIVERCONNECT=ODBCVAR=SNNNNNRN,Driver={SQL Server Native Client 11.0};Server=tcp:dbsrv01,1433;Database=AEV10;Uid=user;Pwd=password

The issue here is that the spelling of the password parameter is wrong. Microsoft specifies that the parameter must be in UPPER CASE: https://docs.microsoft.com/en-us/sql/relational-databases/native-client/applications/using-connection-string-keywords-with-sql-server-native-client?view=sql -server-ver15

 

Cause

Documentation issue

Environment

Release : 12.3.9

Component : AUTOMATION ENGINE

Resolution

The issue has been confirmed to be a bug and will be fixed with an update to the documentation for V12.3 and V21.0 .