Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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
347 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 500 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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

789 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