Skip to Content
Former Member
Feb 22, 2016 at 05:22 PM

[Microsoft][ODBC SQL Server Driver]Optional feature not implemented


Hi All,

My program is working fine at local, but it hits the following error when I try to run at development server.

DataWindow Error

Select Error: SQLSTATE - S1C00

[Microsoft][ODBC SQL Server Driver]Optional feature not implemented

The program is actually to generate report which is a composite datawindow ( A datawindow with graph which is created from store procedure and another datawindow to show listing), sample as below is generated from my local.

The store procedure to pass data into the graph datawindow having parameters as below:

@ld_datefrom DATE,

@ld_dateto DATE,

@li_instcode NUMERIC (3)

The listing datawindow having the retrieval arguments as below:

Understand that the given error is something with the date data type. I did change the argument ld_datefrom and ld_dateto to 'DateTime', but when I enter ld_datefrom = 2015-01-01 and ld_dateto = 2015-12-31, it will throws another error "Numeric Value out of range" at local, when I try to Run/Preview the listing datawindow. What should I do for this? Please advise.

This is a bit urgent and kindly advise.

Thank you in advance.




RA.PNG (11.3 kB)
Capture.PNG (65.3 kB)
outofrange.PNG (26.5 kB)