The driver ensures that either the string "Trusted_Connection=yes" or both the UID and PWD keywords are present. When SQL_DRIVER_NOPROMPT is specified, user authentication keywords must be present with values. If DRIVER is specified, or is the leftmost of the two, and the SQLDriverConnect DriverCompletion parameter value is SQL_DRIVER_NOPROMPT, the SERVER keyword and an appropriate value are required. ODBC states that a driver uses the leftmost of these two keywords and ignores the other if both are specified. Specify either the DRIVER or DSN keywords. SQLDriverConnect must be given a valid WindowHandle when any DriverCompletion value requires (or could require) the display of the driver's connection dialog box. If the value is not set in the connection string and the user makes no assignment in the dialog box, the driver uses the default. If the keyword value is passed in the connection string and the user does not alter the value for the keyword in the dialog box, the SQL Server Native Client ODBC driver uses the value from the connection string. When the SQLDriverConnect DriverCompletion parameter value is SQL_DRIVER_PROMPT, SQL_DRIVER_COMPLETE, or SQL_DRIVER_COMPLETE_REQUIRED, the SQL Server Native Client ODBC driver retrieves keyword values from the displayed dialog box. Several connection-string keywords have default values specified by the SQL Server Native Client ODBC driver.įor a list of the keywords available in the SQL Server Native Client ODBC driver, see Using Connection String Keywords with SQL Server Native Client.įor more information about SQL Server connection attributes and driver default behaviors, see SQLSetConnectAttr.įor a discussion of connection string keywords that are valid for SQL Server Native Client, see Using Connection String Keywords with SQL Server Native Client.
The SQL Server Native Client ODBC driver defines connection attributes that either replace or enhance connection-string keywords.
Applies to: SQL Server (all supported versions) Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW)
0 kommentar(er)
