Database Transaction in WAN

[simsimlhr]

How can we load the Database form in LAN and WAN.
Means user get form in the WAN .Do Trasnsaction.And Logouts.
PLease Someone Tell me the classes.
I think i must use WEb Services.
If there are articles Do tell me.
Waiting for Reply.
Qasim Raza

 

[simsimlhr]

I want to Just correct the question .

Database would be on the Server Side
Aplication would be on the client side
WE have to connect using WAN or do transaction using WAN
How to Do That
What Classes Would be used
Any url for the articles

 

[Steve Lutz]

simsimlhr,

As long as you have network connectivity, there is no difference between
have the Database on the machine next to you, or a machine on the other side
of the country (except for speed issues).

Use System.Data and System.Data.SqlClient to create connections from the
client to the server.

HTH

Steve

I want to Just correct the question .

Database would be on the Server Side
Aplication would be on the client side
WE have to connect using WAN or do transaction using WAN
How to Do That
What Classes Would be used
Any url for the articles

 

[Andreas Håkansson]

You would just specify the IP (or hostname) and Port number of
the database server on the WAN and work with it as if it was a local
database. You would use a connectionstring like this one

"Data Source=190.190.200.100,1433;Network Library=TCP/IP;
Initial Catalog=pubs;User ID=sa;Password=asdasd;"

Unless you want to use Named Pipes and use

"Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;
Initial Catalog=pubs;User ID=sa;Password=asdasd;"

HTH,

//Andreas

I want to Just correct the question .

Database would be on the Server Side
Aplication would be on the client side
WE have to connect using WAN or do transaction using WAN
How to Do That
What Classes Would be used
Any url for the articles