I have just upgraded to enterprise edition and have attempted to run the Create / Check Database Tables command.  I get many SQL errors.  There are many different errors, but this is the first one: 

******* Error:[MySQL][ODBC 3.51 Driver][mysqld-4.1.19-community-nt]BLOB/TEXT column 'email' used in key specification without a key length

The others are less specific.  I checked the tables and while they were created, they had no data in them at all.  So I have reverted to Standard mode until I can understand how to address this problem.  Is it possible to maybe get the raw SQL so I can see what might be causing this?  Or do you have an idea of what it might be?

Thanks for the reply.  I upgraded mysql to the latest stable 5 version and it appears that all tables were created successfully, but I still get a lot of errors and there isn't any data in my tables.  Here's an error I am getting right now.  Any ideas? 

******* Error:[MySQL][ODBC 3.51 Driver][mysqld-5.0.37-community-nt]Can't create table '.\filter\#sql-e50_21.frm' (errno: 121)

It looks like that did it.  It certainly wasn't a seamless transition.  I had to restart the app multiple times before it built the tables based on the text files that I have had in place for a long time.  But it does seem to have done it all correctly and is now working.  Thanks for the assistance and for the continued development of this great product.  Cheers.

hookjd wrote: Thanks for the reply.  I upgraded mysql to the latest stable 5 version and it appears that all tables were created successfully, but I still get a lot of errors and there isn't any data in my tables.  Here's an error I am getting right now.  Any ideas?  ******* Error:[MySQL][ODBC 3.51 Driver][mysqld-5.0.37-community-nt]Can't create table '.\filter\#sql-e50_21.frm' (errno: 121)