₦airaland Forum

Welcome, Guest: Register • Login • With Google • Trending • Recent • New

Stats: 3,346,379 members, 8,522,737 topics. Date: Saturday, 21 November 2026 at 09:38 PM

Toggle theme

Vb.net And Online Database - Programming - Nairaland

Nairaland Forum › Science/Technology › Programming › Vb.net And Online Database (918 Views)

1 Reply (Go Down)

Vb.net And Online Database by walterjnr(op): 9:08am On May 29, 2019
I am building a desktop app with vb.net and i want the sql server database to be hosted online so anybody anywhere can assess the database through d vb.net software. Please does that means i will embrace cloud computing?

What is the best way of achieving that ?

Thanks
Re: Vb.net And Online Database by Bros1: 9:48am On May 29, 2019
Dear Walterjnr,

The architecture behind this kind of design is flawed and may be impractically to implement.

SQL Server is not build to act like a web server.

One of the issues with this your line of thought is that Sql Server is configured by most hosts to accept 1 or 2 simultaneous connections per database.

As u plan to distribute your client VB.net app to many users on different machines and Ip credentials, the vb.net will be creating multiple instances of ADO.net connections to the database. This can lead to performance penalties and security issues as your connection string has a large surface area for hacking exploits.

In the alternative you can create a data layer vb.net application (server) to talk to the db using 1 sql server connection instance. Your VB.net apps distributed here and there can feed the data layer application and retrieve the required information from the db. This is a better approach

Thanks
Re: Vb.net And Online Database by linkdan: 11:55am On May 29, 2019
Simply put the the database behind a web service (xml web service, WCF service or ASP.NET Web API), and consume the service from any type of application (windows, mobile, web, etc.). The service should be hosted on the internet (on a shared host, VPS, Dedicated Server, Cloud (Azure, AWS, etc.)). This way, your windows application installed on any desktop anywhere in the world with internet connection can consume the web service for its normal operation.

The choice of web host selected will depend on a lot of factors. So choose appropriately based on your current need.
Re: Vb.net And Online Database by walterjnr(op): 9:30pm On May 30, 2019
Bros1:
Dear Walterjnr,

The architecture behind this kind of design is flawed and may be impractically to implement.

SQL Server is not build to act like a web server.

One of the issues with this your line of thought is that Sql Server is configured by most hosts to accept 1 or 2 simultaneous connections per database.

As u plan to distribute your client VB.net app to many users on different machines and Ip credentials, the vb.net will be creating multiple instances of ADO.net connections to the database. This can lead to performance penalties and security issues as your connection string has a large surface area for hacking exploits.

In the alternative you can create a data layer vb.net application (server) to talk to the db using 1 sql server connection instance. Your VB.net apps distributed here and there can feed the data layer application and retrieve the required information from the db. This is a better approach

Thanks
Thanks man like this.
1 Reply

Dot Net And Java Programmer Needed • VB. NET Programmers Let's Connect Here. • VB. NET Expiration Date Alert • 2 • 3 • 4

I Urgently Need Your Help • Reasons You Should Hire A Developer For Your Next Mobile App Project • See What My System Is Showing, Please Who Can Help Me With Solution To This