By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,761 Members | 1,879 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,761 IT Pros & Developers. It's quick & easy.

ODBC Error on Joins

P: n/a
I receive the following error when I try and execute a query using
either a left or right join on two Oracle tables:

ODBC - call failed
[Oracle][ODBC Oracle Driver] [Oracle OCI] ORA-00936: missing
expression (#936)

The tables are linked to the database and I can view the tables
without any errors. I can also execute queries on the tables and long
as there are no joins in the query.

It's a Windows 2000 PC with MS Access 97. I have upgraded the MS Jet
(msjet35.dll) to version 3.51.3328.0.

I've searched the newsgroups and web, but have yet to find an answer
that solves this problem. The part I really don't understand is I
have another PC setup just the same and the query works on it just
fine.

Any help would greatly be appreciated.

Thanks
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.