Re: prepared command (or instruction) S000002 not found error

Hi Jacobs,

thank you very much for taking the time to answer my question.

The problem seems to be that the OLE DB driver part on the server side has "some" problems. We now ordered the CDs with the patches.

So a message for everyone who has problems with ADO and iSeries / AS400: get all fixes!

best regards

Ralf Grenzing - OPUS//G

Michael Jacobs schrieb:
Hi Ralf,

It sounds as though you missed something when migrating it to ADO. it would be helpful to see the code and statement.

Michael
"Ralf Grenzing" <RalfGSpam@xxxxxx> wrote in message news:448fe7c2@xxxxxxxxxxxxxxxxxxxxxxxxx
Hi all,

we are trying to migrate our Delphi 5 BDE Win32 application to ADO and Delphi 2006 with Update 2 installed. We are accessing a iSeries (aka AS400). With some queries we receiving the the above error. Original in German "SQL0518: Vorbereitete Anweisung S000002 nicht gefunden".

It is really wired because some SQL Statements runs and trying the VERY SAME SQL over ODBC works great, too!

Does anybody has an idea?

best regards

Ralf Grenzing


.

Relevant Pages

  • Hope springs eternal...
    ... ORACLE to the ADO component ... greater value doesn't translate very well in Delphi. ... you can specify the connection information on a Command item. ...
    (borland.public.delphi.database.ado)
  • Re: Delphi 8 and ado.net
    ... > different to using say ADO in Delphi? ... The Delphi ADO implementation is basically a wrapper around the Recordset ... have cursors into the database, there are no cursors in ADO.NET. ...
    (borland.public.delphi.non-technical)
  • Re: Sub Selects?
    ... > some nice Delphi DB technique to do this, or should I just build up the ... Due to the way that the ado ... lets assume that you have a list called SelectedIds ... I'd recommend against using the filtering method. ...
    (borland.public.delphi.database.ado)
  • Re: recursive sp, fmtonly, ado,
    ... This was the first thing I've checked, because I suspect Delphi. ... It's in somewhere inside ADO or OLEDB. ... >> create procedure fmttest ...
    (microsoft.public.sqlserver.programming)
  • Re: Field position in a record, how to change?
    ... If you know how to move fields with DAO you can use Ole to access the ... I have found how to obtain the (ADO) FieldDefs for the ... (I am searching documentations for this option but your answer might ... I may just have found the answer in my saved Delphi 5 help files ...
    (borland.public.delphi.database.ado)