EOF with ADO by select Oracle-Number fields 
Author Message
 EOF with ADO by select Oracle-Number fields

Hi,
I have a ado-connection (Microsoft ActiveX Data Ojects 2.1 Library)
to a oracle-db by a Oracle ODBC-Driver 8.00.05.00.
If i open a Recordset the result will be EOF in case there is a
number-field in the Select-Statement.
        Example:

         TABLE REF_ZEITRAEUME (
          ZEITRAUM_ID  NUMBER (6)    NOT NULL,
                GJAHR_KZ     CHAR (7)      NOT NULL,
                MONAT_KZ     CHAR (3)      NOT NULL, )

        Select ZEITRAUM_ID  from REF_ZEITRAEME
                 => the result of open.cursor is eof
        Select TO_CHAR(ZEITRAUM_ID ) from REF_ZEITRAEME
                 => the result of open.cursor is'nt  eof

Who can help me?
--
Erwin G?ttel



Tue, 10 Aug 2004 18:34:27 GMT  
 EOF with ADO by select Oracle-Number fields
Hi,

Which particular ODBC driver are you using - "Microsoft
ODBC for Oracle"? I will try to find if it is bug or not

Val

Quote:
>-----Original Message-----
>Hi,
>I have a ado-connection (Microsoft ActiveX Data Ojects
2.1 Library)
>to a oracle-db by a Oracle ODBC-Driver 8.00.05.00.
>If i open a Recordset the result will be EOF in case
there is a
>number-field in the Select-Statement.
>    Example:

>     TABLE REF_ZEITRAEUME (
>      ZEITRAUM_ID  NUMBER (6)    NOT NULL,
>            GJAHR_KZ     CHAR (7)      NOT NULL,
>            MONAT_KZ     CHAR (3)      NOT NULL, )

>    Select ZEITRAUM_ID  from REF_ZEITRAEME
>             => the result of open.cursor is eof
>    Select TO_CHAR(ZEITRAUM_ID ) from REF_ZEITRAEME
>             => the result of open.cursor is'nt  eof

>Who can help me?
>--
>Erwin G?ttel
>.



Tue, 10 Aug 2004 20:46:25 GMT  
 EOF with ADO by select Oracle-Number fields
Hi Val,
the ODBC-Driver is "Oracle ODBC-Driver 8.00.05.00"
and the Oracle Server has the Version 8.16.0
Erwin



Hi,

Which particular ODBC driver are you using - "Microsoft
ODBC for Oracle"? I will try to find if it is bug or not

Val

Quote:
>-----Original Message-----
>Hi,
>I have a ado-connection (Microsoft ActiveX Data Ojects
2.1 Library)
>to a oracle-db by a Oracle ODBC-Driver 8.00.05.00.
>If i open a Recordset the result will be EOF in case
there is a
>number-field in the Select-Statement.
>    Example:

>     TABLE REF_ZEITRAEUME (
>      ZEITRAUM_ID  NUMBER (6)    NOT NULL,
>            GJAHR_KZ     CHAR (7)      NOT NULL,
>            MONAT_KZ     CHAR (3)      NOT NULL, )

>    Select ZEITRAUM_ID  from REF_ZEITRAEME
>             => the result of open.cursor is eof
>    Select TO_CHAR(ZEITRAUM_ID ) from REF_ZEITRAEME
>             => the result of open.cursor is'nt  eof

>Who can help me?
>--
>Erwin G?ttel
>.

----------


Tue, 10 Aug 2004 21:11:03 GMT  
 EOF with ADO by select Oracle-Number fields
Hi,

Try to use Microsoft's ODBC driver to see if it is working
fine. I think it is a bug

oConn.Open "Driver={Microsoft ODBC for Oracle};" & _
           "Server=OracleServer.world;" & _
           "Uid=myUsername;" & _
           "Pwd=myPassword;"

Val

Quote:
>-----Original Message-----
>Hi Val,
>the ODBC-Driver is "Oracle ODBC-Driver 8.00.05.00"
>and the Oracle Server has the Version 8.16.0
>Erwin



>Hi,

>Which particular ODBC driver are you using - "Microsoft
>ODBC for Oracle"? I will try to find if it is bug or not

>Val

>>-----Original Message-----
>>Hi,
>>I have a ado-connection (Microsoft ActiveX Data Ojects
>2.1 Library)
>>to a oracle-db by a Oracle ODBC-Driver 8.00.05.00.
>>If i open a Recordset the result will be EOF in case
>there is a
>>number-field in the Select-Statement.
>>        Example:

>>         TABLE REF_ZEITRAEUME (
>>          ZEITRAUM_ID  NUMBER (6)    NOT NULL,
>>                GJAHR_KZ     CHAR (7)      NOT NULL,
>>                MONAT_KZ     CHAR (3)      NOT NULL, )

>>        Select ZEITRAUM_ID  from REF_ZEITRAEME
>>                 => the result of open.cursor is eof
>>        Select TO_CHAR(ZEITRAUM_ID ) from REF_ZEITRAEME
>>                 => the result of open.cursor is'nt  eof

>>Who can help me?
>>--
>>Erwin G?ttel
>>.

>----------

>.



Tue, 10 Aug 2004 21:42:58 GMT  
 
 [ 4 post ] 

 Relevant Pages 

1. help with oracle performance : using ado, oracle longraw fields

2. help with oracle performance : using ado, oracle 8 longraw field

3. help with oracle performance : using ado, vb6, oracle 8 longraw field

4. ADO Date Fields (ADO 2.1, VB 6, Oracle 8)

5. ADO Finding Highest Number in ADO Recordset field?

6. Oracle-ASP-Numbers Field

7. ActiveData and Number fields in Oracle?

8. In Crystal 6.0 Cannnot fetch data from Number fields in Oracle 7.3

9. Pb Query Number field on Oracle db w/ Vba Excel

10. Substitute for Acess Auto Number field in ORACLE

11. Setting Oracle Number Fields to Null Problem?

12. Selecting recordsets based on Auto-Number fields

 

 
Powered by phpBB® Forum Software