Whenever I attempt to connect to SQL server, I receive an exception (see below). I have verified that System.Data (Version 2.0.50110.28) exists in the GAC (C:\windows\assembly\GAC_32\System.Data\2.0.0.0__b77a5c561934e089\System.Data.dll)
I've uninstalled, reinstalled, uninstalled again, ran the beta 1 clean-up utility, reinstalled again, and finally repaired the installation and the problem still persists.
Any ideas?
Thanks
-Ken
Exception:
The specified procedure could not be found. (Exception from HRESULT: 0x8007007F)
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Runtime.InteropServices.COMException: The specified procedure could not be found. (Exception from HRESULT: 0x8007007F)
Source Error:
Line 36: </Columns>
Line 37: </asp:GridView>
Line 38: <asp:SqlDataSource ConnectionString="<%$ ConnectionStrings:AppConnectionString1 %>"
Line 39: ID="SqlDataSource1" ProviderName="<%$ ConnectionStrings:AppConnectionString1.ProviderName %>"
Source File: c:\Inetpub\wwwroot\HOCTracker\Default.aspx Line: 38
Stack Trace:
[COMException (0x8007007f): The specified procedure could not be found. (Exception from HRESULT: 0x8007007F)]
[FileLoadException: A procedure imported by 'System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' could not be loaded.]
System.Web.UI.WebControls.SqlDataSource.set_ProviderName(String value) +0
ASP._Default_aspx.__BuildControlSqlDataSource1() in c:\Inetpub\wwwroot\HOCTracker\Default.aspx:38
ASP._Default_aspx.__BuildControlform1() in c:\Inetpub\wwwroot\HOCTracker\Default.aspx:10
ASP._Default_aspx.__BuildControlTree(_Default_aspx __ctrl) in c:\Inetpub\wwwroot\HOCTracker\Default.aspx:1
ASP._Default_aspx.FrameworkInitialize() in c:\WINDOWS\Microsoft.NET\Framework\v2.0.50110\Temporary ASP.NET Files\hoctracker\7721fd8b\17c297d9\kew1f14t.0.cs:0
System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +105
System.Web.UI.Page.ProcessRequest() +12
System.Web.UI.Page.ProcessRequest(HttpContext context) +46
System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +153
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +65
--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50110.28; ASP.NET Version:2.0.50110.28