problems using ms project with myodbc

Hi!

I'm trying to connect my MS Project 2003 to mysql 4.0.22 server via ODBC to 
avoid using microsoft sql server.

Despite many rumors I've got a ready connection from the first time without 
problems but when saving a project I get a mysql server error message that it 
cannot accept LONGCHAR type while creating new table. I've looked through and 
found out ms access engine started to name MEMO field (that was suitable) as a 
LONGCHAR (not LONGVARCHAR) unfortunately. 

I'm using mysql for years without serious problems but I was always using 
native client in my programs but for now I'm to use ODBC - so I'm a newby once 
again :0)

Any ideas how to solve the problem except for rewriting myodbc driver sure :0)


Alex




-- 
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@xxxxxxxxxxx