Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 690
  • Last Modified:

Using a local database via web browser

I am converting a race timing service from a windows-based software to a web-based system.   The goal is to run the service off of the database on the web server at a remote location.  However if I am at a location where I can't access the remote server I would like to run it off of the local db on the machine I am using via a web browser and then upload to the server later.  What are my options?

Thanks~
0
Bob Schneider
Asked:
Bob Schneider
  • 4
  • 4
  • 3
7 Solutions
 
Aaron TomoskySD-WAN SimplifiedCommented:
Write something the has a connection string to a database you can alter. Run it against localhost or a URL. Then you can work on importing records from one db to the main db. That's probably a separate app.
0
 
Dave BaldwinFixer of ProblemsCommented:
Your 'real' problem will occur when the internet connection goes down in the middle of your event, something that is very likely to happen if you are connecting wirelessly.  You are probably better off keeping your Windows-based software and adding a routine to upload it to the web database after the event.
0
 
Aaron TomoskySD-WAN SimplifiedCommented:
That sounds like a plan. Spend your time on sending that data to an aggregate web service that can display results and such. Leave the tracking as is.
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
Bob SchneiderCo-OwnerAuthor Commented:
So I am hearing that the way to do it is to run it against a local db and then periodically upload it to the server.  I currently use connection strings for my remote db.  I assume I would do something very similar to connect to a db on my local machine.  Can I do it via my chrome browser if it is connecting to a db on the local machine?
0
 
Aaron TomoskySD-WAN SimplifiedCommented:
IF you want a web front end, and you have windows 7 available, I'd start with installing localdb ( or full SQL express if you want) , and putting your site in IIS. Then you can use chrome or Firefox or whatever you want
0
 
Dave BaldwinFixer of ProblemsCommented:
A browser by itself will not connect to an SQL server.  Browsers connect to web pages.  Some kind of program is going to be required to do the database connection and formatting.  To access it thru a web browser, you will also need a web server that supports your programming language.
0
 
Bob SchneiderCo-OwnerAuthor Commented:
I have full sql express on my server and my local machine.  The web code is classic asp hosted on iis 7.0 on a remote server.  Does that mean I am good to go?  I will try to begin setting  this up in the next couple of days and I don't want to bother folks once I accept a solution.
0
 
Bob SchneiderCo-OwnerAuthor Commented:
Ok so I guess what I am saying is how do I create a connection string to a local db.  I already know how to run it against the db on the server....
0
 
Dave BaldwinFixer of ProblemsCommented:
It should be the same as on the remote host except for the instance name.
0
 
Aaron TomoskySD-WAN SimplifiedCommented:
The web.config will have the connection string. This is relative to your site files and doesn't matter where you use a browser from. The browser talks to the site, the site talks to the database.
0
 
Bob SchneiderCo-OwnerAuthor Commented:
Very, very helpful.  thanks so much!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 4
  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now