Connection strings for SharePoint
Providers for SharePoint
Community Forums
Find solutions and post questions regarding connection string related issues.
ACE OLEDB 12.0
Type
OLE DB Provider
Usage Provider=Microsoft.ACE.OLEDB.12.0
Manufacturer Microsoft
Usage Provider=Microsoft.ACE.OLEDB.12.0
Manufacturer Microsoft
Read and write
Provider=Microsoft.ACE.OLEDB.12.0;WSS;IMEX=2;RetrieveIds=Yes; DATABASE=http://pp1webofficelivecom.officelive.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)
Querying without specifying any table name. Ie use "SELECT * FROM table" or "SELECT * FROM list" (same result from booth).
Read only
Provider=Microsoft.ACE.OLEDB.12.0;WSS;IMEX=1;RetrieveIds=Yes; DATABASE=http://pp1webofficelivecom.officelive.com/Documents/;LIST={5999B8A0-0C2F-4D4D-9C5A-D7B146E49698};
.NET Framework Data Provider for OLE DB
Type
.NET Framework Wrapper Class Library
Usage System.Data.OleDb.OleDbConnection
Manufacturer Microsoft
Usage System.Data.OleDb.OleDbConnection
Manufacturer Microsoft
Bridging to ACE OLEDB 12.0
This is just one connection string sample for the wrapping OleDbConnection class that calls the underlying OLEDB provider. See respective OLE DB provider for more connection strings to use with this class.
Provider=Microsoft.ACE.OLEDB.12.0;WSS;IMEX=2;RetrieveIds=Yes; DATABASE=http://pp1webofficelivecom.officelive.com/Documents/;LIST={5999B8A0-0C2F-4D4D-9C5A-D7B146E49698};
Selected Articles