INCLUDE_DATA

Archive for August, 2008

SQL Server 2008 RTM released!

August 8th, 2008

Not that I think I’m breaking any news here, but SQL Server 2008 has been officially RTM (released to manufacturing).  So far I’ve been very pleased working with SQL Server 2008 and am excited to get my RC0 version updated to an official release.

One thing I stumbled across was a warning users to wait for Visual Studio.NET 2008 SP1 to be released BEFORE upgrading to the RTM version of SQL Server 2008.  This blog post cites compatibility problems if you don’t have SP1 installed before working with the RTM version of SQL. What I’m not sure about is if this applies to people using beta versions of SQL Server 2008 (RC0), Visual Studio 2008 SP1 and .NET Framework v3.5 SP1 like I am.  This uncertainty made me think that it may be best to wait for the final release of SP1 for VS.NET and the 3.5 Framework.

I then came across a nugget here that said:

well….there’s a…ahem…NDA about this topic…but SQL Server 2008 RTM ships with a RTM version of the .NET Framework 3.5 SP1 bits…i’ll let you connect the dots.

I guess it’s time to dig around in the RTM version of SQL 2008 to see if it’s there.  I also wonder if it’s safe to install over top of my RC0 version of if I should remove RC0 before installing the RTM version.  I guess I’ll have to Google more to see what’s required.  I’ll provide updates as I find answers and get upgraded.

**** Update:

According to the release notes the beta SP1 isn’t an acceptable solution.  And since they’re saying SP1 will be officially released next week anyways, it makes sense just to wait for that I think.

What’s wrong with my Linqdatasource? – Method not found!

August 8th, 2008

I’ve been having a very weird problem in Visual Studio 2008 when trying to use the automatic operations for the Linqdatasource (insert, update or delete).  It seems that no matter what I try I get this weird “Method not found” problem.  Unfortunately there doesn’t seem to be a lot of help out on the web about why this may be happening.  I’m starting to think that there may be something goofed up with my 3.5 Framework or Visual Studio 2008.

Here’s the error and a link to the problem I posted out on the ASP.NET forums.  If anybody has come across this weird problem let me know. Unfortunately the 1 person that has replied on the discussion forums hasn’t been much help and offers up only basic suggestions as to why it may not be working, all of which were things that I had already known or tried right off the bat.

System.MissingMethodException: Method not found: ‘System.Object System.Web.UI.WebControls.Parameter.GetValue(System.Object, Boolean)’.

Generated: Mon, 04 Aug 2008 12:40:10 GMT
System.Web.HttpUnhandledException: Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> System.MissingMethodException: Method not found: 'System.Object System.Web.UI.WebControls.Parameter.GetValue(System.Object, Boolean)'.
at System.Web.UI.WebControls.LinqDataSourceView.MergeDictionaries(Object dataObjectType, ParameterCollection reference, IDictionary source, IDictionary destination, IDictionary destinationCopy)
at System.Web.UI.WebControls.LinqDataSourceView.BuildInsertDataObject(Object table, IDictionary values)
at System.Web.UI.WebControls.LinqDataSourceView.ExecuteInsert(IDictionary values)
at System.Web.UI.DataSourceView.Insert(IDictionary values, DataSourceViewOperationCallback callback)
at System.Web.UI.WebControls.FormView.HandleInsert(String commandArg, Boolean causesValidation)
at System.Web.UI.WebControls.FormView.HandleEvent(EventArgs e, Boolean causesValidation, String validationGroup)
at System.Web.UI.WebControls.FormView.OnBubbleEvent(Object source, EventArgs e)
at System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args)
at System.Web.UI.WebControls.FormViewRow.OnBubbleEvent(Object source, EventArgs e)
at System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args)
at System.Web.UI.WebControls.LinkButton.OnCommand(CommandEventArgs e)
at System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument)
at System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
--- End of inner exception stack trace ---
at System.Web.UI.Page.HandleError(Exception e)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest()
at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
at System.Web.UI.Page.ProcessRequest(HttpContext context)
at ASP.sellyourhome_aspx.ProcessRequest(HttpContext context)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

Comments (from previous blog):

Have you installed the beta for Visual Studio 2008 / .NET Framework 3.5

SP 1?? I had the exact same issue on my development box until I

uninstalled the beta and installed the official release at http://www.microsoft.com/downloads/details.aspx?FamilyId=FBEE1648-7106-44A7-9649-6D9F6D58056E&;displaylang=en . Make sure you first run the beta removal tool: http://www.microsoft.com/downloads/details.aspx?FamilyId=A494B0E0-EB07-4FF1-A21C-A4663E456D9D&;displaylang=en