SQL Connection & Stored Procedure - Timeout Parameters

Need help Database
1

Hello everybody!

My application is working perfectly with SQL Server RDS on Azure, or almost perfect.

I need to call a stored procedure that takes 45 seconds to be complete and Bubble’s SQL connector returns a timeout message (15000ms).

I have already tried to change the connection with the indicated parameters but without success, as in the examples below:

mssql://MyUser:MyPwd@MyServer.database.windows.net:1433/MyDB?encrypt=true&ConnectionTimeout=120
mssql://MyUser:MyPwd@MyServer.database.windows.net:1433/MyDB?encrypt=true&Connection%20Timeout=120
mssql://MyUser:MyPwd@MyServer.database.windows.net:1433/MyDB?encrypt=true&requestTimeout=120
mssql://MyUser:MyPwd@MyServer.database.windows.net:1433/MyDB?encrypt=true&request%20Timeout=120
mssql://MyUser:MyPwd@MyServer.database.windows.net:1433/MyDB?encrypt=true&CommandTimeout=120
mssql://MyUser:MyPwd@MyServer.database.windows.net:1433/MyDB?encrypt=true&Command%20Timeout=120
mssql://MyUser:MyPwd@MyServer.database.windows.net:1433/MyDB?encrypt=true&Timeout=120

and others…

I’ve searched the Bubble documentation and a lot of internet sites/articles but haven’t found a solution.

Can anyone help me?

Thank you very much!

2

Bubble Support, reply me: There are no timeout options to set in SQL connection, unfortunately…

4

I thought I posted this already somewhere but in case I didn’t, you could try out our paid SQL Plugin which allows you to set the timeout for MSSQL connections. I have not tested the timeout functionality for large timeouts, so let me know here (on this post) if you try it and run into any issues.