Re: Connecting MS Project 2003 Pro to a MySQL 5 database with MyOD

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Yes. perhaps in the spirit of MySQL start an open source project to do so?

kevin wrote:
Yes, I've read the file PJDB.HTM which describes the data format.
But it could be better it there was a script file to load SQL directly.

Kevin

"Rob Schneider" wrote:

Have you seen the file projdb.htm which is installed somewhere on your Project installation folder tree?

kevin wrote:
Thank you Jack for this link, it proves that MS Project could work with MySQL.
Now, if I try to load the schema first, it seems to be OK, I can save the project.
But when I reopen it, I get a message about "circular relationship" in some tasks and some information is lost (task finish dates, blank spaces between two tasks...) while the project is still open.
Do you know if there is an "official" SQL schema for this database?

Kevin.

"Jack Dahlgren" wrote:

I do not believe that MySQL is supported by MS Project so you are basically on your own. Looks like it needs some hand tweaking - loading the schema first, setting some parameters.

This appears to be a reasonable starting point:
http://bugs.mysql.com/bug.php?id=17508

-Jack Dahlgren
http://zo-d.com/park-information

"kevin" wrote:

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.

.

Relevant Pages

  • Re: [PHP] Select record by ID
    ... But I dont want to be a php copy/paste newb who has no clue ... Bad Guys know that you are probably using that user_id in an SQL ... The mysql_real_escape_string() part is a function provided by MySQL ... mysql_real_escape_stringtakes the 'Kevin O'Brien' and converts it ...
    (php.general)
  • Re: Error connection Clarion 5.5G and MySQL
    ... I work with Clarion 5.5G and MSACCESS databases. ... I like to change my MSACCESS database to MYSQL 5.0 database, ... when I select a client I blocked this client for security and use a ... Error (You have an error in your SQL syntax: ...
    (comp.lang.clarion)
  • Re: Problem with apostrophe in MySQL
    ... "You have an error in your SQL syntax; ... corresponds to your MySQL server version for the right syntax to use ...
    (alt.php)
  • Re: MAINFRAME SHOP STANDARDS
    ... with a pretty nice drawing tool (I've used it to create database ... from the M/F IDE I generate SQL syntax and do a ... > copy and paste into COBOL source. ... MySQL has some new tools that let you develop the query against your ...
    (comp.lang.cobol)
  • Re: Auslesen, in welchem Feld der Treffer steckt
    ... Als SQL-Fehlermeldung erhalte ich: ... Fehlermeldung=You have an error in your SQL syntax near '(select 01, ... Zweite Variante ist, dass dein String, den du an MySQL sendest vorher schon gefüllt war und du nur erweiterst. ...
    (de.comp.datenbanken.mysql)