BUG: Strings Returned by srv_symbol Have \r\n at the End (124278)

The information in this article applies to:

Microsoft SQL Server 4.2x

This article was previously published under Q124278

SYMPTOMS

The strings returned by the function srv_symbol has \r\n attached to them. This is not mentioned in the Open Data Services documentation.

WORKAROUND

The following code fragment can be used to ensure that a null terminated string without \r\n is copied into the destination buffer:

  pszSymbol  = srv_symbol(...,..,&symbol_len);
  if  (*(pszSymbol+symbol_len-2) == '\r') *(pszSymbol+symbol_len-2) = '\0';
  if  (*(pszSymbol+symbol_len-1) == '\n') *(pszSymbol+symbol_len-1) = '\0';

STATUS

Microsoft has confirmed this to be a problem in OPENDSNT version 4.2. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Modification Type:	Major	Last Reviewed:	12/16/1999
Keywords:	kbprogramming KB124278