Visual Basic app to connect to an online database

Doom 1 Reputation point
2021-07-20T18:57:22.98+00:00

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.

Azure SQL Database
Developer technologies | VB

3 answers

Sort by: Newest
  1. Sam of Simple Samples 5,511 Reputation points
    2021-07-21T02:59:51.783+00:00

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

    Was this answer helpful?

    0 comments No comments

  2. Sam of Simple Samples 5,511 Reputation points
    2021-07-21T02:29:45.207+00:00

    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.

    Was this answer helpful?

    0 comments No comments

  3. 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

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.