I created web pages that used an SQL database on my home computer. That DB allowed me to use data types such as 'date' and 'time'. But when I transferred my website to a host server, I discovered that its DB does not accept these types. They only use 'datetime' and 'timestamp'. I changed the tables in the DB on my computer to conform to the same format as on the host computer. I also changed the properties to the new data types with the O/R Developer and re-published the website files to the host server. But I keep getting the same error message that states the server does not support 'date' data types whenever I execute a web page that uses that table column. The C# code states "officetable.StartDate = DateTime.Today;" What should I do? Please help.
View Complete Post