[ODBC SQL Server Driver]Optional feature not implemented
From: Cat (ucm040_at_yahoo.com)
Date: 10/26/04
- Next message: Roy: "Test"
- Previous message: Stig Johansen: "Re: Still having a problem with MS SQL and NT Service"
- Next in thread: Bryan Valencia: "Re: [ODBC SQL Server Driver]Optional feature not implemented"
- Reply: Bryan Valencia: "Re: [ODBC SQL Server Driver]Optional feature not implemented"
- Reply: Brian Bushay TeamB: "Re: [ODBC SQL Server Driver]Optional feature not implemented"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Next message: Roy: "Test"
- Previous message: Stig Johansen: "Re: Still having a problem with MS SQL and NT Service"
- Next in thread: Bryan Valencia: "Re: [ODBC SQL Server Driver]Optional feature not implemented"
- Reply: Bryan Valencia: "Re: [ODBC SQL Server Driver]Optional feature not implemented"
- Reply: Brian Bushay TeamB: "Re: [ODBC SQL Server Driver]Optional feature not implemented"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]