连接重试计数并在SQL连接字符串中连接重试间隔 [英] connect retry count and connect retry interval in SQL connection string

问题描述

您好

在ODBC连接配置表单中，有一种设置连接重试计数和连接重试间隔的方法，我们想知道是否有办法实现连接重试.net / sql连接字符串而不更改应用程序的代码并手动实现
a系统重试？似乎连接字符串和.net连接构建器类中缺少这两个属性！

祝你好运

---

穆罕默德B。

解决方案

不直接 - 你需要做这样的事情：

https://docs.microsoft.com/en-us/sql/connect/ado-net/step- 4-连接-弹性到SQL与 - ADO-净？视图= SQL服务器-2017

Hi

In ODBC connection config form there is a way to set a connect retry count and a connect retry interval, we are wondering if there is a way to implement a connection retry in .net/sql connection string without changing the code of the application and implement a system retry manually? Seems those two properties are missing from the connection string and from the .net connection builder class!

Best regards

---

Mohamed B.

解决方案

Not directly - you would need to do something like this:

https://docs.microsoft.com/en-us/sql/connect/ado-net/step-4-connect-resiliently-to-sql-with-ado-net?view=sql-server-2017

这篇关于连接重试计数并在SQL连接字符串中连接重试间隔的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！