Database access on web server

[Hawk]

Hello all,

 

Im trying to make a windows application in c# which accesses and can modify a remote database on a web server.

 

I have no idea how to do this :confused: ... can anybody help?

 

Maybe I should make a web service and use that, but I don't know how to do that and it might not even be the right answer.

 

Please help me :) !

[Datahighway]

Hi Hawk,

 

which database you want to use ?

If your database does not have so many Entries, take a Access Database else use a SQL 2000 or My SQL Database.

 

Can you tell me more about your project ?

Why do you use a web service ?

 

I do not unterstand what do you mean with remote Database.

Do you mean ODBC ?

 

When you build a Webapplication, as a rule is your database on the Webserver too.

[Hawk]

Details

 

Basically, I need to make a Windows application which can read, and modify, an MS Access database. With a local database, this is easy, but I do not know how to do it when the database is on a web server.

 

I am trying to make a simple corporate management program which uses a database. The database needs to be on a web server because the company has no LAN or Intranet, and the it needs to be accessible from more than one computer.

 

I cannot use SQL Server, because hosting costs are generally too high, whereas most hosting companies offer free Access support.

 

I am really only a beginner, so I'm not sure whether Web services have any relevance at all... it was just a thought :cool: !

 

Please help!

[Derek Stone]

A Web service would work nicely in a situation such as this, since the database isn't accessible directly.

[Hawk]

But how?

 

Can anyone give me some details... or direct me to an online tutorial which explains how to implement a webservice in my situation. Bear in mind that I'm only a beginner ;) !