I have written a VB reservations program that writes back to a SQL 2008 database. When I write the reservation event back to the data base, I also write the reservation 'end time' back to the database as reservationtime + 4 hours in order to block off the event resource. the program works fine until I try to book an event at8:00 PM or later. When I try to book an event at 8 PM or after the SQL database throws an error, 'System.Data.SqlTypes.SqlTypeException: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM'. I guess this is because the booked event then continues into the next day. I need to be able to block of the time space as reservations are accepted up to 2:00 am. Is there a work around?
NYCRAVEN 0 Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.