Client/Server doubt
-
Hi. I have to develop an application that it will run in some clients, (3 or 5 PC's) and it connects to a SQL database in a server PC. I have some skills in MFC:-> and also I know how to connect and query, (also call a SP), a SQL database. But, my question is: is that all that I need to know to develop such application?. I mean, there's something else to know or to care to develop a Client/Server app?.:~ I need just an orientation about that, maybe an article or something like that. Thank you.
Demian. "I have always wished that my computer would be as easy to use as my telephone. My wish has come true. I no longer know how to use my telephone." -Bjarne Stroustrup, computer science professor, designer of C++ programming language (1950- )
-
Hi. I have to develop an application that it will run in some clients, (3 or 5 PC's) and it connects to a SQL database in a server PC. I have some skills in MFC:-> and also I know how to connect and query, (also call a SP), a SQL database. But, my question is: is that all that I need to know to develop such application?. I mean, there's something else to know or to care to develop a Client/Server app?.:~ I need just an orientation about that, maybe an article or something like that. Thank you.
Demian. "I have always wished that my computer would be as easy to use as my telephone. My wish has come true. I no longer know how to use my telephone." -Bjarne Stroustrup, computer science professor, designer of C++ programming language (1950- )
For a two-tiered solution (client-RDBMS), that's pretty much all you need. Each client can just connect to the SQL database server. If you add a server tier (client-server-RDBMS), then you'd need to add communication between the clients and that server. Mark
"Posting a VB.NET question in the C++ forum will end in tears." Chris Maunder
-
For a two-tiered solution (client-RDBMS), that's pretty much all you need. Each client can just connect to the SQL database server. If you add a server tier (client-server-RDBMS), then you'd need to add communication between the clients and that server. Mark
"Posting a VB.NET question in the C++ forum will end in tears." Chris Maunder
-
Mark Salsbery wrote:
For a two-tiered solution (client-RDBMS), that's pretty much all you need. Each client can just connect to the SQL database server.
As long as there are no firewall issues.
Yeah :) But the OP won't need to know any other "technologies" to hit that wall ;P
"Posting a VB.NET question in the C++ forum will end in tears." Chris Maunder
-
For a two-tiered solution (client-RDBMS), that's pretty much all you need. Each client can just connect to the SQL database server. If you add a server tier (client-server-RDBMS), then you'd need to add communication between the clients and that server. Mark
"Posting a VB.NET question in the C++ forum will end in tears." Chris Maunder
Ok, Mark. But in which situations are needed a client-server-RDBMS solution?. I just want to read and update data in a server database, (a remote server) from some few clients. Just that. Thankx.
Demian. "I have always wished that my computer would be as easy to use as my telephone. My wish has come true. I no longer know how to use my telephone." -Bjarne Stroustrup, computer science professor, designer of C++ programming language (1950- )
-
Ok, Mark. But in which situations are needed a client-server-RDBMS solution?. I just want to read and update data in a server database, (a remote server) from some few clients. Just that. Thankx.
Demian. "I have always wished that my computer would be as easy to use as my telephone. My wish has come true. I no longer know how to use my telephone." -Bjarne Stroustrup, computer science professor, designer of C++ programming language (1950- )
I'm no expert on database applications, but in my case, I chose 3-tier for the following reasons, based on experience, not expertise: Complete control over client server communication, including NAT/firewall traversal. Complete control over user authentication. Complete control over network security (encryption). Generic database access from clients - I'm not bound to a specific RDBMS or data access framework. DB connection management and pooling. Here's an article that may be of interest: N-Tier Application Development with Microsoft .NET[^] It's a 3-part article but part one explains some reasons for n-tier solutions. Mark
"Posting a VB.NET question in the C++ forum will end in tears." Chris Maunder