[ODBC SQL Server Driver]Optional feature not implemented

From: Cat (ucm040_at_yahoo.com)
Date: 10/26/04


Date: 26 Oct 2004 02:36:31 -0700


I have a problem with TADOQuery controls, to be more precise with its TParameters values. I am trying to update records on a SQL Server 2000 with the following command “update op set DATA_COMPENSARE=:DATA_COMP, STARE_OP=:STARE_OP where INDEXUL=:INX and SUCURSALA=:SUC”.
The connection string is: Provider=MSDASQL.1;Password=somepass;Persist Security Info=True;User ID=someID;Data Source=SQLSep;Mode=ReadWrite;Extended Properties="DSN=SQLSep;UID=someID;PWD=somepass;APP=Enterprise;WSID=REZERVA;DATABASE=GalData2004".
The problem seems to arise from the date time format:
date.DataModule2.ADOQry_Update_OP.Parameters.ParamByName('DATA_COMP').Value:=sysutils.StrToDateTime(ExStringGrid1.Cells[15,i]);
date.DataModule2.ADOQry_Update_OP.Parameters.ParamByName('STARE_OP').Value:='1'; date.DataModule2.ADOQry_Update_OP.Parameters.ParamByName('INX').Value:=sysutils.StrToFloat(ExStringGrid1.Cells[16,i]); date.DataModule2.ADOQry_Update_OP.Parameters.ParamByName('SUC').Value:=ExStringGrid1.Cells[6,i];
date.DataModule2.ADOQry_Update_OP.ExecSQL;

where DATA_COMP is ftDateTime, STARE_OP is ftString, INX is ftFloat and SUC is ftString.

I keep receiving this error: [ODBC SQL Server Driver]Optional feature not implemented.

Can anybody help me please?

Thanks,
Cat