Solved

MS Project connection to SQL Server

Posted on 2009-04-14
2
690 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

Microsoft has released remote PowerShell capabilities to all commercial Office 365 customers. So you can be controlled via PowerShell and not from the Office 365 admin center Download Windows PowerShell Module for Lync Online http://www.micros…
Learn how ViaSat reduced average response times for IT incidents from 10 minutes to 30 seconds.
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…

622 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