SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Member
    Join Date
    Feb 2002
    Posts
    7
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Connecting VB Application to Oracle

    How can I connect a Visual Basic Application to Oracle.
    Please send a small code.

  2. #2
    Mlle. Ledoyen silver trophy seanf's Avatar
    Join Date
    Jan 2001
    Location
    UK
    Posts
    7,168
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Did you get anything?

    Sean
    Harry Potter

    -- You lived inside my world so softly
    -- Protected only by the kindness of your nature

  3. #3
    Your Lord and Master, Foamy gold trophy Hierophant's Avatar
    Join Date
    Aug 1999
    Location
    Lancaster, Ca. USA
    Posts
    12,305
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    No such thing as small code. It can be kind of lengthy code.

    Firstly though we need to know what your environment would be, and I mean specifics because it changes with every version...

    We need to know:
    RDO, ADODB or ODBC access to the database?
    Microsoft's or Oracle's drivers?
    Version of Visual Basic and Oracle.
    Version of MDAC and the DAO libraries on your machine.
    Version of the Jet Libraries on your machine.
    Intranetwork or Internetwork?

    Connecting will require specific code on both sides so it just isn't a Visual Basic issue but you have to write your stored procedures in a specific way as well. You do know PL/SQL correct?
    Wayne Luke
    ------------


  4. #4
    SitePoint Enthusiast
    Join Date
    Feb 2002
    Posts
    55
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hi hotpot64,

    If youíre still watching this thread, I can shed some light on the subject. Although Wayne is correct that VB to database interaction can get very involved, basic operations are quite easy: reads can be done with a few statements; writes are just as easy if your not concerned with transactions processing (making sure ALL of a group of database changes take place, or NONE of them happen). The hardest part is determining the connection from VB to Oracle. However VB has a nice utility that will set up ODBC or a native driver -- the proces is twisted, but easy.

    If you see this, respond and Iíll elaborate.

    -Mike-


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •