Microsoft KB Archive/840702

= The file does not save and you receive an error message when you try to save a Microsoft Project 2000 file to a Microsoft Project Server 2002 database =

Article ID: 840702

Article Last Modified on 1/5/2007

-

APPLIES TO


 * Microsoft Project Server 2002
 * Microsoft Project 2000 Standard Edition

-



SYMPTOMS
When you try to save a project in Microsoft Project 2000 to a Microsoft Project Server 2002 database with an Open Database Connectivity (ODBC) Data Source Name (DSN) that contains resource assignments, you receive the following error message and the file does not save:

[Microsoft][ODBC SQL Server Driver][SQL Server]Disallowed implicit conversion from data type datetime to date type int, table 'ProjectServer.dbo.MSP_ASSIGNMENT', column 'ASSN_ENTSUMPROJID' use the CONVERT function to run this query.



CAUSE
This issue occurs because the Microsoft Project Server 2002 database is built to contain Enterprise Projects and conflicts with the Microsoft Project 2000 database schema.



WORKAROUND
To work around this issue, follow these steps:
 * 1) Start Microsoft SQL Enterprise manager.

To do this, click Start, point to All Programs, point to Microsoft SQL Server, and then click Enterprise Manager.
 * 1) Expand Microsoft SQL Server.
 * 2) Expand SQL Server Group.
 * 3) Expand your server group such as (local).
 * 4) Right-click Databases, and then click New Database.
 * 5) In the Name box on the General tab of the Database Properties dialog box, name your new database, and then click OK.
 * 6) Click Start, point to All Programs, point to Administrative Tools, and then click Data Sources (ODBC).
 * 7) On the System DSN tab, click Add.
 * 8) In the Create New Data Source dialog box, click SQL Server in the list of drivers, and then click Finish.
 * 9) In the Create a New Data Source to SQL Server dialog box, type the name of your data source in the Name box such as PSDSN, type an optional description of your data source in the Description box, type the name of the SQL server where the Microsoft Project Server 2002 database resides in the Server box, and then click Next.
 * 10) Click to select the SQL Server Authentication check box.
 * 11) Type a valid user account and password, and then click Next.
 * 12) Change the default database to the database that you just created, and then click Next.
 * 13) Click Finish.
 * 14) Click Test Connection.
 * 15) After the connection has tested successfully, click OK two times.
 * 16) If you want both Microsoft Project 2002 and Microsoft Project 2000 files to coexist in this database, use your new DSN to save a Microsoft Project 2002 file first, and then to save a Microsoft Project 2000 file.

