Your first problem is to understand what type of access is available to the various applications you are wanting to work with. ODBC stands for Open Data Base Connectivity - it will generally only be usable with a database or a product that allows direct access to a database for manipulation.

OLE - or Object Link Embedding - is a mechanism for accessing objects within the target application from your application. But you need the documentation on the objects within the application you can access.

In short - research the product you want to manipulate. Find out what access methods it allows and THEN you KNOW what you need to use fomr your application. There is no choice between the various methods you mention, each has its own specific uses and functionalities. jdtoronto

In reply to Re: Access MS exchange, Lotus Notes ODBC vs. OLE by jdtoronto
in thread Access MS exchange, Lotus Notes ODBC vs. OLE by Deda

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.