CData ADO.NET Provider for SharePoint connection strings

Connects to

SharePoint

  • Standard

    URL=http://sharepointServerName/;User=myUsername;Password=myPassword;
  • Show hidden columns

    URL=http://sharepointServerName/;User=myUsername;Password=myPassword;
    Show Hidden Columns
    =True;
  • Accessing "SharePoint Online" / "Office 365" data

    URL=http://sharepointServerName/;User=myUsername;Password=myPassword;
    SharePoint Edition
    =SharePoint Online;
  • Basic authentication method

    URL=http://sharepointServerName/;User=myUsername;Password=myPassword;
    Auth Scheme
    =BASIC;
  • Digest access authentication method

    URL=http://sharepointServerName/;User=myUsername;Password=myPassword;
    Auth Scheme
    =DIGEST;
  • Negotiate authentication method

    URL=http://sharepointServerName/;User=myUsername;Password=myPassword;
    Auth Scheme
    =NEGOTIATE;
  • No authentication method

    URL=http://sharepointServerName/;User=myUsername;Password=myPassword;
    Auth Scheme
    =NONE;
  • Authenticate using an existing authentication cookie

    URL=http://sharepointServerName/;Auth Cookie=authenticationCookieName;
  • Set dataset page size

    Default is 1000 results per page. High page size results in fewer requests, but it may time out.

    URL=http://sharepointServerName/;User=myUsername;Password=myPassword;
    Page Size
    =2000;
  • Accept all SSL certificates (not only certs that the machine trusts)

    URL=https://sharepointServerName/;User=myUsername;Password=myPassword;SSL Cert=*;

    This property can also be used to specify a single SSL certificate to be accepted. Use the value of a full PEM certificate, the path to a file containing the certificate, the public key, the MD5 thumbprint, or the SHA1 thumbprint.

  • Use timeout

    URL=http://sharepointServerName/;User=myUsername;Password=myPassword;Timeout=60;

    If an operation is not complete within the timeout value an exception is thrown.

  • Use columns display names instead of API names

    URL=http://sharepointServerName/;User=myUsername;Password=myPassword;
    Use Display Names
    =true;
  • Specifying a cache file location

    URL=http://sharepointServerName/;User=myUsername;Password=myPassword;
    Cache Location
    =c:\cacheData.db;
  • Caching data automatically

    URL=http://sharepointServerName/;User=myUsername;Password=myPassword;
    Cache Location
    =C:\cache.db;Auto Cache=true;Offline=false;

    To retrieve data from the cache, add "#Cache" to the table name. For example, to query cached data from the "Calendar " table, execute "SELECT * FROM [Calendar#Cache]".

  • Caching data and metadata

    URL=http://sharepointServerName/;User=myUsername;Password=myPassword;
    Cache Location
    =C:\cache.db;Auto Cache=true;Offline=false;Cache Metadata=true;

    The table metadata will also be cached instead of retrieving it from the data source. This improves connection performance. Read more here →

  • Cached data only / Offline mode

    URL=http://sharepointServerName/;User=myUsername;Password=myPassword;
    Offline
    =true;QueryPassthrough=True;Cache Location=C:\cache.db;

    SELECT statements will always retrieve data from the cache. DELETE/UPDATE/INSERT statements is not allowed and will throw an exception.

  • Using an External Cache Provider

    RSSBus drivers have the ability to cache data in a separate database such as SQL Server or MySQL instead of in a local file using the following syntax:

    Cache Provider=Provider.Namespace;
    Cache Connection
    ='Connection String to Cache Database';

    Above is just an example to show how it works. It can be used both with "Auto Cache" and with "Cached Data Only / Offline Mode". Read more about using RSSBus Cache Provider in this article >>>

  • Connect through a firewall

    URL=http://sharepointServerName/;User=myUsername;Password=myPassword;
    Firewall Server
    =fireWallIPorDNSname;Firewall User=fwUserName;
    Firewall Password
    =fwPassword;
  • Specify firewall port

    URL=http://sharepointServerName/;User=myUsername;Password=myPassword;
    Firewall Server
    =fireWallIPorDNSname;Firewall User=fwUserName;
    Firewall Password
    =fwPassword;Firewall Port=1234;
  • Specify firewall type

    URL=http://sharepointServerName/;User=myUsername;Password=myPassword;
    Firewall Server
    =fireWallIPorDNSname;Firewall User=fwUserName;
    Firewall Password
    =fwPassword;Firewall Type=SOCKS5;

    Valid values for "Firewall Type" is TUNNEL, SOCKS4 and SOCKS5. TUNNEL uses port 80 as default. SOCKS4/5 uses port 1080 as default.

  • Setting the Service Principal Name

    URL=http://sharepointServerName/;User=myUsername;Password=myPassword;
    Kerberos SPN
    =myServicePrincipalName;

    Use this when the Service Principal Name on the Kerberos Domain Controller is not the same as the URL that you are authenticating to.

Problems connecting?
Get answer in the SharePoint Q & A forum
.NET Framework Class LibrarySystem.Data.CData.SharePoint.SharePointConnectionInfo and class library downloads

Articlesread all »

Providers

Connect

Articlesread all »

Didn't find your connection string?

Start over from the connection string reference index - or try a search!

In the Q&A forums you can ask your own question and let somebody help you.

The knowledge articles contains solutions and guides.