Improve company productivity with a Business Account.Sign Up

x
?
Solved

Access to the ADO.net Managed Provider 'OleDbFactory' was denied in the data source with ID 'VaterDB' because of security settings

Posted on 2010-09-16
2
Medium Priority
?
358 Views
Last Modified: 2012-05-10
Hi,

I am trying to use a SQLDataSource in WSS 2.0 to produce a dropdown list form a table in SQLExpress and get the following error.

Access to the ADO.net Managed Provider 'OleDbFactory' was denied in the data source with ID 'VaterDB' because of security settings

Both Sharepoint and SQL Express reside on our SBS 2003 server.

I have attached the code for the call to the database.


<asp:DropDownList runat="server" id="DropDownList1" DataValueField="EmployeeID" DataTextField="Fullname" DataSourceID="Database">
	</asp:DropDownList>
	<asp:SqlDataSource runat="server" ID="Database" ProviderName="System.Data.OleDb" ConnectionString="Provider=SQLOLEDB;Data Source=Server\SQLEXPRESS;Persist Security Info=True;Password=boss;User ID=sharepoint;Initial Catalog=Database" SelectCommand="SELECT [Fullname], [EmployeeID] FROM [qryFullName]">
	</asp:SqlDataSource>

Open in new window

0
Comment
Question by:roofin
2 Comments
 
LVL 5

Accepted Solution

by:
mo1one earned 2000 total points
ID: 33767963
You might want to check the "SafeControl" entries in web.config for the SharePoint site.
Add safecontrol entry for OleDb provider and that might help.
0
 

Author Comment

by:roofin
ID: 33775819
Hi mo1one,

I have changed my web.config so the Trust Level = "Full" and his has worked.
Thanks for your reply, I used this to help find the solution.

Cheers

Roofin
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

A while back, I ran into a situation where I was trying to use the calculated columns feature in SharePoint 2013 to do some simple math using values in two lists. Between certain data types not being accessible, and also with trying to make a one to…
I tried to use the SharePoint app to Import a Spreadsheet and import an Excel sheet into a Team site made in SharePoint 2016. But that just resulted in getting an error message 'Unknown Error'...
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Watch the video of Kernel Migrator for SharePoint, which demonstrate the process easily of migration from SharePoint to SharePoint, OneDrive for Business & Google Drive servers, Public Folder to SharePoint, File Server to SharePoint. The tool has va…

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question