NTLM

This string includes the options used to connect with NTLM authentication.

Note: The strings demonstrated in this section use the DSN-less format. For additional formats, see Using a connection string.

DRIVER=DataDirect 8.0 Microsoft Dynamics 365;ServiceURL=serviceurl;
AuthenticationMethod=6;NTLMDomain=domain;User=user_name;
Password=password;[attribute=value[;...]];

where:

serviceurl

specifies the base URL of the Dynamics 365 instance to which you want to issue requests. For example, http://myonpreminstance.sso3.dynamics365.net/api/data/v9.1/.

domain

specifies the NTLM domain used for NTLM authentication.

user_name

specifies the user name that is used to connect to the service.

password

specifies the password for the user connecting to the service.

attribute=value

specifies connection option settings. Multiple option attributes are separated by a semi-colon.

Note: The User and Password options are not required to be stored in the connection string. They can also be sent separately by the application using the SQLConnect ODBC API. For SQLDriverConnect and SQLBrowseConnect, they will need to be specified in the connection string.

Note: The following example connection string includes the options required for connecting with NTLM authentication:

DRIVER=DataDirect 8.0 Microsoft Dynamics 365;ServiceURL=http://myonpreminstance.sso3.dynamics365.net/api/data/v9.1;
AuthenticationMethod=6;NTLMDomain=sso3;User=jsmith;Password=secret;