Error Converting Access 2007 DB: error 380
Posted: Fri Apr 04, 2008 6:27 pm
I am receiving an error in function 'cmdFinish_Click', error: 380 Reason: Invalid property value ......
in regards to converting an Access 2007 DB on the first create table. All original table fields are simple Text (VARCHAR(1)), with one auto_increment integer not null record ID. I cannot read the rest of the message in the scroll window because the program aborts upon clicking the OK button in the error dialog box, and the clipboard is empty as well. Is there documentation referring to any limitations or constraints on Access fields, queries, etc. for this DB convert application? Thanks for your help.
Upon removing all tables, except two, to simplify the DB conversion, the SQL generated statements for creating the first table produced the following:
- Creating 'tblAllergy' failed
- SQL: CREATE TABLE `tblAllergy` ( `allergyID` INTEGER NOT NULL AUTO_INCREMENT, `allergyName` VARCHAR(50), INDEX (`allergyID`), PRIMARY KEY (`allergyID`)) TYPE=InnoDB
- Error: -2147217900 (80040E14) [MySQL][ODBC 3.51 Driver][mysqld-6.0.4-alpha-community]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=InnoDB' at line 1
Is this an issue with MySQL versions (use an older version than 6.0.4) or with this particular application-generated SQL statement with the problematic TYPE clause?
in regards to converting an Access 2007 DB on the first create table. All original table fields are simple Text (VARCHAR(1)), with one auto_increment integer not null record ID. I cannot read the rest of the message in the scroll window because the program aborts upon clicking the OK button in the error dialog box, and the clipboard is empty as well. Is there documentation referring to any limitations or constraints on Access fields, queries, etc. for this DB convert application? Thanks for your help.
Upon removing all tables, except two, to simplify the DB conversion, the SQL generated statements for creating the first table produced the following:
- Creating 'tblAllergy' failed
- SQL: CREATE TABLE `tblAllergy` ( `allergyID` INTEGER NOT NULL AUTO_INCREMENT, `allergyName` VARCHAR(50), INDEX (`allergyID`), PRIMARY KEY (`allergyID`)) TYPE=InnoDB
- Error: -2147217900 (80040E14) [MySQL][ODBC 3.51 Driver][mysqld-6.0.4-alpha-community]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=InnoDB' at line 1
Is this an issue with MySQL versions (use an older version than 6.0.4) or with this particular application-generated SQL statement with the problematic TYPE clause?