Re: Project 2000 to mySQL Database

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

From: JackD (momokuri_at_gmail)
Date: 10/21/04 

Date: Thu, 21 Oct 2004 10:11:57 -0700

Any ODBC driver "should" work, but the reality is that some of them don't
work.
I recall people having trouble with the Oracle ODBC driver and having to use
the MS supplied Oracle ODBC driver.
It would not be surprising to see that the mySQL driver does not work
perfectly with Project. It is not a supported configuration. Of course it
may be that the driver is fine, but that Project doesn't work with that
driver right, but in any case the end result is the same. 

-- 
-Jack  ... For project information and macro examples visit
http://masamiki.com/project
.
"Rod Gill" <rodsngtrap@hotmail.com> wrote in message
news:eApegw0tEHA.3016@TK2MSFTNGP12.phx.gbl...
> Hi,
>
> Have you got the latest ODBC driver for mysql? if not try upgrading it.
Any
> ODBC database should work.
>
> -- 
> For VBA posts, please use the public.project.developer group.
> For any version of Project use public.project
> For any version of Project Server use public. project.server
>
> Rod Gill
> Project MVP
> For Microsoft Project companion projects, best practices and Project VBA
> development services
> visit www.project-systems.co.nz/
> Email rodg AT project-systems DOT co DOT nz
> "JackD" <momokuri@gmail> wrote in message
> news:eGn5jHwtEHA.1336@tk2msftngp13.phx.gbl...
> >I think that the Readme file that comes with project describes the system
> > requirements.
> > I think that Project 2000 could read and write to SQL server 7 database,
> > but
> > I don't think version 7 is available anymore. You are safe going with
SQL
> > Server 2000. The standard version would be fine, and of course the
latest
> > service packs.
> >
> > -- 
> > -Jack  ... For project information and macro examples visit
> > http://masamiki.com/project
> >
> > .
> > "Sue" <anonymous@discussions.microsoft.com> wrote in message
> > news:1ac601c4b6e4$19e25ac0$a501280a@phx.gbl...
> >> Thank you very much.  This is precicely what I expected
> >> to hear, but haven't been able to obtain any other
> >> evidence that mySQL was the problem.
> >>
> >> Now for my next concern.  How do I determine what version
> >> of SQL Server I should obtain?  What are the main
> >> deciding factors I need to consider?
> >>
> >> Sue
> >> >-----Original Message-----
> >> >mySQL is not a supported format for saving Project.
> >> >Using SQL Server is a supported configuration and it
> >> should work.
> >> >If the problem is in the mySQL database, then upgrading
> >> project will not
> >> >help.
> >> >-- 
> >> >-Jack  ... For project information and macro examples
> >> visit
> >> >http://masamiki.com/project
> >> >
> >> >..
> >> >"Sue" <Sue@discussions.microsoft.com> wrote in message
> >> >news:0DDD73BE-C6BF-4A7E-869C-
> >> 8F30E984328A@microsoft.com...
> >> >> We are attempting to deploy Project 2000 saved to a
> >> mySQL database.
> >> >> Previously, we have had great success using MS
> >> Access.  Almost everything
> >> >> works wonderfully, except that when I have an actual
> >> start, a % complete,
> >> >and
> >> >> a Finish No Earlier Than constraint, then save the
> >> project to mySQL, close
> >> >> the project and reopen, the % complete field reverts
> >> back to 0.  This
> >> >occurs
> >> >> whether I update the task manually thru MSP
> >> application or indirectly thru
> >> >> the database.  I can do either of these successfully
> >> when saving to an
> >> >Access
> >> >> database, so I suspect that the issue is with mySQL.
> >> So the question
> >> >is...
> >> >> is this a known issue?  Can I solve the problem by
> >> upgrading MS Project?
> >> >Or
> >> >> can I solve the problem by using SQL Server instead of
> >> mySQL?  Or is there
> >> >> something I just need to do in configuration of ODBC
> >> to make it work
> >> >> correctly?
> >> >>
> >> >> I have additional information of things that work
> >> correctly.  So far, this
> >> >> is the only calculation/save problem we have
> >> encountered.
> >> >>
> >> >> Thank you for whatever advice or assistance you can
> >> give me.
> >> >>
> >> >> Sue
> >> >
> >> >
> >> >.
> >> >
> >
> >
>
>

Relevant Pages

  • Re: Slow queries when joining local to SQL Server tables
    ... I wonder if the SQL Server database statistics are correct for that table? ... create a saved query, and try it again. ... What version of SQL Server and which ODBC driver? ...
    (microsoft.public.access.queries)
  • Re: Bizarre error with no error information.
    ... My requirements wanted me to use the ODBC driver. ... The system has called a custom component and that component has failed ... Then my app logs: ... What version of MySQL ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: mySQL Connection String
    ... >>I use mySQL but can connect. ... >You say you can't connect to a MySQL database using the ODBC driver ... ODBC Driver for MySQL ...
    (microsoft.public.inetserver.asp.db)
  • Re: problem when connect to database.
    ... ..NET driver? ... Localhost is correct for MySQL, when it runs on the local machine. ... installed an ODBC driver which has the name you told the ADODB. ... problem when connect to database. ...
    (microsoft.public.vb.database.ado)
  • Re: accessing mySQL database with Java
    ... You're loading the ODBC driver and attempting to connect to an ... ODBC-style database URL, yet your subject line says that you're trying ... because MySQL and ODBC ...
    (comp.lang.java.databases)