I am also getting the 'Microsoft OLE DB Provider for SQL Server' error when I attempt to change my profile.... funny thing is, I think that it did save my changed preferences.
My system stats... Tried it on 3 computers.
1. Win XP Pro - SP1a + current patches
Explorer 6 (packaged with XP)
2 Win 2000 Pro - SP3 + current patches
Explorer 6
3. Win XP Home - SP1a + current patchs
Explorer 5
Here are the exact details below:
Error Type:
Microsoft OLE DB Provider for SQL Server (0x80040E07)
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
/asppg/editProfilePro.asp, line 193
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)
Page:
POST 1197 bytes to /asppg/editProfilePro.asp
POST Data:
fname=BJ&lname=Schneider&bDay=0&bMonth=0&bYear=-1&
[email protected]&emailview=on&h omepage=http%3A%2F%2F&location=Western+PA&ICQ=&Yah oo=&AOL=gqsmurfy69&MSNMsger=&interests=&occupation =N . . .
Time:
Friday, March 26, 2004, 7:18:19 AM