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

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

roofinAsked:
Who is Participating?
 
mo1oneCommented:
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
 
roofinAuthor Commented:
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
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.

All Courses

From novice to tech pro — start learning today.