Building a VB application
I'm about to create a project using VB.net and Microsoft SQL Server. It's not difficult when i'm running it on 1 single computer. The problem is, this application should be located in 1 server and accessible through the network. Is there something different i have to do, or i only need to add the connection string as what i do to run it in a single computer. I have heard that i need to make some kind of "handshake" thing to connect the network, and i don't have any idea about that.
Thanks in advanced.
Software/Hardware used:
Office, Visual Studio, Blend, Design, etc
Software/Hardware used:
Office, Visual Studio, Blend, Design, etc
ASKED:
September 17, 2010 2:08 AM
UPDATED:
September 22, 2010 3:20 AM
Answer Wiki:
Do you mean that the database server and the client application will be running on different machines ?
You don't have to program any "handshake". The networking internals are managed by the operating system.
You just have to make sure that the client computer has the appropriate access to the server, and the database server is properly configured to allow remote connections.
--------------------
To see all answers submitted to the Answer Wiki: View Answer History.
yeah, the application will be running on different machines, and enable several machines to access it at the same time. so i only need to code it as if it will be running on 1 single machine only?
Depending on the resources the application will be accessing, you could need to take the effects of concurrent access to those resources into consideration.
Also, you need to understand how concurrence is managed by the DBMS, and what you can do to affect such concurrence management.
Take a look at this:
Database Concurrency and Row Level Versioning in SQL Server 2005
ahh, ok i’ll give a shoot.. thanks a lot for the help