asked on 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~
Thanks~
Microsoft IIS Web ServerWeb BrowsersMicrosoft SQL Server 2008
Last Comment
Bob Schneider
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
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?
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
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.
ASKER
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....
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Very, very helpful. thanks so much!!