ORA-01002: fetch out of sequence

[Hodge]

I am trying to use the OracleDatatAdap ter 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]

Re: ORA-01002: fetch out of sequence

"Hodge" <Hodge@discussi ons.microsoft.c om> wrote in message
news:F58BCAB6-2795-4681-82BA-3F8CD9355D27@mi crosoft.com...[color=blue]
>I am trying to use the OracleDatatAdap ter 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?
>
>[/color]

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]

Re: ORA-01002: fetch out of sequence

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:
[color=blue]
> "Hodge" <Hodge@discussi ons.microsoft.c om> wrote in message
> news:F58BCAB6-2795-4681-82BA-3F8CD9355D27@mi crosoft.com...[color=green]
> >I am trying to use the OracleDatatAdap ter 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?
> >
> >[/color]
>
> 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
>
>
>
>[/color]