Connect To Oracle without ODBC (I'm A New Guy)


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 4 of 4

Thread: Connect To Oracle without ODBC (I'm A New Guy)

  1. #1
    Gregg Guest

    Connect To Oracle without ODBC (I'm A New Guy)


    I am developing a VB application that connects to a Orcale database. I was
    told that it is possible
    to connect to an oracle datasource with out using ODBC. This application
    is going to installed in several
    locations and not all the user have the odbc drivers. can anyone shed any
    light on this for me. I was
    told that you could do it in c or c++, but I have no idea.
    Any help would be great

    Thanks
    Gregg

    Share on Google+

  2. #2
    Guest

    Re: Connect To Oracle without ODBC (I'm A New Guy)


    hi

    Usually the ODBC drivers come along with the operating system. Microsoft
    provides them. Using PROVIDER just select system DSN > add
    username ... at server give the oracle sid. try it out


    "Gregg" <GKury@yahoo.com> wrote:
    >
    >I am developing a VB application that connects to a Orcale database. I

    was
    >told that it is possible
    >to connect to an oracle datasource with out using ODBC. This application
    >is going to installed in several
    >locations and not all the user have the odbc drivers. can anyone shed any
    >light on this for me. I was
    >told that you could do it in c or c++, but I have no idea.
    >Any help would be great
    >
    >Thanks
    >Gregg
    >


    Share on Google+

  3. #3
    Simon Sellick Guest

    Re: Connect To Oracle without ODBC (I'm A New Guy)


    <GKury@yahoo.com> wrote:
    >
    >hi
    >
    >Usually the ODBC drivers come along with the operating system. Microsoft
    >provides them. Using PROVIDER just select system DSN > add
    >username ... at server give the oracle sid. try it out
    >
    >
    >"Gregg" <GKury@yahoo.com> wrote:
    >>
    >>I am developing a VB application that connects to a Orcale database. I

    >was
    >>told that it is possible
    >>to connect to an oracle datasource with out using ODBC. This application
    >>is going to installed in several
    >>locations and not all the user have the odbc drivers. can anyone shed

    any
    >>light on this for me. I was
    >>told that you could do it in c or c++, but I have no idea.
    >>Any help would be great
    >>
    >>Thanks
    >>Gregg
    >>

    >

    I don't think you can do it without the Oracle client software loaded - the
    bit that uses the tnsnames.ora file entries to 'know' what an Oracle SID
    means. If you discover otherwise, please do let me know!
    Share on Google+

  4. #4
    mister pants Guest

    Re: Connect To Oracle without ODBC (I'm A New Guy)


    "Gregg" <GKury@yahoo.com> wrote:
    >
    >I am developing a VB application that connects to a Orcale database. I

    was
    >told that it is possible
    >to connect to an oracle datasource with out using ODBC.


    It is indeed, and anyway using ODBC is old-hat nowadays. You can use Oracle
    Objects for OLE ("OO4O"), or use an Oracle OLEDB Provider (Micro$oft$ one
    works fine). There's probably one on your machine, if not install the latest
    version of MDAC from Micro$oft.

    Here's a handy tip, create a new file with a .UDL extension (i.e. 'x.udl'),
    then double-click on it. That runs the Microsoft data link dialog, where
    you can see what OLEDB providers are installed, and can test their connectivity.

    This application
    >is going to installed in several
    >locations and not all the user have the odbc drivers. can anyone shed any
    >light on this for me.



    Each machine will still need the Client Tools configured (from you Oracle
    CD).

    I was
    >told that you could do it in c or c++, but I have no idea.


    You can use OO4O or ADO drivers from just about any language. I'd rather
    force a large spike through my head than program in C++

    Share on Google+

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center