I am trying to create a simple timesheet in Sharepoint using SQL to store and retreive the data for reportint purposes.
I am using Sharepoint Designer to create the webapges for our Sharepoint 2.0 site which resides on a SBS 2003 server. I have created a subsite where I would like our employees to go to and enter their timesheets and for the managers to get reports from.
I have run into a problem when trying to use a dropdownlist and SQLDataSource for which I have attached the code for. The error i am getting when trying to access the page is -
Could not instantiate control asp:SqlDataSource
Web Parts Maintenance Page: If you have permission, you can use this page to temporarily disable Web Parts or remove personal settings. For more information, contact your site administrator.
Troubleshoot issues with Windows SharePoint Services.
Any help with this problem would be great.
<asp:DropDownList runat="server" id="DropDownList1" DataValueField="EmployeeID" DataTextField="Fullname" DataSourceID="VaterDB">
<asp:SqlDataSource runat="server" ID="DATABASE" ProviderName="System.Data.OleDb" ConnectionString="Provider=SQLOLEDB;Data Source=SERVER\SQLEXPRESS;Integrated Security=SSPI;Initial Catalog=DATABASE" SelectCommand="SELECT [Fullname], [EmployeeID] FROM [qryFullName]">