RR ODBC Problem

[Smoore_(Guest)]

I have been having problems with ODBC drivers when accessing an ORACLE8 database.____The Microsoft ODBC for Oracle that was distributed with Vs. 10 accesses databases very quickly and works fine with left outer joins; however, when using View tables it will not read ending decimals in number fields. Solution?____The Oracle8 driver from Oracle (SQORA32.dll) is very slow and will not support left outer joins. Reports written using the old INTERSOLV Oracle7 driver that was distributed with Arpeggio will not run with this driver if left outer joins were used. ____I upgraded to 10+ to get the new DataDirect ODBCs. However; they will run only very small databases. Attempts to pull data from databases of any substantial size appears to hang-up the computer. I had previously downloaded test drivers from DataDirect in an attempt to solve the driver problems.____I have been using R&R since the late 80s and have never had such problems until recently.____Can you recommend solutions?__

[accurata]

__I have the same performance problems with ODBC acces on ADS (Advantage Database Server) tables - and it sucks a lot !!!____One reports accesses only to a DB´s view. The view over all __takes 100 msec to run and shows all data.____If I use R&R ODBC access to that view, it takes more than __two minutes only to load the report and then show the__parameter´s dialogue.____Still no solution !!!

[afoddacorizel]

Smoore:__I^m having the same problem with decimal values being zeroed. (Truncated or rounded?)__Have you found a solution yet?__I^m seeing the problem with the following:____-Microsoft Windows 2000__ 5.00.2195 - Service Pack 2____-Microsoft ODBC for Oracle__ 2.573.6019.00__ 2.573.9001.00 (current version just downloaded from MS)____-R&R for Windows, SQL Edition__Version 9.0, Build 9.0.009__Version 10+, Build 10.1.001__Version 10+, Build 10.1.002____-Oracle RDBMS (for Sun Sparc Solaris)__8.1.7.1__8.1.7.3____~~~~~~~~~~~~__I don^t have:__ - an NT box to test this with.__ - any Oracle 7.3 or 8.0 to test.__ - Oracle 8i on any platform other than Sun to test with.____I^m curious as to the versions/platforms you are running__as well as those used by anyone reading this who is NOT having this problem.__

[robw]

This is a known issue in the MS ODBC driver for Oracle. Basically, the MS Driver is setup for a max of 20 bits of precision while Oracle run 32.____By limiting the Oracle field size precision [eg number(7.2)] at table creation, I have been successful in getting decimals to work with the MS driver.____Good luck! Let me know if you find a easier work around...____-Rob