Re: Project 2000 to mySQL Database
From: Rod Gill (rodsngtrap_at_hotmail.com)
Date: 10/21/04
- Next message: Dave Hansen: "What is MXM file type and how to read it"
- Previous message: JackD: "Re: Packaging macros"
- In reply to: JackD: "Re: Project 2000 to mySQL Database"
- Next in thread: JackD: "Re: Project 2000 to mySQL Database"
- Reply: JackD: "Re: Project 2000 to mySQL Database"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 21 Oct 2004 21:58:23 +1300
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 >> > >> > >> >. >> > > >
- Next message: Dave Hansen: "What is MXM file type and how to read it"
- Previous message: JackD: "Re: Packaging macros"
- In reply to: JackD: "Re: Project 2000 to mySQL Database"
- Next in thread: JackD: "Re: Project 2000 to mySQL Database"
- Reply: JackD: "Re: Project 2000 to mySQL Database"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
