set up a web server or alternative

Question

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.

patrick · Answer

sorry meant english install instructions for sqlite manager - im not sure which solution will work best for me yet :)

Dushan Stankovic · Answer

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.

patrick · Answer

Are there english install instructions?

Dushan Stankovic · Answer

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 Bar · Answer

heya patrick i recommend you this http://www.sqlitemanager.org/ its a web based sqllite manager with installation guide enjoy

patrick · Answer

Dushan your answer is a little beyond me do you have any reference material you can point me to?

Dushan Stankovic · Answer

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 Bar · Answer

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

patrick · Answer

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 Bar · Answer

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