Updated: 2019-05-29
Data Source Initialization OLE DB Property – «remote:auth»
Name:
remote:auth
Type:
VT_BSTR
R/W:
R/W
Default:
EMPTY
IBProvider:
3.34, 5
The name of authentication service, which used by provider’s own client for connection to the server. Allowed the empty value or one value from the following list:
| Value | Description |
| Srp | Authentication with using of login and password. Supported since Firebird v3. |
| Srp224 | Authentication with using of login and password. Supported since Firebird v3.4 and IBProvider v5.5. |
| Srp256 | Authentication with using of login and password. Supported since Firebird v3.4 and IBProvider v5.5. |
| Srp384 | Authentication with using of login and password. Supported since Firebird v3.4 and IBProvider v5.5. |
| Srp512 | Authentication with using of login and password. Supported since Firebird v3.4 and IBProvider v5.5. |
| Legacy_Auth | Authentication with using of login and password. Supported by all versions of Firebird. |
| Win_Sspi | Authentication by Windows (SSPI). |
By default provider selects an authentication service on the basis of values of properies «User ID», «Password», «Integrated Security».
Note that username (User ID) in the SRP-authentication is case sensitive. By default, if not defined explicitly, server transforms the username to upper case. In these cases, when you connect to the server through own client of provider, need define username in upper case — for example, «user id=SYSDBA». Otherwise you get the authentication error.
See also
- Initialization property User ID
- Initialization property Password
- Initialization property Integrated Security
- Initialization property remote:wire_crypt