Error number 27: [Microsoft][ODBC SQL Server Driver]Optional feature not implemented

Troubleshooting

Problem

Impromptu 7.0 (PC) Description: The following error message is received when using a date prompt as the input parameter to a stored procedure in SQL Server 7 over an ODBC connection: Error number -27: DMS-P-FEATURESUPPORT, Feature '2468008' in function 'bind arguments' is not supported. [Microsoft][ODBC SQL Server Driver]Optional feature not implemented. Solution: This issue is addressed in a Microsoft document at the following location: http://support.Microsoft.com/default.aspx?scid=kb;en-us;214459 The document suggests that to correct this problem, you need to change the datatype of the @theDate parameter to adDBTimeStamp in the stored procedure. A workaround would be to use an OLE-DB or DB-LIB connection and a date-time prompt instead of a date prompt.

[{"Product":{"code":"SSTQPQ","label":"IBM Cognos Series 7 PowerPlay"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Impromptu","Platform":[{"code":"PF025","label":"Platform Independent"},{"code":"PF033","label":"Windows"}],"Version":"Impromptu 7.0;Impromptu 7.1;Impromptu 7.3","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Historical Number

123322

Was this topic helpful?

Document Information

More support for:
IBM Cognos Series 7 PowerPlay

Software version:
Impromptu 7.0, Impromptu 7.1, Impromptu 7.3

Operating system(s):
Windows

Document number:
110831

Modified date:
09 May 2025

UID

swg21337892

IBM Support

Tips