I have been haveing a hell of a time getting these 2 to work. I've created a very simple form page in Frontpage 03 and want the data to be saved to MySQL DB which I have created. I was able to connect FP to MySQL with no problem with ODBC. Tested conectivity, gave the right permissions for the DB and user, and everything. When I loaded the page up and tested it, I got the confermation page with no errors, but the data was in entered into the DB. I had MySQL Log all querys while doing another test. According to what it said, the user loged in, selected the DB, and the tabel, and then tried to execute "INSERT INTO db_name DEFAULT VALUES". Doesn't look right to me. Does anyone know how I can fix this.

Server OS: Windows 2003
MySQL Server Version 4.1.13
Web Server: IIS 6.0
MySQL ODBC Driver 3.51

Any other info you need let me know. Thx