Zembian

Problem

Using the following tools Visual Web Developer Express 2008 and Sql Server Express 2008, when inserting a new row into my test User table I got the following error :

"SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM"

My table definition has 2 columns 

Name:DateAdded  Type : datetime Allow Nulls : No Default Value : getdate()
Name:DateTimeStamp  Type : datetime Allow Nulls : No

Solution

My LINQ insert statement set

DateTimeStamp = DateandTime.Now

and assumed that SQL Server Express 2008 would handle the DateAdded column for me.

Looking at the debug I could see DateTimeStamp was set correctly and DateAdded was empty, still on the assumption that SQL Server Express was taking care of things for me.

What fixed this issue for me was going back to my .dbml diagram, selecting the definition of DateAdded and setting the Auto Generated Value property to True.

I hit the following error when trying to debug a Visual Web Developer Express 2008 project.

Unable to Start Debugging on the Web Server. The web server could not find the requested resource.

I did not find a create deal of help but UrlScan seemed like a good place to start. After a download, install and uninstall, I noticed UrlFilter in Add/Remove Program. Once UrlFilter was uninstalled the debugging started with no problems.

Problem 

On a previous Windows XP SP2 build VWD Express 2008 would crash when I selected the new split view.

Solution 

This post referred to a problem with Office 2000 and although I am running Office 2003, it is not 2007 which seemed to be the key.

Compatibility problem between VS 2008 and Office 2000 and how to fix it

I checked out my path environment variable and did not have any references to Office 2003.

Just to see what would happen I added the follow :

C:Program Files\Microsoft Web Designer Tools\VWD

as the first item in the path variable (Note : Default install path). One reboot later and the split view was working. Therefore it did seem to be a problem with the version of fpcutl.dll Visual Web Developer Express was using.

Since encountering this issue I recently had machine reinstall, same Windows XP SP 2, same Office 2003 and installed VWD Express 2008. This time no there were no problems at all. Still it is worth trying the path changed if a reinstall is not available to you.