Can I use ADO to open a connection to a shared Excel (Office 365) workbook that resides on SharePoint. I do not want to checkout the work book as Other people are storing information on it.
I think I'm almost there. Except the update is inserting into sharepoint. Using Microsoft.ACE.OLEDB.12.0;WSS;IMEX=0. See code below. Situation: I'm refreshing in an excel table from a power query a Sharepoint list (Sharepoint server 2016).
How to Connect SharePoint Online List from VB.NET 2015 Desktop Application? How to View List Data / Update List Data / Delete List Data
Hi, Have anyone connect to Microsoft Dynamics 365 Online using OLEDB? If so what is the parameters. Thank you, Cornelio
Hi, I've got a weird one. I'm new to Sharepoint and connection strings, so please bear with me. I'm connecting an Excel Spreadsheet to a Sharepoint list for RW access.
Hi,I have developed an application using Visual Studio 2008 on C# for stand-alone device, working under Windows Embedded Compact 7. Application work with SQLCompact 3.5 . using System; using System.Linq;
web.config connection string to SQL named instance on cluster works for some time and suddenly stops working. I do the stops start of app pool and it is working again, but after some time (of inactivity) it stops working!!!
I am using Visual Studio 2008, and I am able to query a SharePoint List successfully. How ever now I need to query two lists with a LEFT JOIN sql command.
I have an issue in SharePoint 2013 deployment I have two SharePoint servers connected to the same database. while i have another back up database which is always synchronized
Hi All, I am trying a Tricky one here, Request your help on the same. I have access 2007 Data base, Present in Share point. I have a Excel macro which Interacts with Access Database.
Hello, I need help resolving a small issue when i use a OleDb connection string. I am trying to create a string that will connect to a SharePoint list.
I am trying to connect to a Netezza database from SharePoint 2010 using the "MS Framework for OLEDB providers" in SharePoint Designer and Netezza's OLEDB provider.
I have some code that works for other folks but not for the SharePoint site I am trying to connect to. When I ran my code on my SharePoint, I am unable to find the List object. I thought at first that
Hello world! I am digging myself into the topic of database connections and unfortunately I am stuck. Problem: On a sharpoint webserver I have two files: source.xlsx and analysis.xlsx. The source
Hi Frndz, i need some help. I have a aspx page which needs to be coonected to MS Access DB and fetch the records in SharepointServer. what command should i use to connect to a MS Access DB in Share