CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2013
    Posts
    1

    Oracle connection from VB6

    Hi,

    I'm trying to connect to an Oracle Database from a form written in VB6
    Command I'm using is :-

    Set goOraDatabase = goOraSession.OpenDatabase(sDBName, sConnect, ORADYN_DEFAULT)

    This returns an error and I get a 440 error message returned.
    I've taken the details in sDBName and sConnect and used them to manually connect to the database using Toad and
    this works fine.

    A few other people can run the form and connect with no issues it's only my setup that seems to be the issue so I must
    be missing some part of my setup but I'm unsure where to check for this.

    Any assistance appreciated.

  2. #2
    VictorN's Avatar
    VictorN is offline Super Moderator Power Poster
    Join Date
    Jan 2003
    Location
    Hanover Germany
    Posts
    20,396

    Re: Oracle connection from VB6

    Quote Originally Posted by HMort View Post
    ...
    Set goOraDatabase = goOraSession.OpenDatabase(sDBName, sConnect, ORADYN_DEFAULT)

    This returns an error and I get a 440 error message returned.
    What is the exact error message?
    Victor Nijegorodov

Tags for this Thread

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