Question Re: [Microsoft][ODBC SQL Server Driver]Optional feature not implemented in Technology Q&A

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

Former Member — Mon, 22 Feb 2016 17:22:15 GMT

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

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

Former Member — Mon, 22 Feb 2016 18:31:15 GMT

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

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

Former Member — Mon, 22 Feb 2016 18:41:17 GMT

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.

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

Former Member — Tue, 23 Feb 2016 02:40:23 GMT

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.

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

Former Member — Tue, 23 Feb 2016 03:01:35 GMT

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]

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

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

ALTER PROCEDURE [aaaa].[PMreport_duedate]

-- Add the parameters for the stored procedure here

@ld_datefrom DATETIME,

@ld_dateto DATETIME,

@li_instcode NUMERIC (3)

BEGIN

.........

Kindly advise.

Thank you.

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

Former Member — Tue, 23 Feb 2016 03:38:41 GMT

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.

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

Former Member — Tue, 23 Feb 2016 15:25:06 GMT

Ini File:

DBMS=TRACE ODBC

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

Former Member — Tue, 23 Feb 2016 15:25:23 GMT

Great!