Password encryption on Microsoft Windows

StepsEncrypting passwords on Microsoft Windows

  1. Launch the ODBC DataSource Administrator.

  2. Select the datasource you want to use and choose Configure.

  3. Click the Advanced tab.

  4. Select EncryptPassword.

You can use the EncryptPassword connection property in a call to SQLDriverConnect.

NoteYou can only use the user interface to set EncryptPassword to 0 or 1. To set EncryptPassword to 2, use a connection string.