Article ID: 165433 - View products that this article applies to.
This article was previously published under Q165433
This article has been archived. It is offered "as is" and will no longer be updated.
When you try to add a row to an SQL Server table using Query Designer you receive the following error if one of the table's field names contains a "-":
ODBC error: 37000 [Microsoft][SQL Server Driver]Line2: Incorrect syntax near '-'
The data tool creates an SQL INSERT statement that doesn't put quotes around field names. The generated INSERT statement would look like:
If data tools generated an INSERT statement that used double quotes around the field name, then the INSERT would work. The following syntax would work:
You can verify this by using the SQL Trace utility that ships with SQL Server 6.5. You can use MS Query to test both INSERT statements.
You can work around this problem in the following ways:
Microsoft has confirmed this to be a bug in the Microsoft products listed at the beginning of this article. This problem was corrected in Visual C++ version 6.0 for Windows.
Steps to Reproduce Behavior