Results 1 to 7 of 7

Thread: connectivity to oracle

  1. #1

    Thread Starter
    Registered User
    Join Date
    Aug 2014
    Posts
    3

    Question connectivity to oracle

    How do I connect to Oracle to VB 6.0. i am trying to connect through ADODC/DAO but I am getting the error "No Listner found."What are settings in Oracle and VB to connect to eachother.

  2. #2
    Frenzied Member
    Join Date
    May 2014
    Location
    Central Europe
    Posts
    1,372

    Re: connectivity to oracle

    i had gone through this once and i remember the first issue was to correctly install the correct driver... hope you have got past this. i do not have the code from back then available right now, but can post the connection string that worked for me tomorrow. for the meantime you may want try some of these: http://www.connectionstrings.com/oracle/

  3. #3
    Software Carpenter dee-u's Avatar
    Join Date
    Feb 2005
    Location
    Pinas
    Posts
    11,123

    Re: connectivity to oracle

    "No Listner found"? Are you sure that is the error? Do you have 64bit or 32 bit OS? I remember having a difficult time connecting to Oracle when I was using 64 bit OS, not only difficult, I was not able to connect to it due to driver issues even after trying out all the suggestions I've found on the net.
    Regards,


    As a gesture of gratitude please consider rating helpful posts. c",)

    Some stuffs: Mouse Hotkey | Compress file using SQL Server! | WPF - Rounded Combobox | WPF - Notify Icon and Balloon | NetVerser - a WPF chatting system

  4. #4
    Frenzied Member
    Join Date
    May 2014
    Location
    Central Europe
    Posts
    1,372

    Re: connectivity to oracle

    This is the cn string that worked for me in 32bit Excel VBA after installing "ODAC 11.2.0.3.20 with Oracle Developer Tools for Visual Studio":
    "Driver={Microsoft ODBC for Oracle};Server=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ServerName)(PORT=PortNumber))(CONNECT_DATA=(SID=DatabaseName)));Uid=UserName;Pwd=Password;"

    i tried also these with no luck having added the datasource to the tnsnames.ora file:
    "Provider=msdaora;Data Source=DatabaseAlias;User Id=UserName;Password=Password;"
    "Driver={Oracle in OraHome92};Dbq=DatabaseAlias;Uid=UserName;Pwd=Password;"

  5. #5
    PowerPoster abhijit's Avatar
    Join Date
    Jun 1999
    Location
    Chit Chat Forum.
    Posts
    3,226

    Re: connectivity to oracle

    Quote Originally Posted by vprog View Post
    How do I connect to Oracle to VB 6.0. i am trying to connect through ADODC/DAO but I am getting the error "No Listner found."What are settings in Oracle and VB to connect to eachother.
    Have you got oracle client installed? You'll need to check if your client is working by testing with the tnsPing utility provided by oracle.
    Everything that has a computer in will fail. Everything in your life, from a watch to a car to, you know, a radio, to an iPhone, it will fail if it has a computer in it. They should kill the people who made those things.- 'Woz'
    save a blobFileStreamDataTable To Text Filemy blog

  6. #6
    Smooth Moperator techgnome's Avatar
    Join Date
    May 2002
    Posts
    34,531

    Re: connectivity to oracle

    I'd question whether the server was right on the connectionstring. not sure what the client would be listening to... the server on the other hand should be listening for connection requests.

    -tg
    * I don't respond to private (PM) requests for help. It's not conducive to the general learning of others.*
    * I also don't respond to friend requests. Save a few bits and don't bother. I'll just end up rejecting anyways.*
    * How to get EFFECTIVE help: The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft *
    * How to Use Parameters * Create Disconnected ADO Recordset Clones * Set your VB6 ActiveX Compatibility * Get rid of those pesky VB Line Numbers * I swear I saved my data, where'd it run off to??? *

  7. #7
    New Member
    Join Date
    Dec 2014
    Posts
    1

    Re: connectivity to oracle

    Quote Originally Posted by abhijit View Post
    Have you got oracle client installed? You'll need to check if your client is working by testing with the tnsPing utility provided by oracle.
    SIR i have a problem in connecting my orcale with mt VB Software. if i tried to run the program with coding i can able to get connection, but if i run the program after creating an EXE file i couldn't get a connection its says connection failed. i dont know what is problem in it please give me any solution

Posting Permissions

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



Click Here to Expand Forum to Full Width