Article ID: 157732
Article Last Modified on 10/3/2003
APPLIES TO
- Microsoft SQL Server 6.5 Standard Edition
This article was previously published under Q157732
BUG #: 16266 (6.50)
SYMPTOMS
The SQLBindParameter fails after binding a parameter with SQL_C_DEFAULT and
SQL_TINYINT under Simplified Chinese Windows 95. The following error
message is generated:
szErrorMsg="[Microsoft][ODBC SQL Server Driver]Restricted data type
attribute violation"
The following statements demonstrate the problem:
SQLExecDirect(hstmt, "Create table mytable(id int)", SQL_NTS);
SQLBindParameter(hstmt, 1, SQL_PARAM_INPUT, SQL_C_DEFAULT, SQL_TINYINT,
1, 0, &sId, 0, &cbId );
SQLExecDirect(hstmt, "select * from mytable where id=?", SQL_NTS);
STATUS
Microsoft has confirmed this to be a problem in SQL Server version 6.5 and
the ODBC driver version 2.65. This problem has been corrected in U.S.
Service Pack 2 for Microsoft SQL Server version 6.5. For more information,
contact your primary support provider.
Additional query words: DBCS
Keywords: kbbug kbfix kbinterop kbnetwork KB157732