Proxy server
- Last Updated: July 30, 2025
- 2 minute read
- DataDirect Connectors
- ODBC
- Microsoft SharePoint 8.0
- Documentation
This string includes the options you may need to connect through a proxy server with OAuth 2.0 refresh token grant authentication.
DRIVER=DataDirect 8.0 Microsoft SharePoint;ServiceURL=serviceurl;
ProxyHost=proxy_host;ProxyPassword=proxy_password;ProxyPort=proxy_port;
ProxyUser=proxy_user;ClientID=client_id;ClientSecret=client_secret;
TokenURI=token_uri;RefreshToken=refresh_token;[attribute=value[;...]];
where:
- serviceurl
- specifies the URL of a SharePoint site (or "site collection"). For example, https://mycorp.sharepoint.com/sites/marketing/global. The URL must include the base URL (https://mycorp.sharepoint.com/), as well as the path to the site (marketing/global). The driver uses the base URL to infer an OData endpoint, and the site path is used to locate the site that will be accessed.
- proxy_host
- specifies the proxy server to use for the first connection.
- proxy_password
- specifies the password needed to connect to a proxy server for the first connection.
- proxy_port
- specifies the port number where the proxy server is listening for
requests for the first connection. The default is
0.
- proxy_user
- specifies the user name needed to connect to a proxy server for the first connection.
- client_id
- specifies the client ID key for your application when authenticating with OAuth 2.0.
- client_secret
- specifies the client secret for your application when authenticating with OAuth 2.0.
- token_uri
- specifies the endpoint used to exchange authentication credentials for access tokens when OAuth 2.0 authentication is enabled.
- refresh_token
- specifies the refresh token used to either request a new access
token or renew an expired access token..
Important: The refresh token is a confidential value used to authenticate to the server. To prevent unauthorized access, this value must be securely maintained.
- attribute=value
- specifies connection option settings. Multiple options are separated by a semi-colon.
The following example connection string includes the options required for using a proxy server with OAuth 2.0 authentication.
DRIVER=DataDirect 8.0 Microsoft SharePoint;
ServiceURL=https://mycorp.sharepoint.com/sites/marketing/global;
ProxyHost=pserver;ProxyPassword=secret;ProxyPort=808;ProxyUser=jsmith;
ClientID=2946f-6789-25gh-gd8g-44t1;ClientSecret=16a3=bED/HfR8s=//TuV+WZabcd;
TokenURI=https://login.microsoftonline.com/common/oauth2/v2.0/token;
RefreshToken=12a3=bCD/EfGh4Ijk+Lgd8g-44tk3c527831;