Connecting MS Project 2003 Pro to a MySQL 5 database with MyODBC

[klhoste]

Hello,

I am trying to connect MS Project Professional 2003 to a MySQL 5
database
but it doesn't work.
First I created an ODBC source when I do "save as" in the File menu,
click
on "ODBC...", create a new data source using "MySQL ODBC 5.1
Driver" (also
tried 3.51 version, no success). The connection seems good but when I
save
the project into the database I get this error message :

[MySQL][ODBC 5.1 Driver][mysqld-5.1.32-community-log]You have an error
in
your SQL syntax; check the manual that corresponds to your MySQL
server
version for the right syntax near 'LONGCHAR , PROJ_OPT_CALC_COSTS
BIT ,
PROJ_PROP_CATEGORY LONGCHAR , PROJ_PR' at line 1

I found the same issue on MySQL Bugs :
http://bugs.mysql.com/bug.php?id=17178 and no solution.

How to fix this bug ? I don't think it comes from the ODBC, but from
the SQL
syntax : the type LONGCHAR doesn't exist.

Thanks by advance,

Regards.

Kevin

 

[Gary L. Chefetz]

Unless there is someone on the board who has MySQL experience, it may be
difficult to get an answer here. Are you certain that you have the correct
ODBC drivers? This can cause problems. It may very well be that the two
applications are incompatible.

--
----------
Gary L. Chefetz, MVP
MSProjectExperts
Project Server Consulting: http://www.msprojectexperts.com
Project Server Training: http://www.projectservertraining.com
Project Server FAQS: http://www.projectserverexperts.com
Project Server Help Blog: http://www.projectserverhelp.com