next »

[Phillipe Calmet Williams]

Hi there.

I've just changed my DB from Access to MSSQL, and now i cannot add any page or post.

The error is:
COM Error Number     -2147217913 (0x80040E07)
File Name     /add_page.asp
Line Number     121
Brief Description     Conversion failed when converting date and/or time from character string.

It seems to be a problem with the date format or something, but i cannot find a way to fix it.

I will appreciate any help. 

[Phillipe Calmet Williams]

O.K.. seems like i was able to fix it 

The problem was that all the "datetime" columns in the tables of the DB were using the "Now()" function to get the current date and time. I changed it to "GetDate()" and it is working now.