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: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]">