Re: "JOIN" keywords won't work with Oracle Lite via ODBC

Sorry Andrew, you have to do all the heavy lifting yourself and convert all of the queries to Oracle compliant syntax. No [] around tables, single quotes for strings, no INNER JOIN syntax, etc... It is a major pain and I have spent the better part of three weeks converting a complex app with tons of embedded Access SQL. I wrote some PERL scripts to help me, but it was a major effort. I could not find any tools to assist in this conversion. If you find anything, let me know.

Karl

In article <76u83b$2q0$1_at_nnrp1.dejanews.com>,   nguyead_at_cat.com wrote:
> Hi all,
>
> I'm converting my current application which uses MS Access to use Oracle Lite
> and I'm running into this problem where I would get "Syntax Error" returned
> from Oracle Lite on any query that uses keyword like "Inner join", "left
> join", "Outer join", etc.
>
> Ex: SELECT * FROM table1 INNER JOIN table2 ON table1.col1 = table2.col2
> I know the way that Oracle does it for this query is
> SELECT * FROM table1, table2 WHERE table1.col1 = table2.col2
> but our current code has a HUGE number of queries like this so I would hate to
> go through and change them all.
>
> I'm connecting to Oracle Lite using ODBC. Should I be able to use these
> keywords with Oracle Lite?
> Does anyone know that these JOIN statements are ODBC compliant?
> Am I missing something here?
>
> Thanks in advance.
> Andrew Nguyen
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

Karl Kuhnhausen
Allin Consulting
karlk_at_allin.com

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Jan 29 1999 - 00:10:32 CST