Connection string in asp connecting to sharepoint list as datasource
-
Hi, i've been trying to create a website in asp that uses a connection to a sharepoint list so i can display the data as i please. here is my latest attempt that still does not work: Set oConn = Server.CreateObject("ADODB.Connection") oConn.Open("Provider=Microsoft.ACE.OLEDB.12.0; User iD=xxxxx; Password=xxxxx; Domain=mydomain; WSS; IMEX=1; RetrieveIds=Yes;DATABASE=http://server/path/; List={a1a1a1a-a1a1aa-a1a1a-a1a1a-a1a1aa1};") SQL = "SELECT * FROM [list]" Set admin = oConn.Execute(SQL) all i keep getting is error in iis log: Cannot_start_your_application._The_workgroup_information_file_is_missing_or_opened_exclusively_by_another_user. Can anyone help?
-
Hi, i've been trying to create a website in asp that uses a connection to a sharepoint list so i can display the data as i please. here is my latest attempt that still does not work: Set oConn = Server.CreateObject("ADODB.Connection") oConn.Open("Provider=Microsoft.ACE.OLEDB.12.0; User iD=xxxxx; Password=xxxxx; Domain=mydomain; WSS; IMEX=1; RetrieveIds=Yes;DATABASE=http://server/path/; List={a1a1a1a-a1a1aa-a1a1a-a1a1a-a1a1aa1};") SQL = "SELECT * FROM [list]" Set admin = oConn.Execute(SQL) all i keep getting is error in iis log: Cannot_start_your_application._The_workgroup_information_file_is_missing_or_opened_exclusively_by_another_user. Can anyone help?
oConn.Open("Provider=Microsoft.ACE.OLEDB.12.0; WSS; IMEX=1; RetrieveIds=Yes;DATABASE=http://server/path/; List={a1a1a1a-a1a1aa-a1a1a-a1a1a-a1a1aa1};") use this connectionstring
-
oConn.Open("Provider=Microsoft.ACE.OLEDB.12.0; WSS; IMEX=1; RetrieveIds=Yes;DATABASE=http://server/path/; List={a1a1a1a-a1a1aa-a1a1a-a1a1a-a1a1aa1};") use this connectionstring