Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Oracle + Vb

Options
  • 06-04-2002 1:41pm
    #1
    story_starlet
    Closed Accounts Posts: 18 ✭


    Does anyone know how to connect an oracle Database to VB?


Comments

  • Options
    #2
    K12
    Closed Accounts Posts: 62 ✭✭K12


    Hi there!

    For connecting VB and Oracle u should have ODBC drivers installed in your machine.
    1. You have to create DSN name
    ( Use Control panel -> ODBC for Creation, for this u should know ODBC driver name, Oracle username/password & SID name )
    2. Now u can use the above created DSN name in ur VB application.


  • Options
    #3
    K12
    Closed Accounts Posts: 62 ✭✭K12


    Hi there!

    For connecting VB and Oracle u should have ODBC drivers installed in your machine.
    1. You have to create DSN name
    ( Use Control panel -> ODBC for Creation, for this u should know ODBC driver name, Oracle username/password & SID name )
    2. Now u can use the above created DSN name in ur VB application.


  • Options
    #4
    jd
    Registered Users Posts: 5,695 ✭✭✭jd


    you will need the oracle windows client cd.
    Also your tnsnames.ora file will have to be set up properl


  • Options
    #5
    story_starlet
    Closed Accounts Posts: 18 ✭story_starlet


    Still cant get it to work. Just cant get it to connect.

    Any more Ideas


  • Options
    #6
    jd
    Registered Users Posts: 5,695 ✭✭✭jd


    Originally posted by story_starlet
    Still cant get it to work. Just cant get it to connect.

    Any more Ideas

    What happens?
    What is your set up
    Can you telnetr to the oracle server on ports 1521/1525
    is the listener started on the server??


  • Advertisement
  • Options
    #7
    Slaanesh
    Moderators, Education Moderators Posts: 1,863 Mod ✭✭✭✭Slaanesh


    I think this has more of a chance on the programming boards.

    Slaanesh.


  • Options
    #8
    bonkey
    Registered Users Posts: 15,443 ✭✭✭✭bonkey


    IIRC, what you need to do is this :

    1) Set up a connection in the Oracle Client software. Lets say you call this Fred

    2) Create an ODBC DSN, connecting to Oracle, where the name of what you're connecting to is....Fred. Lets say you save this DSN as FredODBC

    3) In your VB code, use standard code to open an ODBC connection, connecting to FredODBC.

    Its been a while since I played with this, so I may be completely wrong, unfortunately, but hey - you arent much better off at the moment :)

    jc


Advertisement