IBM Support

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.

Resolving The Problem

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":"BU053","label":"Cloud & Data Platform"},"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":"LOB10","label":"Data and AI"}}]

Historical Number

123322

Document Information

Modified date:
15 June 2018

UID

swg21337892

Page Feedback