carlisle_cibf
asked on
Microsoft Access 2007 Very slow on query running to Oracle Database
Microsoft Access 2007 Very slow on query running to Oracle Database.
Query to Oracle 10g database running slow or fail. This query runs fine on another laptop.
No idea what is causing the issue.
Query to Oracle 10g database running slow or fail. This query runs fine on another laptop.
No idea what is causing the issue.
What hardware/software configuration are the new computers?
New computers will typically require new drivers to connect to the source.
How are you connecting to the Oracle source?
New computers will typically require new drivers to connect to the source.
How are you connecting to the Oracle source?
ASKER
Oracle 10g ODBC drivers.
I also asked about the software on the new computers...
ASKER
Windows 7.
what edition/Version of Win 7?
Home
Pro
Ultimate
32 bit
64 bit
?
Oracle will have specific drivers possibly for each.
(in the same way you install a Printer Driver specific to the OS)
Home
Pro
Ultimate
32 bit
64 bit
?
Oracle will have specific drivers possibly for each.
(in the same way you install a Printer Driver specific to the OS)
ASKER
Windows 7 Pro/32 bit.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Need help on why this query runs slow on newer computers, but fine on old XP computer that is 10 years.