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


The information in this article applies to:

  • Microsoft Project for Windows 95 4.1
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.
Modification Type:MajorLast Reviewed:11/5/2000
Keywords:kbprb kbusage KB155239
©2002 Microsoft Corporation. All rights reserved.