[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 · Accepted solution]

Turn on Database Trace and then open log file it creates in Notepad and find the exact SQL statement that generated the error.

Database Trace is activated by adding 'TRACE ' to the front of sqlca.DBMS. In your case set sqlca.DBMS to 'TRACE ODB'.

Then try running the SQL statement in the Database Painter and adjust it until you get it to work. Post your results here for further advice. There might be a connection parm that can help but we can't tell for sure without the exact SQL statement that generated the error.

[Former Member · Accepted solution]

Sorry, could you advise where to set and turn on Database Trace?

(1) .ini file?

[DataBase]

DBMS=ODBC

Database=

UserId=

DatabasePassword =

LogId=

LogPassword=

ServerName=

DbParm=ConnectString='DSN=amostest;UID=amos;PWD=voyager', StripParmNames='Yes',

(2) window > open ()?

dw_composite.SetTransObject(SQLCA)

dw_composite.Retrieve(dt1,dt2,InstCode,InstName)

dw_1.SetTransObject(SQLCA)

dw_1.Retrieve(dt1,dt2,InstCode)

(3) store procedure?

USE [aaaa]

GO

/****** Object:  StoredProcedure [aaaa].[report_duedate]    Script Date: 02/23/2016 11:00:16 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER PROCEDURE [aaaa].[PMreport_duedate]

  -- Add the parameters for the stored procedure here

  @ld_datefrom DATETIME,

  @ld_dateto DATETIME,

  @li_instcode NUMERIC (3)

AS

BEGIN

.........

Kindly advise.

Thank you.

[Former Member · Accepted solution]

Hi,

The error " DataWindow Error Select Error: SQLSTATE - S1C00 [Microsoft][ODBC SQL Server…" resolved by adding "DisableBind=1" in the the ini file, under DbParm.

Thank you very much.

[Former Member · Accepted solution]

Ini File:

DBMS=TRACE ODBC

[Former Member · Accepted solution]

Great!

[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.