Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Total ODBC Confusion

Total ODBC Confusion

From: <coakleyj_at_hotmail.com>
Date: Thu, 27 Jan 2000 19:04:21 GMT
Message-ID: <86q4rh$ldv$1@nnrp1.deja.com>


Hi everybody.

My colleagues and I are totally confused about ODBC. Perhaps some-one can answer these fundamental questions:

  1. What determines if an IDE allows ODBC or not? For example, MS ACCESS and VB support it directly - Oracle Developer has an OCA layer for converting Oracle SQL calls into ODBC calls - but can I write ODBC calls directly within Oracle Forms for example?
  2. ODBC driver managers exist for Unix (which was a surprise to me - I had always taken it to be Windows only). So if I install such a piece of software on my Unix server, can I then start writing applications that are ODBC compliant?
  3. Can all programming languages make ODBC calls - Say I'm developing a C application on Unix, can I directly write ODBC calls, or use some sort of pre-compiler technology?
  4. People talk about MS Visual C++ and how it supports a c++ ODBC API (presumably different from the standard ODBC API)? Why does it support a different standard? Does this answer my previous question?
  5. Oracle Application Server included an ODBC cartridge. What exactly does this cartridge allow one to do? Can I now make ODBC calls from within my PL/SQL, Java cartridges? I'm confused? If my OAS sits on an NT platform, I already have ODBC software - so what does the OAS ODBC cartridge add to the picture?

Thanks for all insights.

Coakleyj

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Jan 27 2000 - 13:04:21 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US