Share via

small Database system remote connection

Mothana taher 20 Reputation points
2023-06-24T11:59:28.6466667+00:00

Hi..

i have a small Database system(Desktop application), it's built for small market businesses, the programming language used is VB6 and sql server 2022 what's the most suitable, appropriate and affordable method run the system through several workplaces using Azure plattfrom ?

Azure SQL Database

Answer accepted by question author

Alberto Morillo 35,506 Reputation points MVP Volunteer Moderator
2023-06-24T12:28:57.8+00:00

Please allow me to recommend you Azure SQL Elastic Pools. An Azure SQL Elastic Pool is a shared resource model for managing and scaling multiple databases that have varying and unpredictable usage demands. The databases in an elastic pool are on a single server and share a set number of resources (DTUs) at a set price. This allows for higher resource utilization efficiency and cost savings, especially for databases that have low average utilization with some infrequent high spikes. Please read more about them here.

You can connect to an Azure SQL Elastic Pool database from VB6 using below connection string:

sConnectionString = "Provider=SQLNCLI11;Password=PASSWORD;User ID=USER@SERVERNAME;Initial Catalog=DATABASE;Data Source=tcp:SERVERNAME.database.windows.net;"

The connection string uses SQL Server 2012 Native Client which you can download from here.

Was this answer helpful?

0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

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.