默认外部数据库链接,我想在本地优先,是不是一定要默认就是本地IP,还是 随便设计内外IP 通过BeforeConnectOuterDataSource修改即可
Provider=SQLOLEDB.1;Password=yifanXXXX;Persist Security Info=True;User ID=sa;Initial Catalog=city;Data Source=yifanXXX.oicp.net,307
此主题相关图片如下:企业微信截图_20210404002514.png

我希望优先链接本地IP,如果检测不到本地数据库ip 就直接链接远程IP
Dim a As String = "192.168.0.1" '本地局域网IP
Dim b As String = "yifanxxxx.oicp.net,30798" '远程IP
Select Case e.Name
Case "city","dufox" ,"rizhi" '数据源
If Network.Ping(a,1000) = True Then
e.ConnectionString = e.ConnectionString.Replace(b, a)
End If
End Select
根据网路链接情况提示客户当前链接的是内网还是外网
[此贴子已经被作者于2021/4/6 1:01:58编辑过]