TechRepublic|Forums|Networks

Networks

General discussion

  • Creator
    Topic
  • January 14, 2000 at 5:12 am #2081882

    OBDC vs Native Orcle database connection

    Locked

    by emartinezm@reliable-finan · about 24 years, 8 months ago

    What will be my gratest drawbacks in using OBDC or any other posible connection to an Oracle8 Database versus using native Oracle connection?

    Topic is locked This conversation is currently closed to new comments.
  • Creator
    Topic

All Comments

  • Author
    Replies
    • January 14, 2000 at 6:00 am #3903047

      OBDC vs Native Orcle database connection

      by bill_h · about 24 years, 8 months ago

      In reply to OBDC vs Native Orcle database connection

      IMHO, the biggest drawbacks are lower performance, and a higher degree of complexity in development. I have found using ADO and OLEDB to be superior. The ‘Microsoft OLE DB Provider for Oracle’ works quite well. Oracle has released a BETA version of its own provider – my inital experiments have uncovered a few differences in implementation from the MS provider, but no major problems.
      For a comparison of data access options, you may wish to view the MSDN article ‘Choosing a Data Access Strategy’, which can be found at:

      http://msdn.microsoft.com/library/devprods/vs6/vstudio/vsentpro/veconchoosingdataaccessstrategy.htm

      (The above link may have wrapped…)

      Hope this helps…

    • January 16, 2000 at 6:09 am #3903012

      OBDC vs Native Orcle database connection

      by dstone9 · about 24 years, 8 months ago

      In reply to OBDC vs Native Orcle database connection

      Although ODBC is often mentioned as being slower than native connections, I have found the performance of ODBC and native Oracle drivers to be about the same.

      Native drivers may have a disadvantage when you are using a 4GL development environmentlike PowerBuilder. The SQL code and Datawindows generated by PowerBuilder when connected to an Oracle database through a native driver may be less portable than the same code generated with an ODBC driver.

      HTH,
      Doug

    • January 20, 2000 at 2:16 am #3902928

      OBDC vs Native Orcle database connection

      by fofa · about 24 years, 8 months ago

      In reply to OBDC vs Native Orcle database connection

      We have found that the native DB driver gives us a performance edge using PowerBuilder. But using Intersolves ODBC driver (for other apps that require odbc) has closed that gap to almost nothing. We found that the Intersolve drivers are 10 faster than other ODBC drivers for Oracle.

    • March 31, 2000 at 5:14 am #3896324

      OBDC vs Native Orcle database connection

      by sfernandez · about 24 years, 5 months ago

      In reply to OBDC vs Native Orcle database connection

      1. Native Oracle API will tie you to Oracle alone, ODBC stands a reasonable chance of being kept portable.

      2. ODBC does not expose all of the features of Oracle 8 (or any other native DB API). For example, management APIs for servers.

      3. ODBC datatypes do not exactly match those implmented in every database. There are some datatypes you need to do workarounds for.

      Stephen

  • Author
    Replies
Viewing 3 reply threads