New Information - SQL Server 2000 SP3.
Sets the user Microsoft® SQL Server™ 2000 password in the LOGINREC structure.
RETCODE DBSETLPWD (
LPCSTR password );
Is a pointer to a LOGINREC structure, which is passed as a parameter to dbopen. To get one of these pointers, call dblogin.
Security Note Authorization information, including user name and password, is stored in memory in the LOGINREC structure. It is possible that someone accessing a memory dump of the machine running the application could access this information. Take precautions to prevent access to memory output by unauthorized individuals.
Is the SQL Server password that is sent to SQL Server. It must be a null-terminated character string. The maximum length of the string is 30 characters, not including the null-terminating character.
SUCCEED or FAIL.
For DBSETLPWD to have any effect, call it before dbopen.
You do not need to call it if the password is a null value.
Security Note When possible, use DBSETLSECURE to enable Windows authentication rather than using DBSETLUSER and DBSETLPWD to enable SQL Server authentication.