SQL Translator, this is something for the experts

Hi!

[Quoted] [Quoted] I wish to implement support for Oracle database in my program. the program [Quoted] is ment to be database-independent and currently supports Microsoft Access, [Quoted] [Quoted] Microsoft SQL Server 6.5 and 7.0. The application is mighty big and consists [Quoted] of ALOT of complex and heavy SQL queries. The technique I use in order to [Quoted] query a database is to use ADODB through ODBC.

My problem is this:

[Quoted] My program is based on parameters (i.e, the individual users choose what to [Quoted] view from the database) and therefore use alot of dynamically built SQL's [Quoted] that the program pushes throuch ADODB/ODBC. These SQL's has been written to [Quoted] support SQL's that Access and MS Sql Server understands. ORACLE DOES [Quoted] NOT!!!!. I believe the problem to be located in the FROM part of the SQL's where its used alot of INNER JOIN/OUTER JOIN statements. As far as I can see/understand of Oracle syntax, the joins are written in the WHERE part of [Quoted] the SQL instead of FROM.

[Quoted] can any of you experts help me resolve this problem? is there a DLL out there somewhere that is written for this purpose?

In addition to what I've already mentioned I wish to inform that using stored procedures and business rules located on the database server is not an option. Access dont support it :(

I use VB6 to make this application.

I wish I wish. Please help

Tommy Akre
Software developer Received on Sat Jul 21 2001 - 23:48:14 CEST