Need Suggestion!!!

[rosy01]

Dear Friends,
Now i am working in Vb.Net platform. I wanna learn the netwoking in vb.net and would like to know how to make centralised database and give connection to other systems through the centralised database. Anybody know any websites to learn these things?

[jmcilhinney]

There are really only three options to consider:

If all your clients are on the same LAN/WAN as the server:

1. You simply specify the server name in the connection string and it's business as usual, just like connecting to a local database.

If you're connection over the internet:

2. Expose the database via HTTP if it supports it. This is not usually done because it's a bigger security risk.

3. Build a web service that is on the same LAN or even the same server as the database. The clients consume the web service and the web service connects to the database as for option 1.

You should most likely be looking at option 1 or 3. If it's 3 then you should search MSDN and the web for information on Windows Communication Foundation (WCF) and how to create and consume WCF web services.

[rosy01]

Thankx for your suggestion. I am new to netwoking. I will search in MSDN and try to learn.