set up a web server or alternative

patrick

Okay, here is my situation. I have my application running on stations that are grouped in three computers. One of the computers hold an sqlite database on a shared drive, the others use that database so all three are in synch. This is the problem I am running into: I need to set up a way to access the database from the internet, read and write. I have no idea where to begin.

10 Replies

Know the answer? Post it — somebody with the same question will find it here.

patrick17y ago
sorry, meant english install instructions for sqlite manager - im not sure which solution will work best for me yet :)
Dushan Stankovic17y ago
WCF is foundation and came with .NET framework 3.5 and Visual Studio 2008. I don't know if installation is accessibly for other frameworks and earlyer VS's.
patrick17y ago
Are there english install instructions?
Dushan Stankovic17y ago
I learned WCF at the a faculty and I have books on my language, it's will no help you. I will propose you to visit this link and watch videos. You will learn a lot and know what to look for more. WCF is a good framework for DAL witch you want to be shared with the services.

When you finish the videos, if you will help please contact me. I am not an expert, I know basics + little pratice + web + web + web => solving problems :)
Roei Bar17y ago
heya patrick

i recommend you this

http://www.sqlitemanager.org/

its a web based sqllite manager, with installation guide

enjoy
patrick17y ago
Dushan, your answer is a little beyond me, do you have any reference material you can point me to?
Dushan Stankovic17y ago
My propose to you is to create WCF service with proper endpoints, and host it at IIS and you private host application. Both hosts must using same metadata address and you are won. One thing also is to use Asynhronous method calls, and with semaphore class into threading namespace sinhronize access to shared stuffs.
Nir Bar17y ago
I don't understand: if you want to be able to access the database from the internet (even if it's a private network), then you have to make it an internet server.

If you want to access it only from your computers, then the shared-drive is good enough
patrick17y ago
I want to do as much as possible using code, preferably a stand-alone program - I have full control of these computers, but there are a lot of them, so the easier it is to do all of them at once the better.
Nir Bar17y ago
Hi Patrick,
For a starter you should install an IIS which is an internet server.
The connection-strings you are using should access your SQL database with proper authentication credentials (which might be insecure if you're reckless with it)

Please check "Accepted Answer" if this post helps you

Nir