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. Help in getting the IP address dynamically

Help in getting the IP address dynamically

Scheduled Pinned Locked Moved Visual Basic
sysadminhelpdatabase
4 Posts 4 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.
  • A Offline
    A Offline
    aaraaayen
    wrote on last edited by
    #1

    Hi Friends, I have developed one application in vb 6.0 with msaccess as backend. I am using the following Connection string. Conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=\\deep1\overtime log\Overtime Log\Data\OT_Log.mdb" In the above line, deep1 is the server name(System name) where the database mdb file is located. the folder overtime log is shared folder. I packed the application and installing in others system. This is working fine for some of the people and they can able to login inside the application and give data...and I Checked their entries are presented over deep1-Sever mdb file. But some of us cannot login since, the network could not find the path deep1. So its not logging in. But if they try with the servers ip address they can go inside. But the problem is the server's ip address will change dynamically. So in code i cannot give ipaddress also. So only that I have given the system name. The persons who are all in different subnet in network cannot able to access with system name. Can anyone please help me out. I m very thankful to you. Thanks in advance, Regards

    N D R 3 Replies Last reply
    0
    • A aaraaayen

      Hi Friends, I have developed one application in vb 6.0 with msaccess as backend. I am using the following Connection string. Conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=\\deep1\overtime log\Overtime Log\Data\OT_Log.mdb" In the above line, deep1 is the server name(System name) where the database mdb file is located. the folder overtime log is shared folder. I packed the application and installing in others system. This is working fine for some of the people and they can able to login inside the application and give data...and I Checked their entries are presented over deep1-Sever mdb file. But some of us cannot login since, the network could not find the path deep1. So its not logging in. But if they try with the servers ip address they can go inside. But the problem is the server's ip address will change dynamically. So in code i cannot give ipaddress also. So only that I have given the system name. The persons who are all in different subnet in network cannot able to access with system name. Can anyone please help me out. I m very thankful to you. Thanks in advance, Regards

      N Offline
      N Offline
      nlarson11
      wrote on last edited by
      #2

      are these people that can't login able to do a DNS lookup? if not, then your kind of out of luck using APIs to be able to resolve the ip address of deep1. if they can, here's a link to some code that might help you... haven't tested it but looks good... http://www.mvps.org/access/api/api0067.htm

      'Never argue with an idiot; they'll drag you down to their level and beat you with experience.' ~ anonymous 'Life's real failure is when you do not realize how close you were to success when you gave up.' ~ anonymous

      1 Reply Last reply
      0
      • A aaraaayen

        Hi Friends, I have developed one application in vb 6.0 with msaccess as backend. I am using the following Connection string. Conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=\\deep1\overtime log\Overtime Log\Data\OT_Log.mdb" In the above line, deep1 is the server name(System name) where the database mdb file is located. the folder overtime log is shared folder. I packed the application and installing in others system. This is working fine for some of the people and they can able to login inside the application and give data...and I Checked their entries are presented over deep1-Sever mdb file. But some of us cannot login since, the network could not find the path deep1. So its not logging in. But if they try with the servers ip address they can go inside. But the problem is the server's ip address will change dynamically. So in code i cannot give ipaddress also. So only that I have given the system name. The persons who are all in different subnet in network cannot able to access with system name. Can anyone please help me out. I m very thankful to you. Thanks in advance, Regards

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

        aaraaayen wrote:

        This is working fine for some of the people and they can able to login inside the application and give data

        This is because those user cannot resolve the name deep1. They have some netowkring issue that prevents them from resolving that name, either a DNS problem or WINS.

        aaraaayen wrote:

        But some of us cannot login since, the network could not find the path deep1. So its not logging in. But if they try with the servers ip address they can go inside. But the problem is the server's ip address will change dynamically. So in code i cannot give ipaddress also. So only that I have given the system name.

        If you can't resolve the name normally using DNS or WINS, there is nothing you can do to get the dynamic IP address. The methods you would use are the very methods that are failing now. You have some kind of name resolution problem on this network. It's up to the network's administrators to solve this problem.

        A guide to posting questions on CodeProject[^]
        Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
             2006, 2007, 2008

        1 Reply Last reply
        0
        • A aaraaayen

          Hi Friends, I have developed one application in vb 6.0 with msaccess as backend. I am using the following Connection string. Conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=\\deep1\overtime log\Overtime Log\Data\OT_Log.mdb" In the above line, deep1 is the server name(System name) where the database mdb file is located. the folder overtime log is shared folder. I packed the application and installing in others system. This is working fine for some of the people and they can able to login inside the application and give data...and I Checked their entries are presented over deep1-Sever mdb file. But some of us cannot login since, the network could not find the path deep1. So its not logging in. But if they try with the servers ip address they can go inside. But the problem is the server's ip address will change dynamically. So in code i cannot give ipaddress also. So only that I have given the system name. The persons who are all in different subnet in network cannot able to access with system name. Can anyone please help me out. I m very thankful to you. Thanks in advance, Regards

          R Offline
          R Offline
          Rajesh Anuhya
          wrote on last edited by
          #4

          See this http://www.codeproject.com/KB/vb/Manage_Dialup_Automatic.aspx[^]

          Rajesh B --> A Poor Workman Blames His Tools <--

          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