I can imaging in DTAP strategy, on will use Oracle 11g ODAC 11.In some cases the file %ORACLE_HOME%\bin\oci. Oracle Client is categorized as Development Tools.
#Oracle odbc driver windows 7 android#
I have ODBC trace files that indicate these results.Īccessibility (29) Android (7) Aperture (118) app.Oracle client.
#Oracle odbc driver windows 7 64 Bit#
The data type decimal is a 128-bit floating point data type.īasically this means that oracle does not have to cram a 64 bit value into a 32bit value before sending it back to who ever requested the data as a float. When oracle has the primary key stored as a data type number(15,0), windows 7 and access send a request to the oracle database treating the primary key as a decimal with 15 digits and 0 decimals. It is very CPU intensive for Oracle to convert 64-bit values into 32-bit values before replying to a query. Oracle has to cast the index from a double(I know oracle doesn't have double for a data type, but NUMBER defaults to NUMBER(9,2) and stores it like a double), which is a double precision 64-bit floating point data type into a float, which is a single precision 32-bit floating point number, and when access gets the data from the ODBC, it converts it back to a double. This is where I believe the problem happens. Windows 7 and access send a request to the oracle database treating the index as SQL_FLOAT. It seems to be that windows XP and access send a request to the oracle database treating the the index as SQL_DOUBLE, which access can handle just fine. The solution is to change the datatype of the primary key or index columns to NUMBER(15,0) This is assuming your primary key does not need decimal points.īelow will be what I believe the problem to be and how this fixes the problem for windows7. If the column is of type NUMBER without anything else after it, this could be your issue. If you are using windows 7 and access to connect to Oracle through an ODBC connection I might have an answer for you.Ĭheck the datatype of the primary key or index in the oracle table with slow access.
It does not matter if you are using 32bit or 64 bit, the problem is with windows 7. If you have a slow connection with windows 7 and access, but you have a fast connection with windows XP and access, then this may help. I just spent a week on this issue and I hope this helps anyone still having the problem.
0 kommentar(er)
