Solved

MS Project connection to SQL Server

Posted on 2009-04-14
2
663 Views
Last Modified: 2013-11-15
I have a SQL Server database running on SBS 2003 using MS Project 2000 tables which I remotely connect to using MS Project 2000.  

What do I have to do to connect using MS Project 2003 and MS Project 2007?  I have MSP 2007 (and MSP 2000 but not MSP 2003), MSP 2007 can't open my MSP 2000 SQL Server projects.
0
Comment
Question by:merdeka
2 Comments
 
LVL 5

Accepted Solution

by:
defi0 earned 500 total points
ID: 24146251
I don't believe Project 2003 and 2007 can connect to a Project 2000 database. That's because Microsoft made radical changes to database-based project sharing with the introduction of Project Server.

0
 
LVL 13

Expert Comment

by:jbfraser
ID: 24148002
defi0 is right that Project 2007 will not be able to open a project from a database that was created by 2000. You need to open the projects with Project 2000, then save as .mpp files.

Project 2003 might be able to read the tables, but I'm not sure. I know that it can save to a database, similar to 2000 and 2002: you need to create a DSN, and "Save As..." then use the ODBC button.

Project 2007 cannot save to a database:
http://office.microsoft.com/en-us/project/HA101691071033.aspx
(I have some vague recollection that this was going to be added as a hotfix or Service Pack but I can't find the reference now.)

Note that there are separate products from Microsoft, called "Project Server 2003" and "Project Server 2007" which save projects to databases and are an entirely different thing than saving from the project plan directly to a database. Project Server includes a web interface (Project Web Access) that allows project resources to enter time and status on tasks to Project Managers and provides sophisticated cross-project reporting options.


James Fraser

0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Back in July, I blogged about how Microsoft's new server pricing model, combined with the end of the Small Business Server package, would result in significant cost increases for many small businesses (see SBS End of Life: Microsoft Punishes Small B…
Introduction: Sometimes when I receive a call from my users to solve their problems it is very difficult for me to found their computer IP address. Even finding their computer Host to provide remote support can be a problem.  So I resorted to Goo…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question