Enabling extended password encryption for ASE ODBC, OLE DB, and ADO.NET

This section describes how to enable extended password encryption for the ASE ODBC, OLE DB, and ADO.NET Drivers and Providers.

The EncryptPassword connection property specifies whether the password is transmitted in encrypted format. In ESD #8, this same property is used to enable asymmetric key encryption, if available. When password encryption is enabled, and the server supports asymmetric key encryption, this format is used instead of the symmetric key encryption. The new EncryptPassword values are:

• 0 – Use plain text password (the default value).

• 1 – Use encrypted password. If it is not supported, return an error message.

• 2 – Use encrypted password. If it is not supported, use plain text password.

Following is an example of how you can specify the use of an encrypted password in the odbc.ini file:

[sampledsn]
Description=Sybase ODBC Data Source
UserID=abc
Password=xyz
Driver=Adaptive Server Enterprise
Server=sampleserver
Port=4100
Database=pubs2
UseCursor=1
EncryptPassword=1

To enable password encryption for a data source in the ODBC Data Source Administrator, check the Encrypt Password checkbox in the Connection tab page when setting up the data source.

To enable password encryption for an OLE DB data source in the Sybase ASE Data Source Administrator, check the Encrypt Password checkbox in the Connection tab page when setting up the data source.