Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. General Programming
  3. Visual Basic
  4. vb.net and oracle client

vb.net and oracle client

Scheduled Pinned Locked Moved Visual Basic
helpcsharporacledotnet
6 Posts 3 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • H Offline
    H Offline
    hemrk
    wrote on last edited by
    #1

    i am devloping s/w in vb.net 2005 and oracle. on my pc. its running fine..but when i try to copy on the other machine c drive or network drive ..it gives me error that TNS coulnot resolve the service name. actually i am using oracle provider for oracle in microsoft. and importning system.data.oracleclient.dll which is resides in microsoft.framework 2.0 directory. on the other machine they have installed .net framework 2.0. i dont know the problem..why its giving me the problem. and ofcourse it runs on network drive on my computer. i dont understand that if it is running on network drive on my pc then why not on the other? if anybody knows the solution , let me know asap. i've triend tnsnames.ora and all.. but couldnot able to solve this problem// hemaxi

    D M 2 Replies Last reply
    0
    • H hemrk

      i am devloping s/w in vb.net 2005 and oracle. on my pc. its running fine..but when i try to copy on the other machine c drive or network drive ..it gives me error that TNS coulnot resolve the service name. actually i am using oracle provider for oracle in microsoft. and importning system.data.oracleclient.dll which is resides in microsoft.framework 2.0 directory. on the other machine they have installed .net framework 2.0. i dont know the problem..why its giving me the problem. and ofcourse it runs on network drive on my computer. i dont understand that if it is running on network drive on my pc then why not on the other? if anybody knows the solution , let me know asap. i've triend tnsnames.ora and all.. but couldnot able to solve this problem// hemaxi

      D Offline
      D Offline
      Dave Kreskowiak
      wrote on last edited by
      #2

      Does this other machine have the actual Oracle Client software installed on it?? Without it, the OracleClient namespace won't work. I think the machine has to have MDAC 2.8 SP1 or better installed, then at least Oracle Client 8i Release 3. Dave Kreskowiak Microsoft MVP - Visual Basic

      M 1 Reply Last reply
      0
      • D Dave Kreskowiak

        Does this other machine have the actual Oracle Client software installed on it?? Without it, the OracleClient namespace won't work. I think the machine has to have MDAC 2.8 SP1 or better installed, then at least Oracle Client 8i Release 3. Dave Kreskowiak Microsoft MVP - Visual Basic

        M Offline
        M Offline
        mr_12345
        wrote on last edited by
        #3

        Try connecting to the Oracle Database using Sqlplus on the machine you are having problems with. If you can connect, then look for multiple tnsnames.ora file on the machine. Also make sure your Oracle Home points to the right directory in your Environment variables. Mike Lasseter

        D 1 Reply Last reply
        0
        • M mr_12345

          Try connecting to the Oracle Database using Sqlplus on the machine you are having problems with. If you can connect, then look for multiple tnsnames.ora file on the machine. Also make sure your Oracle Home points to the right directory in your Environment variables. Mike Lasseter

          D Offline
          D Offline
          Dave Kreskowiak
          wrote on last edited by
          #4

          You might want to reply to the OP so he gets a message that you posted a reply. I'm not having the problem with (gag, puke) Oracle. Dave Kreskowiak Microsoft MVP - Visual Basic

          M 1 Reply Last reply
          0
          • H hemrk

            i am devloping s/w in vb.net 2005 and oracle. on my pc. its running fine..but when i try to copy on the other machine c drive or network drive ..it gives me error that TNS coulnot resolve the service name. actually i am using oracle provider for oracle in microsoft. and importning system.data.oracleclient.dll which is resides in microsoft.framework 2.0 directory. on the other machine they have installed .net framework 2.0. i dont know the problem..why its giving me the problem. and ofcourse it runs on network drive on my computer. i dont understand that if it is running on network drive on my pc then why not on the other? if anybody knows the solution , let me know asap. i've triend tnsnames.ora and all.. but couldnot able to solve this problem// hemaxi

            M Offline
            M Offline
            mr_12345
            wrote on last edited by
            #5

            Try connecting to the Oracle Database using Sqlplus on the machine you are having problems with. If you can connect, then look for multiple tnsnames.ora file on the machine. Also make sure your Oracle Home points to the right directory in your Environment variables. Mike Lasseter

            1 Reply Last reply
            0
            • D Dave Kreskowiak

              You might want to reply to the OP so he gets a message that you posted a reply. I'm not having the problem with (gag, puke) Oracle. Dave Kreskowiak Microsoft MVP - Visual Basic

              M Offline
              M Offline
              mr_12345
              wrote on last edited by
              #6

              OK. Sorry about that.

              1 Reply Last reply
              0
              Reply
              • Reply as topic
              Log in to reply
              • Oldest to Newest
              • Newest to Oldest
              • Most Votes


              • Login

              • Don't have an account? Register

              • Login or register to search.
              • First post
                Last post
              0
              • Categories
              • Recent
              • Tags
              • Popular
              • World
              • Users
              • Groups