Results 1 to 8 of 8

Thread: database problem

  1. #1

    Thread Starter
    Fanatic Member
    Join Date
    Jul 2006
    Location
    nasik,india
    Posts
    909

    Red face database problem

    I have developed an application in vb and back-end as access.
    there is a novel server on which we have a database.

    Now a problem is that a computer which is not in LAN can not access the software.

    I want a way by which i can access to my database/software from anywhere on any computer which may not be in LAN.

    Or can i place my database on internet ? and can i access it in vb ?
    WHETHER YOU SUCCEED OR FAIL IS NOT AS IMPORTANT AS WHETHER YOU TRIED YOUR BEST

  2. #2
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: database problem

    Quote Originally Posted by shukla
    Now a problem is that a computer which is not in LAN can not access the software.
    That is not a problem, the is way networks are designed. If the computer needs access, it has to go on the network.
    Quote Originally Posted by shukla
    I want a way by which i can access to my database/software from anywhere on any computer which may not be in LAN.
    Then it needs to be added to your network.
    Quote Originally Posted by shukla
    Or can i place my database on internet ? and can i access it in vb ?
    Yes, and yes, but I would not recommend using VB. VB is a desktop language primarily. If your database is going on the internet, then write a new front end for it in a web language.

  3. #3
    Junior Member
    Join Date
    Feb 2007
    Posts
    26

    Re: database problem

    You can easily point your VB app to an access database using an ipaddress. When you build your connection string, just use the ip address as follows:

    conString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="//10.1.1.1/Database.mdb"

    You should be able to use the domain name as well. There's no need to create a web app to do this. Even so, VB is great for ASP.net development.

  4. #4

    Thread Starter
    Fanatic Member
    Join Date
    Jul 2006
    Location
    nasik,india
    Posts
    909

    Re: database problem

    it gives error as "Invalid file name"
    WHETHER YOU SUCCEED OR FAIL IS NOT AS IMPORTANT AS WHETHER YOU TRIED YOUR BEST

  5. #5
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: database problem

    Did you change Database.mdb to the name of your database?

  6. #6

    Thread Starter
    Fanatic Member
    Join Date
    Jul 2006
    Location
    nasik,india
    Posts
    909

    Re: database problem

    yes.
    WHETHER YOU SUCCEED OR FAIL IS NOT AS IMPORTANT AS WHETHER YOU TRIED YOUR BEST

  7. #7
    PowerPoster
    Join Date
    Feb 2006
    Location
    East of NYC, USA
    Posts
    5,691

    Re: database problem

    And the IP address to the IP address of a computer on your LAN or the IP address of a computer accessible using a public IP?
    The most difficult part of developing a program is understanding the problem.
    The second most difficult part is deciding how you're going to solve the problem.
    Actually writing the program (translating your solution into some computer language) is the easiest part.

    Please indent your code and use [HIGHLIGHT="VB"] [/HIGHLIGHT] tags around it to make it easier to read.

    Please Help Us To Save Ana

  8. #8
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: database problem

    Are you still having a problem with this?

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