ADO/ODBC with Oracle

From: <rjones_at_cincom.com>
Date: Thu, 13 Aug 1998 13:08:03 GMT
Message-ID: <6quofj$lem$1@nnrp1.dejanews.com>

We're sending SQL from our NT based web applications, to an Oracle 7.3 server on Unix. The path is via ADO and Microsoft ODBC for Oracle drivers.

What we're finding is that some Oracle constructs like outer joins are not working. The SQL behavior is as if the outer join symbols, '(+)' are being stripped off.

I have read somewhere that some ODBC drivers are a little flakey when in comes to outer joins, but in actual fact I can take problematic SQL from our apps, run it through Oracle's 32-bit ODBC Test program (on the NT), and using both Oracle and MS drivers, the query works. This suggests to me that ADO is the culprit.

Any thoughts?

Rod

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Thu Aug 13 1998 - 08:08:03 CDT