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

ID: Q124278

The information in this article applies to:

Microsoft SQL Server, version 4.2

BUG# NT: 901 (4.2)

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          : kbprg SSrvODS kbbug4.20 SSrvWinNT 
Version           : 4.2
Platform          : WINDOWS

Last Reviewed: May 1, 1997