Oracle and VB

Discussion in 'Software Q&A' started by nishant_nms, Aug 13, 2006.

Thread Status:
Not open for further replies.
  1. nishant_nms

    nishant_nms New Member

    Joined:
    Sep 5, 2005
    Messages:
    1,344
    Likes Received:
    1
    Trophy Points:
    0
    Location:
    Pune
    I am using VB and oracle for one of my project. My software will be running on a network. The problem is that I am not able to conncet to the oracle database from the client PC (My project is a ActiveX Document EXE and uses adodc and works on IE). Tell me how can I fix it. I am using Oracle 8i and In the ADODC configuration if I donot specify the server name for oracle then it works well on the PC where oracle database is installed and it doesn't works if I specify the sepver name. The client PCs have not got oracle. Please help me out.
     
  2. ayush_chh

    ayush_chh Member

    Joined:
    Nov 25, 2005
    Messages:
    525
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Bangalore
    i think if u connect using coding i.e. using adodb.connection it will help because this is what i had done in the same situation....(connecting to oracle from server)

    apart from providing the provider, username and password u will also have to provide the datasource to connect from server.

    what i provided in my case:-
    provider=MSDAORA
    datasource=oracle
    user id=scott
    password=tiger

    for personel information: r u an IP student(CBSE)
     
    Last edited: Aug 14, 2006
  3. ayush_chh

    ayush_chh Member

    Joined:
    Nov 25, 2005
    Messages:
    525
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Bangalore
    sorry!!!!
    what i thought was that in the network the oracle is installed..........and the clients access the database from the server......sorry once again:(

    should i delete the above reply????

    so...... cooldip is warned and i thought i was warned:-|.........was very tensed last night:cry:........... anyways my reply was not to the topic nd i'm really sorry 4 that.....:oops:
     
    Last edited: Aug 15, 2006
Thread Status:
Not open for further replies.

Share This Page