Knowledge Base

PRJ41: Save to Database Doesn't Work With MS SQL 6.5

Article ID: 155239

Article Last Modified on 11/5/2000

APPLIES TO

This article was previously published under Q155239

SYMPTOMS

Using the Save to Database function in Microsoft Project causes an error and no data is saved. Also, no tables are created in the database.

"SQL: error [Microsoft] [ODBC SQL SERVER DRIVER] [SQL server] incorrect syntax near the keyword 'work'. State: 37000 Native error code was 156"

CAUSE

The SQL reserved word "Work" is being used as a table field name.

RESOLUTION

To correct this problem, you must upgrade to Microsoft Project for Windows 95 version 4.1a. This upgrade is free to registered users and can be obtained by calling Microsoft Technical Support at (425)-635-7155.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Project for Windows 95 version 4.1. This problem was corrected in Microsoft Project for Windows 95 version 4.1a.

Keywords: kbprb kbusage KB155239


Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.