Click to See Complete Forum and Search --> : ADO Help( Negative Value) Urgent !!!!!!!!!!!!!!


S joy
August 14th, 1999, 12:54 AM
Hi to all!,
I have Crystal Report 6.0 with Visual Basic 6.0. I have some problem to discuss. I surff though the net to sites like MSDN. But I fail to get anything.
1) I am working with ADO 2.1 . After installation Of Crystal report 6.0 , while I try to connect to Oracle 8.0.3 server,all MS-OLEDB providers shows same error . The message is "ERROR WHILE TRY TO RETRIEVE TEXT ORA-0000". Connection Object works only with ORACLE ODBC Driver.
2) I have a table on ORACLE with more than 70,000 rows.
That Oracle8 ODBC Driver (ver. 8.00.0300 ) Shows NEGATIVE values in some fields( which don't actually have) after fetching the fields having values more than 100.
3) While using DATA Shaping Language,the RecordSet returns repeated rows.
Please Help me.
Thanks in Advance.