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

[Former Member]

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.

BR,

Yow

[Former Member]

Hello Yow, Have you tried '2015-01-01 00:00:00' and '2015-12-31 23:59:59'?

[Former Member]

For Out of range error, after enter as above, it prompts another error as below.

Tested with '2015-01-01 00:00' and '2015-12-31 23:59', which take out second, same error is prompted too.

Please advise.

Thank you.