471,083 Members | 1,066 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,083 software developers and data experts.

ODBC Escape {oj} problem w/ ADO

I am running the "Oracle in OraHome92" driver
From a VB application using ADO
On an Oracle 9.2 instance

My problem is this does not work:
Select foo.* From {oj foo Left Outer Join bla on foo.col = bla.col}

While this does:
Select foo.* From oj foo Left Outer Join bla on foo.col = bla.col

I get rows with the second example and none with the first example

The first example works fine on SQL server
Yes the application must run on both dbs so I cant change to the (+)

It seems that it works intermittently which I think is because
sometimes there are rows to return from both tables and thus the outer
join is not needed

Is there a driver option I should be using?

Thank you
Jul 19 '05 #1
0 3184

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by ATK | last post: by
reply views Thread by Surly | last post: by
5 posts views Thread by Alec | last post: by
4 posts views Thread by Eric E | last post: by
2 posts views Thread by Kristian Rink | last post: by
12 posts views Thread by Johnny BeGood | last post: by
reply views Thread by Surly | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.