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

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

  • Re: Relationship Question
    ... I've used your SQL statements by passing them into an connection.Execute ... statement in ado. ... CONSTRAINT master_cannot_be_slave ...
    (microsoft.public.access.tablesdbdesign)
  • Re: running out of memory
    ... First of all it is not ADO, ... using of the SQL statements on a server side inside of SP to do this rather ... > I've found that looping through an ado recordset will cause memory ... > if it's a large recordset. ...
    (microsoft.public.dotnet.framework.adonet)
  • ADO NextRecordSet
    ... Im executing multiple SQL statements within a batch and ... using the ADO NextRecordset method to loop through the returned ... however when I call NextRecordset after I have ...
    (microsoft.public.sqlserver.programming)
  • Re: prepared command (or instruction) S000002 not found error
    ... So a message for everyone who has problems with ADO and iSeries / AS400: ... Ralf Grenzing - OPUS//G ... we are trying to migrate our Delphi 5 BDE Win32 application to ADO and Delphi 2006 with Update 2 installed. ... It is really wired because some SQL Statements runs and trying the VERY SAME SQL over ODBC works great, ...
    (borland.public.delphi.database.ado)
  • Re: Batch Updates
    ... I assume that this would need to be two seperate sql statements as I am not ... I am currently loading a delimited file into a query and then parsing the ... key field already exists to update my ADO table but this process is very ... insert into table2 ...
    (borland.public.delphi.database.ado)