• Camelot .NET Connector for Microsoft SharePoint

    • Standard

      Server=myServerAddress;Database=mySite;Domain=myDomain;User=myUsername;
      Password
      =myPassword;

      NTLM is default authentication method. Domain and Database are optional parameters.

      SharePoint
    • Using SSL encryption

      Server=myServerAddress;Database=mySite;Domain=myDomain;User=myUsername;
      Password
      =myPassword;SSL=True;

      Always use SSL, deny connection if server does not support SSL or certificate is invalid.

      SharePoint
    • Specifying Office365 authentication

      Server=myServerAddress;Database=mySite;User=myUsername;Password=myPassword;
      Authentication
      =365;

      Connect to Office365 (SharePoint Online) using token based authentication.

      SharePoint
    • Specifying Default authentication

      Server=myServerAddress;Database=mySite;Authentication=Default;

      Connect to server using default authentication, meaning the authenticated user under which the application is running or is impersonated.

      SharePoint

    Problems connecting?   Get answer in the SharePoint Q & A forum →

  • Microsoft ACE OLEDB 12.0

    • Read, update and delete

      Provider=Microsoft.ACE.OLEDB.12.0;WSS;IMEX=2;RetrieveIds=Yes;
      DATABASE
      =http://mysharepointsite.com/documents/;
      LIST
      ={5999B8A0-0C2F-4D4D-9C5A-D7B146E49698};

      The keyword "Database" specifies the SharePoint URL

      The keyword "List" specifies the GUID value for the desired SharePoint list (list=table)

      Query without specifying table names. Ie use "SELECT FROM table" or "SELECT FROM list" (same result from both).

      Read more about Finding the Id (Guid) for a SharePoint List.

      SharePoint
    • Read only

      Provider=Microsoft.ACE.OLEDB.12.0;WSS;IMEX=1;RetrieveIds=Yes;
      DATABASE
      =http://mysharepointsite.com/documents/;
      LIST
      ={5999B8A0-0C2F-4D4D-9C5A-D7B146E49698};
      SharePoint
    • Write

      Provider=Microsoft.ACE.OLEDB.12.0;WSS;IMEX=0;RetrieveIds=Yes;
      DATABASE
      =http://mysharepointsite.com/documents/;
      LIST
      ={5999B8A0-0C2F-4D4D-9C5A-D7B146E49698};

      Use different SharePoint list connections for read (IMEX=2) and writes (IMEX=0), do not mix them.

      SharePoint
  • RSSBus ADO.NET Provider for SharePoint

    • Standard

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

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

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

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

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

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

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

      URL=http://sharepointServerName/;Auth Cookie=authenticationCookieName;
      SharePoint
    • 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;
      SharePoint
    • 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.

      SharePoint
    • 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.

      SharePoint
    • Use columns display names instead of API names

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

      URL=http://sharepointServerName/;User=myUsername;Password=myPassword;
      Cache Location
      =c:\cacheData.db;
      SharePoint
    • 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]".

      SharePoint
    • 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 →

      SharePoint
    • 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.

      SharePoint
    • 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 >>>

      SharePoint
    • Connect through a firewall

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

      URL=http://sharepointServerName/;User=myUsername;Password=myPassword;
      Firewall Server
      =fireWallIPorDNSname;Firewall User=fwUserName;
      Firewall Password
      =fwPassword;Firewall Port=1234;
      SharePoint
    • 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.

      SharePoint
    • 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.

      SharePoint
  • .NET Framework Data Provider for OLE DB

    • Use an OLE DB provider from .NET

      Provider=any oledb provider's name;OledbKey1=someValue;OledbKey2=someValue;

      See the respective OLEDB provider's connection strings options. The .net OleDbConnection will just pass on the connection string to the specified OLEDB provider. Read more here.

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.