Hey guys and gals, I need an advice or two. I wish to create a database driven web application with some simple tables. I also need to be able to access to the same database from a desktop based application in order to search through its data without the update. In other words, I need a local copy of the same database so I can use it when I'm not online. The only restriction I have is that the server that will host the database is a Windows based. My questions is what is my best option, to create an ASP web site that will access the database (pretty logical ) and then java/c#/other? desktop based application. I'm not sure about the desktop part so if you have any advice I would be very thankful. P.S. the programming language is not the problem, I can do it in almost any but the logic behind the problem is what bothers me... thanks p.l.u.r.
See no reason why not to create them both in .Net given both will be based on windows architecture and will allow you to reuse a fair amount of your code. If your webserver SQL db allows remote connections it will be relatively simple to achieve and not terribly difficult to do if it doesnt, esp if you dont mind a semi-manual download of the db file for offline use.
It is not a problem to do it in .net BUT this means I would have to use a SQL server on local machine too which is ok with me, the only problem is that I would like to install it together with my application, I'm not sure is it possible to create such installation...? thanks
Why you need SQL server on local machine? I suggest to use SQL server on server and Sqlite on client or not use db on client(open webservice on server). Also you can use Sqlite on both parts. Check adodotnetsqlite.sourceforge.net