SharePoint Connection strings - Connectionstring Examples

Connection strings Examples for Microsoft Office SharePoint Server

.NET Framework Data Provider for OLE DB

This is a .NET Class Library from Microsoft. The namespace for this library is System.Data.OleDb.OleDbConnection.

Standard Security:

Provider=Microsoft.ACE.OLEDB.12.0;WSS;IMEX=2;RetrieveIds=Yes; DATABASE=http://sharepointdevserver.connectionstringexamples.com/Documents/;LIST={32427232-3235-22A5-32DF-ACAD3832CA3};

ACE OLEDB 12.0

This is an OLE DB Provider from Microsoft. The usage for this provider is Provider=Microsoft.ACE.OLEDB.12.0.

Read and write:

Provider=Microsoft.ACE.OLEDB.12.0;WSS;IMEX=2;RetrieveIds=Yes; DATABASE=http://sharepointdevserver.connectionstringexamples.com/Documents/;LIST={32427232-3235-22A5-32DF-ACAD3832CA3};

    Keyword database = URL of the sharepoint website
    keyword List = the GUID of the sharepoint list
    keyword List is the same as table.

Read only:

Provider=Microsoft.ACE.OLEDB.12.0;WSS;IMEX=1;RetrieveIds=Yes; DATABASE=http://sharepointdevserver.connectionstringexamples.com/Documents/;LIST={32427232-3235-22A5-32DF-ACAD3832CA3};