To encrypt passwords on Windows
Launch the ODBC DataSource Administrator.
Select the data source you want to use and choose Configure.
Click the Advanced tab.
Select EncryptPassword.
You can use the EncryptPassword connection
property in a call to SQLDriverConnect
.
You 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.