Inconsistent results with queries on linked Oracle tables

[Rebecca]

I am running a series of queries on several tables linked
from Oracle. They occasionally give different results
when the query is run on the same data. I tried changing
to the MS driver for Oracle (rather than Oracle's driver),
as was suggested in one of these postings...but the
results are still sometimes inconsistent. I am at a
loss....does anyone know why this would happen?

I did find some postings and help in KnowledgeBase
referring to the same sort of issue with FoxPro, but those
fixes don't apply to Oracle.

Thanks,

Rebecca

 

[Petrucci2000]

Hi,

My name is Eric. Thank you for using the Microsoft Access Newsgroups.

You wrote:
"I am running a series of queries on several tables linked from Oracle.
They occasionally give different results when the query is run on the same
data. I tried changing to the MS driver for Oracle (rather than Oracle's
driver), as was suggested in one of these postings...but the results are
still sometimes inconsistent. I am at a loss....does anyone know why this
would happen?

I did find some postings and help in KnowledgeBase referring to the same
sort of issue with FoxPro, but those fixes don't apply to Oracle."

============================
Have you tried using a Pass-Thru query to get Microsoft JET out of the
picture? If you get the correct results then you may need to update to the
latest JET service pack, see: How To: Obtain the Latest Service Pack for
the Microsoft Jet 4.0 Database Engine
http://support.microsoft.com/default.aspx?scid=kb;en-us;239114

If using a Pass-Thru query does not make a difference then it's most likely
related to the Oracle driver you are using.

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support

"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

 

[Guest]

Eric,

Thanks so much for your help. I skipped the pass through
query step as I could not figure out how to get it to
work, but I did install the new Jet, and I've tested it
fairly extensively, that seems to have taken care of it.
Why would the Jet not being up to date affect query
results?

Thanks so much!

--Rebecca

 

[Petrucci2000]

Microsoft Access data (i.e., Tables & Queries) uses the Microsoft JET
Database Engine. The engine controls how data is handled.

In your case you have the following:

Access ---> JET ---> ODBC Driver ---> Oracle

Most likely JET was having problems communicating with ODBC Driver.

If you used a Pass-Thru Query it would be:

Access ----> ODBC Driver -----> Oracle (in theory)

Check out the following on How to create SQL pass-through queries (same way
for Oracle)
ACC2000: Access 2000 Sample Queries Available in Download Center
http://support.microsoft.com/default.aspx?scid=kb;en-us;207626


I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support

"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."