Very Computer

I've got a problem using ADO to retrieve data from an ORACLE 8.15 Database
Server.
When I run a SELECT (via command - object) and initialize the target
recordset-object
like this:

        cmdSQL.CommandText = "SELECT * FROM SomeTable";
        Set rsRec = cmdSQL.Execute

the rsRec.Fields("...") - property gives only '0' for all INTEGER columns.
Other columns with
different datatypes (Varchar, Float...) are retrieved correctly.

When I use the same procedure to connect to an ACCESS Database everything
works fine.
I also get correct results using DAO connection to the ORACLE Server.

Does somebody know what is going wrong there ? Any suggestions to solve or
work around this
problem (bug) ???

So Please let me know !

Thanx 'n' Bye
Denis

Quote:> Hi,

> I've got a problem using ADO to retrieve data from an ORACLE 8.15
Database
> Server.
> When I run a SELECT (via command - object) and initialize the target
> recordset-object
> like this:

>         cmdSQL.CommandText = "SELECT * FROM SomeTable";
>         Set rsRec = cmdSQL.Execute

> the rsRec.Fields("...") - property gives only '0' for all INTEGER
columns.
> Other columns with
> different datatypes (Varchar, Float...) are retrieved correctly.

> When I use the same procedure to connect to an ACCESS Database
everything
> works fine.
> I also get correct results using DAO connection to the ORACLE Server.

> Does somebody know what is going wrong there ? Any suggestions to
solve or
> work around this
> problem (bug) ???

rsName("fieldname")

which may be a work round for you.

Although I have to say that

rsName.Fields(i).Value

works for me too.  You may have to delve into ADO - ODBC/OLE setup, in
which case, good luck to you.

--

Mike Gooding
------------

Sent via Deja.com http://www.deja.com/
Before you buy.

You are using the OLE DB provider, right? Try the ODBC driver.

Mike