Visual Basic app to connect to an online database

Question

Visual Basic app to connect to an online database

Doom 1

Hey Microsoft Community,

I have an app with a login (name, email, and password) form and since it's hard to keep track of how many users are using the app, I want to know if it's possible and how to connect my Visual Basic application to an online database where I can access it. The app is made in Visual Basic 2010 Express Edition and I would need some advice on how to do this database + some good online, 24/7 database hosting services. Searched all over youtube but looks like an open desert with no answers.

Thanks for reading and please help me with this, I would really use a database.

Sam of Simple Samples 5,511 Reputation points

2021-07-21T02:26:36.627+00:00

I converted this comment to an answer; see below.
Anurag Sharma 16,961 Reputation points

2021-07-26T05:07:19.2+00:00

Hi @Doom , just wanted to check if you need any more details on this. You can accept the answer if it helped.

3 answers

Your answer

Sam of Simple Samples 5,511 Reputation points

2021-07-21T02:26:36.627+00:00

I converted this comment to an answer; see below.
Anurag Sharma 16,961 Reputation points

2021-07-26T05:07:19.2+00:00

Hi @Doom , just wanted to check if you need any more details on this. You can accept the answer if it helped.

Answer 1

Deleted

This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

Comments have been turned off. Learn more

Answer 2

Creating and connecting to an Azure database is the easy part. There are abundant resources about that. For one thing, most anything showing how to connect to a SQL Server database can be used to connect to an Azure database; you simply use an appropriate connection string.

The hard part is keeping track of who is using the app. Is this one system executing many instances of the application? Probably not. I assume it is many systems, each executing separate instances. So you need to have a way for them to communicate. You can do that using a peer-to-peer mechanism (which would be too complicated) or you can create a server that each of them communicates with. Where will that server be? You can create a service in Azure that provides that.

Answer 3

Sam of Simple Samples 5,511

I did a little research and found Application Insights. I know nothing except what that page and the following says.

0 comments