ORA-01002: fetch out of sequence

[Hodge]

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]

"Hodge" <Ho***@discussions.microsoft.com> wrote in message
news:F5**********************************@microsof t.com...

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.
--

Star Fleet Admiral Q @ your service!
Google is your friend!
http://www.google.com

[Hodge]

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!.

"Admiral Q" wrote:

"Hodge" <Ho***@discussions.microsoft.com> wrote in message
news:F5**********************************@microsof t.com...

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.
--

Star Fleet Admiral Q @ your service!
Google is your friend!
http://www.google.com