ID Number: Q77169
1.11 | 1.11 | 1.11
MS-DOS | WINDOWS | OS/2
Summary:
Problem ID: PRSQL9110010
SYMPTOM
Issuing a BCP_INIT statement within a DB-LIBRARY (dblib)
application fails with the following error message:
SQL Server message 101, state 1, severity 15
Incorrect syntax near '-'.
CAUSE
When a table has a default that is bound to a non-ASCII column
(that is, int or float), BCP_INIT will try to issue a select
statement that will retrieve and convert the default value. This
select statement is improperly built and the result is the above
error message.
WORKAROUND
Prior to running the application, unbind the default for non-ASCII
data types (int, float). After the application completes, bind the
default values back to the column and the data type.
STATUS
Microsoft has confirmed this to be a problem in SQL Server version
1.11. Microsoft is researching this problem and will post new
information here as it becomes available.
Additional reference words: db-lib