Re: Project deletion from Server

From: Ramki (anonymous_at_discussions.microsoft.com)
Date: 02/10/04 

Date: Tue, 10 Feb 2004 03:16:18 -0800

Hi Nico,

Thanks for the detailed input.
I've tested using your detailed steps.

The project is getting deleted from the Project
professional front. But in the web access it is deleting
only '.published' tag. Same situation.

This is exactly the thing happening in my server right now
even when i try to delete using cleanup option in PWA.

Henec ther must be other ways to delete the project from
preventing disply on web pages.
or doing something to make the clean up functionality to
work properly.

Thanks
Ramki

>-----Original Message-----
>Hi Ramki,
>
>There is another way to delete the project, but this is
quite risky, and i
>am not sure of the precise impact of this step - as
always ensure you have
>decent backups available before making any drastic
changes to your sytem!
>Basically what it entails is creating a ODBC connection
to your project
>server database, connecting to the database directly
using MS Project Pro,
>and deleting the project.
>A) CREATING A NEW ODBC CONNECTION
>1. Click "Start ? Control Panel ? Administrative Tools ?
Data Sources
> (ODBC)".
>2. Click the "System DSN" tab, and click the "Add" button.
>
>3. Select "SQL Server" from the list, and click "Finish"
>
>
>4. On the next screen, in the "Name" field, type in a
name for the
>connection. The name can be anything. If required, type
in a description
>as well, but this is optional. Then type in the server
name in the last
>field. The server name is the name of your SQL Server
that runs the Project
>Server database, and then click the Next button.
>
>
>5. On then next screen accept the defaults, and click the
Next button
>
>6. On the next screen, tick the option "Change the
default database to:",
>and select the Project Server database (normally called
ProjectServer)
>
>
>7. On the next screen, again accept the defaults, and
click Finish.
>
>8. In the next dialog box, click the "Test Data Source"
button, to test the
>connectivity. If the tests are succesful, the following
screen will appear.
>
>
>B) CONNECTING TO THE DATABASE USING THE DSN
>1. Open up Project Professional, and select the "My
Computer" option, and
>click the "Work Offline" button to work offline.
>
>2. Click "File ? Open"
>
>3. Select the "Machine Data Sources" tab, select the
DSN , and click OK.
>
>4. Project will now open up a list of the projects in
your database, and
>when you click the little X at the top right, when a
project is selected it
>deletes the project from the database.
>
>thanks
>
>
>
>--
>Regards,
>Nico Oosthuysen
>Fulcrum IT
>www.fulcrumgroup.co.za
>"Ramki" <anonymous@discussions.microsoft.com> wrote in
message
>news:cfcb01c3eeff$1cd0c120$a001280a@phx.gbl...
>> Hi,
>>
>> I am facing problem while deleting a project using
>> PWA 'clean up server database'. However it proceeds for
>> sometime and hangs. Result is that the
>> version '.published'gets removed while rest of the stuff
>> remains intact.
>>
>> Is there any otherway to comletely delete the project?
>>
>> Thanks
>> Ramki
>>
>>
>
>
>.
>