CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 6 of 6

Hybrid View

  1. #1
    Join Date
    Sep 2012
    Posts
    6

    Unhappy Runtime error '440': unable to make connection,ORA-06413

    Urgent issue
    this is my code
    Code:
    Private Sub Command1_Click()
    'Declare variables
    Dim OraSession As Object
    Dim OraDatabase As Object
    Dim OraDynaset As Object
    
    'Create the OraSession Object.
    Set OraSession = CreateObject("OracleInProcServer.XOraSession")
    
    'Create the OraDatabase Object by opening a connection to Oracle.
    Set OraDatabase = OraSession.OpenDatabase("sampleDBname", "username/password", 0&)
    
    'Display the username and database to which you have connected.
    MsgBox "Connected to " & OraDatabase.Connect & "@" & OraDatabase.DatabaseName
    End Sub
    Using this application. the exe file runs fine in program files but its fails in program files(x86)

    system details:
    windows 7 64bit
    oracle 11g

    please help me out

    advance thanks
    Last edited by WizBang; September 15th, 2012 at 08:47 AM. Reason: Added [code] tags

  2. #2
    Join Date
    Dec 2001
    Posts
    6,332

    Re: Runtime error '440': unable to make connection,ORA-06413

    Not familiar with Oracle, but my first thought is a windows OS permissions issue. Have you set the exe file to run with admin level permissions?
    Please remember to rate the posts and threads that you find useful.
    How can something be both new and improved at the same time?

  3. #3
    Join Date
    Sep 2012
    Posts
    6

    Re: Runtime error '440': unable to make connection,ORA-06413

    thanks for the reply..
    yes i have the admin level permission...
    using DAO connecting to oracle 11g...

  4. #4
    Join Date
    Jul 2008
    Location
    WV
    Posts
    5,362

    Re: Runtime error '440': unable to make connection,ORA-06413

    I have not done anything with Oracle and have not used DAO for about 10 years so I can't say what the problem could be. I would think your life would be a lot simplier if you were to use ADO rather than DAO. To the best of my knowledge ADO does not require you to jump through hoops to connect to Oracle or any other ODBC compliant database engine. Typically it is just a matter of using the proper connection string after that all the functions are pretty much the same no matter which DB engine you are using.
    Always use [code][/code] tags when posting code.

  5. #5
    Join Date
    Jan 2006
    Location
    Fox Lake, IL
    Posts
    15,007

    Re: Runtime error '440': unable to make connection,ORA-06413

    Look it up on ORACLE's site. They probably have samples in a variety of languages. VB6 and/or DAO are both very old, and newer IDE's can automatically find things like that. NuGet for example...
    David

    CodeGuru Article: Bound Controls are Evil-VB6
    2013 Samples: MS CODE Samples

    CodeGuru Reviewer
    2006 Dell CSP
    2006, 2007 & 2008 MVP Visual Basic
    If your question has been answered satisfactorily, and it has been helpful, then, please, Rate this Post!

  6. #6
    Join Date
    Dec 2008
    Location
    Step Into(F11)
    Posts
    465

    Question Re: Runtime error '440': unable to make connection,ORA-06413

    as Datamiser suggested .use Ado it is Thousend time better .any Way the following way i connect the oracle database .
    whether it is 9i,10g & 11g Database .that is really no Issue .and it is working in our hundreds of application .
    Code:
     dim con as adodb.connection 
     Dim constr as string
     Set con = New ADODB.Connection
       constr = " Provider = OraOLEDB.Oracle;Data Source=172.25.124.51:1521/RMS;User Id=RORMS;Password=rorms" 
      con.Open constr
    MsgBox "Connected to " & RMS & "database"
    Last edited by firoz.raj; September 17th, 2012 at 04:38 PM.

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

Featured