My program is working fine at local, but it hits the following error when I try to run at development server.
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:
@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.