Export (0) Print
Expand All

dbsetlpwd

SQL Server 2000

  New Information - SQL Server 2000 SP3.

Sets the user Microsoft® SQL Server™ 2000 password in the LOGINREC structure.

Syntax

RETCODE DBSETLPWD (
PLOGINREC
loginrec,
LPCSTR
password );

Arguments

loginrec

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.

password

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.

Returns

SUCCEED or FAIL.

Remarks

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.

See Also

dblogin

dbsetlhost

dbopen

dbsetluser

dbsetlapp

Show:
© 2014 Microsoft