Windows

StepsTo encrypt passwords on Windows

  1. Launch the ODBC DataSource Administrator.

  2. Select the data source 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 enable or disable password encryption (which corresponds to EncryptPassword value of 1 and 0, respectively) from the user interface. You can set EncryptPassword to 2 from a connection string.