1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Connecting VB with oracle

Discussion in 'Visual Basic 6' started by chc89, Oct 16, 2008.

  1. chc89

    chc89 Junior Member

    Joined:
    Jan 18, 2008
    Messages:
    118
    Likes Received:
    3
    hello all

    I am trying to connect visual basic and oracle but unable to connect it. I am using oracle 10g. I am able to connect to oracle 9i. Can anyone tell me How can i connect to oracle 10g?

    I Dont want to use DSN connection

    Thanks in advance for any help
     
  2. jammie

    jammie Jr. VIP Jr. VIP Premium Member

    Joined:
    Feb 24, 2008
    Messages:
    773
    Likes Received:
    453
    does it have an ODBC driver?

    hxxp://www.oracle.com/technology/software/tech/windows/odbc/index.html

    might not have the updated ones?

    If its not that, i'm clueless! sorry! never had the opportunity to work with oracle!
     
  3. superstar143

    superstar143 BANNED BANNED

    Joined:
    Apr 2, 2009
    Messages:
    8
    Likes Received:
    1
    first install odbc in your pc then check it
     
  4. djedje70

    djedje70 Regular Member

    Joined:
    Feb 5, 2008
    Messages:
    239
    Likes Received:
    252
    Location:
    none of ur fr#$%ing biz dude!!!
    Microsoft and Oracle don't get along too well.
    I did program some apps years ago in vb6 to connect to Oracle 8i and 9i.

    The trick was to use the OO4O (Oracle Object for Oracle), but it was painful as I needed to code all the recordset behaviors in a class module. Oriented object basically.
     
  5. phpbuilt

    phpbuilt Jr. VIP Jr. VIP

    Joined:
    May 16, 2011
    Messages:
    1,650
    Likes Received:
    5,208
    Occupation:
    $ from websites I own.
    Location:
    putting monkeys in paypal
    Hey man, you could install a web browser into your application. Have the web browser load a web page that reads data from oracle using whatever web technology you want. And all you do is parse the incoming html for the data you need.

    So instead of having your VB6 application draw directly from oracle, you have your VB6 application direct a web browser to any web technology that connects to your oracle database ... gathers the information ... and then once the web browser has retrieved all the data necessary, read the inner html of the web page and run a parse of the data to have your application use the info inside the oracle database. (Yeah a little sloppy ... but it'll work).

    I like to do it this way because then I can just use the web browser to display the data. Now I haven't actually tried this with oracle, but this is how I have my VB6 apps interface with mysql.

    reason for edit: Doh ... resurrected a 2008 post, guess answer won't be as helpful to you after 3 years, but maybe someone else has same issue.
     
    Last edited: Aug 7, 2011