Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

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
?
355 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
[X]
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
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

How Blockchain Is Impacting Every Industry

Blockchain expert Alex Tapscott talks to Acronis VP Frank Jablonski about this revolutionary technology and how it's making inroads into other industries and facets of everyday life.

Question has a verified solution.

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

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
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…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

705 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