Knowledge Base |

# BUG: Strings Returned by srv_symbol Have \r\n at the End

Article ID: 124278

Article Last Modified on 12/16/1999

APPLIES TO

- Microsoft SQL Server 4.21a Standard Edition

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.

Additional query words: ods Windows NT

Keywords: kbprogramming KB124278