Connection strings for SharePoint
Providers to use when connecting to SharePoint
Finding this site useful?
-Say "Thanks" to Benjamin Nelson and the other contributing developers!
-Thank you! »
-Say "Thanks" to Benjamin Nelson and the other contributing developers!
-Thank you! »
ACE OLEDB 12.0
Type: OLE DB Provider
Usage: Provider=Microsoft.ACE.OLEDB.12.0
Usage: Provider=Microsoft.ACE.OLEDB.12.0
Manufacturer: Microsoft
Customize string example values »
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).
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
Usage: System.Data.OleDb.OleDbConnection
Manufacturer: Microsoft
More info about this wrapper class library »
More info about this wrapper class library »
Customize string example values »
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};