I am using this mssql Ballerina package to connect to my Azure SQL database.
Error:
error: Error in SQL connector configuration: Failed to initialize pool: Connection reset ClientConnectionId:5d5b4f8b-7e6e-43d0-bce3-5fe79e403088 Caused by :Connection reset ClientConnectionId:5d5b4f8b-7e6e-43d0-bce3-5fe79e403088 Caused by :Connection reset
at ballerinax.mssql.1:createClient(Client.bal:173)
ballerinax.mssql.1:init(Client.bal:49)
viggnah.test_apis.0.$anonType$_1:$get$test(testAPI.bal:45)
Code:
import ballerina/sql;
import ballerina/http;
import ballerinax/mssql.driver as _;
import ballerinax/mssql;
configurable int servicePort = 9090;
configurable string user = "admin@my-server";
configurable string host = "my-server.database.windows.net";
configurable string database = "my-db";
configurable int dbPort = 1443;
configurable string password = "***";
service / on new http:Listener(servicePort) {
resource function get test(string id) returns error? {
mssql:Client|sql:Error dbClient = new(host=host, user=user, password=password, database=database, port=dbPort);
if dbClient is error {
return dbClient;
}
}
}