How can I manipulate Sharepoint Lists in VBScript?
in [VbScript]
|
From: Don Reynolds on 27 Jun 2008 15:15 Is there a simple way to read from and write to Sharepoint Lists in VBScript. I tried to create an Access MDB with a link to a Sharepoint List and use ADO to read it, but it gives an error... Error Number: -2147467259 Could not find installable ISAM. Is there a Sharepoint object for VBScript? -- /* Don Reynolds */
From: TDM on 7 Jul 2008 12:32 "Don Reynolds" <DonReynolds(a)discussions.microsoft.com> wrote in message news:D761CE7D-7F4B-44C5-A790-C314E6786602(a)microsoft.com... > Is there a simple way to read from and write to Sharepoint Lists in > VBScript. > > I tried to create an Access MDB with a link to a Sharepoint List and use > ADO > to read it, but it gives an error... > > Error Number: -2147467259 > Could not find installable ISAM. > > Is there a Sharepoint object for VBScript? > > -- > /* Don Reynolds */ I did some goolin a while back to find the same thing you are looking for, and the only lead I got was to install the SharePoint Server 2007 SDK, which I did. But what I found was that there is extensive documentation for ..NET technologies, and none for VBScript. I suppose if you have the time, you can mess around with "converting" the VB.NET stuff to script, but that could wind up being a dead end, so I gave up at that point. If you do find a solution, please post. TDM
From: Don Reynolds on 7 Jul 2008 14:18 I worked with Microsoft on this issue and I was able to use Access 2007 to link to a Sharepoint List and manipulate the link using VBscript. My main problem was the connection string. You have to use the ACE 12 provider and specify some optional undocumented properties. The easiest way to get these properties is within Access 2007. Open the VBA editor (ALT+F11), then go to the Immediate window (CTRL+G) and type "? CurrentProject.Connection" to get a valid connection string. Here's the ADO connection object I use with an ACCDB file in Vbscript: Set adoConCcmsSite = Server.CreateObject("ADODB.Connection") adoConCcmsSite.Open "Provider=Microsoft.ACE.OLEDB.12.0;" & _ "User ID=Admin;" & _ "Mode=Share Deny None;" & _ "Extended Properties="""";" & _ "Jet OLEDB:Database Password="""";" & _ "Jet OLEDB:Engine Type=6;" & _ "Jet OLEDB:Database Locking Mode=1;" & _ "Jet OLEDB:Global Partial Bulk Ops=2;" & _ "Jet OLEDB:Global Bulk Transactions=1;" & _ "Jet OLEDB:New Database Password="""";" & _ "Jet OLEDB:Create System Database=False;" & _ "Jet OLEDB:Encrypt Database=False;" & _ "Jet OLEDB:Don't Copy Locale on Compact=False;" & _ "Jet OLEDB:Compact Without Replica Repair=False;" & _ "Jet OLEDB:SFP=False;" & _ "Jet OLEDB:Support Complex Data=True;" & _ "Data Source=C:\Database\MyDatabase.accdb;" I worked with two teams of high level support (WebDav/SQL Server and Access) and neither could find or provide a list of current options for the provider. This works great for Vbscript, but we are still working on getting it to work from IIS in an ASP page. Microsoft was able to reproduce the problem in house and they are working on it now. -- /* Don Reynolds */ "TDM" wrote: > > "Don Reynolds" <DonReynolds(a)discussions.microsoft.com> wrote in message > news:D761CE7D-7F4B-44C5-A790-C314E6786602(a)microsoft.com... > > Is there a simple way to read from and write to Sharepoint Lists in > > VBScript. > > > > I tried to create an Access MDB with a link to a Sharepoint List and use > > ADO > > to read it, but it gives an error... > > > > Error Number: -2147467259 > > Could not find installable ISAM. > > > > Is there a Sharepoint object for VBScript? > > > > -- > > /* Don Reynolds */ > > I did some goolin a while back to find the > same thing you are looking for, and the only > lead I got was to install the SharePoint Server > 2007 SDK, which I did. But what I found > was that there is extensive documentation for > ..NET technologies, and none for VBScript. > I suppose if you have the time, you can mess > around with "converting" the VB.NET stuff > to script, but that could wind up being a > dead end, so I gave up at that point. > > If you do find a solution, please post. > > TDM > > >
From: TDM on 7 Jul 2008 18:23 "Don Reynolds" <DonReynolds(a)discussions.microsoft.com> wrote in message news:5942C16D-1872-44EF-A84B-3ED5FC2EEF30(a)microsoft.com... >I worked with Microsoft on this issue and I was able to use Access 2007 to > link to a Sharepoint List and manipulate the link using VBscript. > > My main problem was the connection string. You have to use the ACE 12 > provider and specify some optional undocumented properties. The easiest > way > to get these properties is within Access 2007. Open the VBA editor > (ALT+F11), > then go to the Immediate window (CTRL+G) and type "? > CurrentProject.Connection" to get a valid connection string. > > Here's the ADO connection object I use with an ACCDB file in Vbscript: > > Set adoConCcmsSite = Server.CreateObject("ADODB.Connection") > > adoConCcmsSite.Open "Provider=Microsoft.ACE.OLEDB.12.0;" & _ > "User ID=Admin;" & _ > "Mode=Share Deny None;" & _ > "Extended Properties="""";" & _ > "Jet OLEDB:Database Password="""";" & _ > "Jet OLEDB:Engine Type=6;" & _ > "Jet OLEDB:Database Locking Mode=1;" & _ > "Jet OLEDB:Global Partial Bulk Ops=2;" & _ > "Jet OLEDB:Global Bulk Transactions=1;" & _ > "Jet OLEDB:New Database Password="""";" & _ > "Jet OLEDB:Create System Database=False;" & _ > "Jet OLEDB:Encrypt Database=False;" & _ > "Jet OLEDB:Don't Copy Locale on Compact=False;" & _ > "Jet OLEDB:Compact Without Replica Repair=False;" & _ > "Jet OLEDB:SFP=False;" & _ > "Jet OLEDB:Support Complex Data=True;" & _ > "Data Source=C:\Database\MyDatabase.accdb;" > > I worked with two teams of high level support (WebDav/SQL Server and > Access) > and neither could find or provide a list of current options for the > provider. > > This works great for Vbscript, but we are still working on getting it to > work from IIS in an ASP page. Microsoft was able to reproduce the problem > in > house and they are working on it now. > > -- > /* Don Reynolds */ > Thanks for posting ... TDM
|
Pages: 1 Prev: What folder does Outlook 2007 use for scripts? Next: Regular Expression - Subnet |