To KenjiSato: 动态连接到SQL SERVER

zyz

你将这句

sConnectionString = "ROVIDER=SQLOLEDB.1ASSWORD=" & sPWD & "ERSIST SECURITY INFO=TRUE;USER ID=" & sUID & "; INITIAL CATALOG=" & sDatabase & ";DATA SOURCE=" & sSvrName

改为：

sConnectionString = "PROVIDER=SQLOLEDB.1;PASSWORD=" & sPWD & ";PERSIST SECURITY INFO=False;USER ID=" & sUID & "; INITIAL CATALOG=" & sDatabase & ";DATA SOURCE=" & sSvrName

即可[em26]

zyz

在我这里没有这个问题，关键是退出前要断开连接。[em26]

zyz

搞定了？