同一个数据源名称 有两个链接字符串 怎么实现先判断第一个 如果第一个链接不成功 就用第二个字符串链接呢?确保两个都不能链接的时候再弹出错误提示,如果有其中一个可以连接就不弹出错误提示
If e.name = "kj222" Then
e.Connec tionS tring = "Pro vider=SQLO LEDB.1;Passw ord=kj222;Persist Sec urity Info=True;User ID=sa;Initial Cata log=BW_KJ222;Data Sour ce=DESKTOP-4HGMIGM\SQLEXPRESS"
e.Connec tionS tring = "Pro vider=SQLO LEDB.1;Passw ord=kj222;Persist Sec urity Info=True;User ID=sa;Initial Cata log=BW_KJ222;Data Sour ce=WIN-RR3MKL7U9ON\SQLSERVER2008"
ElseIf e.name = "BW_HR" Then
e.Connectio nString = "Pro vider=SQLO LEDB.1;Pass word=kj222;Persist Secur ity Info=True;User ID=sa;Init ial Cat alog=BW_HR;Data Sou r ce=DESKTOP-4HGMIGM\SQLEXPRESS"
e.Connectio nString = "Pro vider=SQLO LEDB.1;Pass word=kj222;Persist Secur ity Info=True;User ID=sa;Init ial Cat alog=BW_HR;Data Sou r ce=WIN-RR3MKL7U9ON\SQLSERVER2008"
End If
[此贴子已经被作者于2021/7/12 15:41:09编辑过]