现有一远程SQL数据库,地址是A,做了数据库同步,地址是B
若主体数据库A连接失败,希望能自动快速连接到备份数据库B
请问在使用ADO连接时候,连接语句怎么写?单一数据库的连接语句是这样:
TempConn.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;UID=" + MainDbUser + ";PWD=" + MainDbPassword + ";Initial Catalog=" + MainDbName + ";network address=" + MainDbSource
若主体数据库A连接失败,希望能自动快速连接到备份数据库B
请问在使用ADO连接时候,连接语句怎么写?单一数据库的连接语句是这样:
TempConn.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;UID=" + MainDbUser + ";PWD=" + MainDbPassword + ";Initial Catalog=" + MainDbName + ";network address=" + MainDbSource
到是要求使用SQL Server Native Client ODBC 驱动程序
on error goto errhandler
TempConn.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;UID=" + MainDbUser + ";PWD=" + MainDbPassword + ";Initial Catalog=" + MainDbName + ";network address=" + MainDbSourcetempconn.openexit suberrhandler:
if err.number=连接超时错误号 then
TempConn.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;UID=" + MainDbUser + ";PWD=" + MainDbPassword + ";Initial Catalog=" + 备用数据库 + ";network address=" + MainDbSource
resume
end if
'没有处理备份数据也打不开的情况,你自己处理
end sub