password encryption with ODBC

[Eliezer]

I would like to use the ODBC methof for authentication, and I noticed that in the sample users that are included in the trial, their passwords are encrypted. I would like to know if I need my passwords in my database to be encryped to use with firstspot, and if yes how would I do it using the STANDARD edition of firstspot?

[alan]

You need to use the program encrypt_pwd.exe to encrypt the password first before inserting to the database table.

Alternatively, you can use Password Offloading (only available in Advanced Edition) to change the password encryption method.
_________________
~ Patronsoft Limited ~

[Eliezer]

Am I required to use encryption, or can I use firstspot without encrypting the passwords.

[alan]

By default, FirstSpot password is encrypted. If you want to change the format of storing the password (e.g. clear password), you need to use the Password Offloading feature.
_________________
~ Patronsoft Limited ~

[Eliezer]

We understand how to generate a encrypted password using the command prompt (encryprt_pwd).

How could we incorportate this into a Microsoft SQL Server Stored Procedue that would automatically encrypt all of our password to the required encrypted format?

In other words, is there sample code available as to how to call the Encrypt_PWD.exe file from a stored procedure, passing back the encrypted key to update a table with this information.

Thanks.

[alan]

You should encrypt the password first in command prompt, grab output and then insert the password in the SQL server.

I guess you can do it in Stored Procedure by shelling out. Still, it is a bit more natural for me to ecncrypt the password in the command prompt first before touching SQL.
_________________
~ Patronsoft Limited ~