ORA-01002: fetch out of sequence

[Guest]

I am trying to use the OracleDatatAdapter to connect to an oracle version
7.3.4.4 server. I am using an oracle 9i client. When i configure the adapter,
the connection works and i can select from the tables. But I get an error
after I select a table and the select sql is generated. I get a " ORA-01002:
fetch out of sequence " error.
This is the first time I have tried to connect to Oracle - am I forgetting
something?

 

[Admiral Q]

I am trying to use the OracleDatatAdapter to connect to an oracle version
7.3.4.4 server. I am using an oracle 9i client. When i configure the
adapter,
the connection works and i can select from the tables. But I get an error
after I select a table and the select sql is generated. I get a "
ORA-01002:
fetch out of sequence " error.
This is the first time I have tried to connect to Oracle - am I forgetting
something?

We have found you need an Oracle 9.0 or earlier client (8.17 or 8.15) - if
you are using the 9.02 client or later, you can not access a 7.xx database
properly and you receive unexpected results.

 

[Guest]

thanks for this - it explains a lot. However, good news. I got the db
connection to oracle working. I used the general ole adapter instead of the
ole adapter for oracle and hey presto, it worked!.