PRB: Connectivity Error: Not a Recognized Built-in FunctionLast reviewed: December 11, 1995Article ID: Q140575 |
The information in this article applies to:
SYMPTOMSWhen trying to run or browse a remote view, you may receive a Connectivity error similar to this one:
Connectivity error: [Microsoft][ODBC SQL Server Driver][SQL Server]'CTOD' is not a recognized built-in function name CAUSEThe CTOD function is added by the user as one of the Output fields, Order By, or Group By fields, or it is added by the View Designer as part of the Selection Criteria. CTOD is a FoxPro-specific function that is not recognized by the SQL Server. When browsing the Remote View, FoxPro passes the SQL command (listed in the Remote View SQL window) to the back-end server for execution. A connectivity error message is generated when any of the FoxPro-specific functions are passed to the back-end server.
RESOLUTIONThe View Designer problem in Microsoft Visual FoxPro version 3.0 for Windows is fixed in Microsoft Visual FoxPro version 3.0b for Windows. In version 3.0, the view designer added the CTOD to the WHERE clause whenever a Selection Criteria on a Datetime field is added to the view. Version 3.0b does not add the CTOD automatically. Currently, 3.0b requires that the date in the example be surrounded by single quotation marks.
Steps to Work Around Problem
STATUSMicrosoft is researching this behavior and will post new information here in the Microsoft Knowledge Base as it becomes available.
MORE INFORMATION
Steps to Reproduce Behavior
|
Additional reference words: 3.00 VFoxWin
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |