Article ID: 317956 - View products that this article applies to.
This article was previously published under Q317956
This article has been archived. It is offered "as is" and will no longer be updated.
BUG #: 356240 (SHILOH_BUGS)
SQL Server 2000 may return an error when a client tries to send long text data as an RPC parameter if all of the following conditions are true:
This is SQL Server error number 450. In this error message, code page 1252 is the ANSI code page of the client computers, and code page 850 is the default code page of the SQL Server 2000 instance. These code page numbers may vary in the error message that you receive.
Code page translations are not supported for the text data type. From: 1252 To: 850.
This problem occurs because SQL Server 2000 does not support server-side code page conversion for text data types.
Unlike SQL Server 7.0, SQL Server 2000 supports multiple collations in a single instance, which means that the client (SQLOLEDB) does not know which code page the text or varchar parameters must be converted to. When you have connected to a SQL Server 2000 instance, the SQL Server OLE DB provider defers code page conversion of RPC parameters to the server. SQL Server 2000 correctly handles conversion of char or varchar data types, but it does not support server-side code page conversion for text data types.
To resolve this problem, obtain the latest service pack for Microsoft SQL Server 2000. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/290211/EN-US/ )INF: How To Obtain the Latest SQL Server 2000 Service Pack
To work around this problem, use any one of the following three methods:
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
This problem was first corrected in Microsoft SQL Server 2000 Service Pack 3.