Results 1 to 3 of 3

Thread: sql not connecting through vb 6.

  1. #1

    Thread Starter
    New Member
    Join Date
    Apr 2015
    Posts
    1

    sql not connecting through vb 6.

    I can able to connect it through manually. But when I tried to connect through VB is not getting connected.

    let me know what needs to be done I believe some reference file needs to be changed.

    Set OraSession = CreateObject("OracleInProcServer.XOraSession")

  2. #2
    PowerPoster SamOscarBrown's Avatar
    Join Date
    Aug 2012
    Location
    NC, USA
    Posts
    7,454

    Re: sql not connecting through vb 6.

    Does this link help? I don't use Oracle, so don't know the exact syntax....

    http://docs.oracle.com/cd/B14117_01/...8/o4o00069.htm

  3. #3
    Addicted Member Wolfgang Enzinger's Avatar
    Join Date
    Apr 2014
    Location
    Munich, Germany
    Posts
    141

    Re: sql not connecting through vb 6.

    Quote Originally Posted by keerthi2006 View Post
    I can able to connect it through manually. But when I tried to connect through VB is not getting connected.

    let me know what needs to be done I believe some reference file needs to be changed.

    Set OraSession = CreateObject("OracleInProcServer.XOraSession")
    Looks like you're willing to connect thru OO4O (Oracle Objects for OLE).

    Take a look at this:
    http://www.orafaq.com/wiki/OO4O_FAQ

    If that doesn't help, you should be more specific as to what exactly happens when trying to run your code snippet.

    Wolfgang

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