Saving as ODBC to SQL Server. Project is locked.

[Lee N.]

I'm attempting to save a 2002 Project using the ODBC to to an SQL Server.
I've been working with it for a couple of weeks now and everything was going
fine, until recently.
Something corrupted the file and when it saved it stated there where errors,
and that it would attempt to fix them.

Ever since then I cannot save any Project (even new ones) to the database.
I dropped all the MSP tables and stored procedures and attempted to save
(Brand new , empty file). I still get the error that the new project is
locked (don't see how), even though it is creating the MSP tables as it goes.
It initial acts as if this is the first save to the database (thus creates
the tables), however when it claims the project is locked, it stops creating
the rest of the tables.

I checked MSP_PROJECT and it does say the project is readonly and locked,
however this is expected was doing a save.

I've even wiped the "MSP*" tables and attempted to save using Project 2003
to the same database from a different Client and get the same result.

There has to be a item that I have not deleted!!! Can anyone tell me what
I've missed.

There has to be more than just the MSP tables coming into play.

 

[Rod Gill]

To help decide if its SQL Server data or Project itself causing the problem,
try saving to a .mpd database then try saving to SQL Server again (after
deleting the database again. Let us know the result.

 

[Lee N.]

The project saves fine to anywhere but the one database I had the issue with.
I have successfully saved the project to other Databases on the same server.

As I stated in the first post, I cannot save any Projects to that database.
This database also contains other ERP data that is uneffected.

The last thing I tried was to save the file to a complete empty database to
see what gets created, but as it turns out, only the MSP tables and MSP
Stored procedures I already wiped out are created.

In summary, I have a database on a server with multiple other database, that
I cannot save any project to, regardless of MS Project version 2002 or 2003,
and regardless of client machine that is saving the file. The message I
always get is

"The project is currently locked and cannot be opened.

Either another user is saving or opening the project, or the user has it
locked for exclusive use. Try again later"

This message appears after i wipe out all the MSP tables and MSP Stored
PRoecedures and attempt to save as ODBC.