Solved

MS Project connection to SQL Server

Posted on 2009-04-14
2
628 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 Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Join & Write a Comment

When you are trying to access the server, have you ever encountered "The terminal server has exceeded the maximum number of allowed connection" error?  or "The user is attempting to log on to a Terminal Server in Remote Administration mode, but the …
Experts-Exchange users below are the steps you can follow to upgrade your Lync server to latest CU's or cumulative updates. Note: Perform it during non-production hours.   Step 1: Backup your lync and SQL server database. Follow below article: h…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

757 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now