Re: ODBC Open Database Compatibility

In article <4sitcl$67k@nw101.infi.net> dswaney@norfolk.infi.net writes: >- Does ODBC SQL have a standard universal SQL that can be either >translated or used by both databases without programmatically modifying >embedded SQL statements? Yes. As of ODBC 2.0 and strictly according to the grammar, only left outer joins are supported. Standard ODBC escape syntax is provided to allow the application to specify the join. It is the responsibility of the driver to translate the escape syntax into the appropriate native syntax. I believe that right outer joins are specified in 2.1, but I don't have that documentation handy. >- Is there a FAQ on ODBC? I am not aware of one, but if you find one please let me know. >Any information would be very helpful and greatly appreciated. For complete technical information, I strongly recommend the "Microsoft ODBC 2.0 Programmer's Reference and SDK Guide" from Microsoft Press. For an interesting discussion of the history, evolution, and rationale of ODBC, see "Inside ODBC" by Kyle Geiger, also from Microsoft Press. I understand ODBC 3.0 is on the way. Scott