SqlSetLUser%

Sets the login ID in the SQL Server login record.

Syntax

SqlSetLUser% ( loginrec%, loginid$ )

where

loginrec% ( )

Is a login record. The value of loginrec% is returned by SqlLogin%.

loginid$

Is the login ID sent to SQL Server. The string can have as many as 30 characters.

Returns

SUCCEED (1) or FAIL (0).

Remarks

SQL Server uses the loginrec% parameter you set with SqlSetLUser% to determine who is attempting a connection. For SqlSetLUser% to have any effect, it must be called before SqlOpen%. You must provide a login ID to establish a SQL Server connection. The SQL Server login IDs are defined in the syslogins table in the master database.

See Also

SqlLogin%, SqlOpen%, SqlSetLApp%, SqlSetLHost%, SqlSetLPwd%