Hi everyone I hav a small problem in uploading my database. I have created a localhost website on my pc for a vehicle tracking system and now i have no clue in uploading it. Its got two microsost access databases in my pc which is used in the website and they get updated at very regular intervals(almost every second) it has to be uploaded ito the web real time. rite now i use odbc on a localhost.. does any1 have any idea how to do it. Please help if so...
+1
A:
Depending on your traffic using ACCESS in a webserver multi user environment will be a real pain. (File in access, etc). Perhaps try to build a webservice to make changes directly on the server?
If you don't want to use ODBC you may have a look at ADO connectionstrings (www.connectionstrings.com is a goot starting point).
Sascha
2009-03-18 07:01:33
yeah ill look into it...Thanks alot man..cheers!!!.
2009-03-18 07:04:05
+1
A:
I would concur with Sascha I wouldnt even bother wasting the time trying to run your site with access.
Depending on your host you should have access to a free mysql or mssql database. Use this instead. Write a new page that takes parameters and writes them to your online database, that way you can set up a relay on your machine that pushes the changes from your local machine to the web.
Toby Allen
2009-03-19 07:50:17
A:
This is definitely not easy, but it can be done. You would need to run a SQL Server database on the web server, and then push the data from Access to SQL Server, or pull it from SQL Server.
We've got a couple of links talking about it at SQLServerPedia:
Again, it's not easy - judging by the way you worded the question, you're not going to like the answers that you'll read about. You may want to bring in someone who's experienced with web-based databases and replication in order to bring you up to speed and set your expectations about how challenging this will be.
Brent Ozar
2009-03-22 14:18:42