FM Pro Migrator - Access to FMP7 - SQL Parse Error

[PaleRider]

Hello FM fans!

I'm an absolut beginner regarding the field of databases. In the lab were I have started to work we want to migrate our scientific db from Access/Win98 to FMP7/Panther. I came across this nice piece of software called FM Pro Migrator. To test whether this program fits our needs I installed the demo-software (http://www.fmpromigrator.com/downloads/demo_software/FmProMigrator3.46DemoWindows.zip) and followed the instructions for migration on Windows platforms on http://www.fmpromigrator.com/support/fmp...s_to_fmp7.html.

Everthing went well until I came to the creation of the new database table in the FileMaker database and I got stuck with the following error message:

DBD::ODBC::db prepare failed: [DataDirect][ODBC SequeLink driver][ODBC Socket][DataDirect][ODBC FileMaker driver][Filemaker]Parse Error in SQL (SQL-HY000)(DBD:st-prepare/SQLPrepare err=-1) at _create_tabel1.pl line 62.

lines 61-65 from the _create_table1.pl file are (complete file in attachment):

# ----------- send SQL commands to FileMaker

my $fmpro_sth = $fmpro_dbh->prepare("create table $filemaker_table_name (

probenartid DECIMAL null,

probenart VARCHAR(1000000) null

)");

Has anyone an idea what to do about that?

thanks in advance for your ideas

Stefan

_create_table1.txt