Webforumz.com - View Single Post

fogofogo · Dec 1st, 2005, 14:39

Thanks again.

I've decided to use MySQL database instead of the access database - access seems to be too flakey for this type of remote connection.

I have connected to a mysql database and have experienced a bit of a problem. I can insert and display info ok from the database, however when I try and enter in a date it doesn't seem to work. I believe its because mysql stores the dates as 0000/00/00 and asp does it the other way, 00/00/0000.

Any body know of any scripts or resources that might help me fix this?

Thanks folks.

Dec 1st, 2005, 14:39	#6 (permalink)
fogofogo Junior Member Join Date: Nov 2005 Posts: 18	Re: Database connection Thanks again. I've decided to use MySQL database instead of the access database - access seems to be too flakey for this type of remote connection. I have connected to a mysql database and have experienced a bit of a problem. I can insert and display info ok from the database, however when I try and enter in a date it doesn't seem to work. I believe its because mysql stores the dates as 0000/00/00 and asp does it the other way, 00/00/0000. Any body know of any scripts or resources that might help me fix this? Thanks folks.