尽管在Conn String中有300秒的超时

发布于 2025-01-23 20:51:36 字数 497 浏览 0 评论 0原文

我正在开设与SQL Azure无服务器数据库的连接。该数据库如果未使用1小时就会暂停。

我通过Azure函数连接到此数据库。 conn.open（）;尽管连接字符串将超时设置为300秒，但在10秒后排出了线。该数据库也不在此连接尝试中毫无疑问。

我以为当建立连接时会重新启动，这可能需要几分钟，但是代码似乎忽略了连接字符串超时值。

我应该设置此超时的其他地方吗？

conn字符串：

Server=tcp:myDBServer.database.windows.net,1433;Initial Catalog=sample-Db;Persist Security Info=False;User ID={your_user};Password={your_password};MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=300;

原文

I am opening a connection to a sql azure serverless database.
This database pauses if unused for 1 hour.

I connect to this database via an azure function. The conn.open(); line times out after 10 seconds despite the connection string having timeout set to 300 seconds.
The database is also not unpausing on this connection attempt.

I had assumed that when a connection is made it will restart, and this may take a few minutes but the code seems to be ignoring the connection string timeout value.

Is there somewhere else i should set this timeout?

Conn String:

Server=tcp:myDBServer.database.windows.net,1433;Initial Catalog=sample-Db;Persist Security Info=False;User ID={your_user};Password={your_password};MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=300;

分享到QQ

分享到微博