Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Location
    Jaipur, India
    Posts
    40

    Unanswered: connectivity of remote oracle database through Visual Basic

    Hi all,
    Well my oracle8i is installed on server machine, with following details,
    database instance---- ORCL
    user name---- icsc
    password---- icsc

    now i wanna to connect with that database from my client machine using Visual Basic Form by Microsoft OLE DB for Oracle-- as

    oConn.Open "Provider=msdaora;" & _
    "Data Source=ORCL;" & _
    "User Id=icsc;" & _
    "Password=icsc"

    i had installed the Oracle 8i on the client machine, but when i tried to open the connection, it gives error of "ORA- 12154 ----TNS name could not resolve service name."

    please if any one can help..
    Thanking u in anticipation...
    RGDS
    Amit

  2. #2
    Join Date
    Oct 2003
    Location
    Slovakia
    Posts
    482

    Re: connectivity of remote oracle database through Visual Basic

    Originally posted by amitkanodia
    Hi all,
    Well my oracle8i is installed on server machine, with following details,
    database instance---- ORCL
    user name---- icsc
    password---- icsc

    now i wanna to connect with that database from my client machine using Visual Basic Form by Microsoft OLE DB for Oracle-- as

    oConn.Open "Provider=msdaora;" & _
    "Data Source=ORCL;" & _
    "User Id=icsc;" & _
    "Password=icsc"

    i had installed the Oracle 8i on the client machine, but when i tried to open the connection, it gives error of "ORA- 12154 ----TNS name could not resolve service name."

    please if any one can help..
    Thanking u in anticipation...
    RGDS
    Amit
    1. There are many similar questions in this forum, so try to search in this forum.

    2. Check your settings properly.

Posting Permissions

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