Private Sub Form_Load() ON ERROR GOTO errMsg Dim adoConn As ADODB.Connection dim strConn as String Set adoConn = New ADODB.Connection adoConn.CursorLocation = adUseClient strConn= "Provider=SQLOLEDB.1;Data Source=192.168.0.1;Initial Catalog=TEST;User ID=xxxxx;Password=yyyyy" adoConn.Open strConn eixt sub errMsg: msgbox "sql连接失败" end sub其中Data Source表示的是当前所连接的SQL服务器名称 Initial Catalog表示的当前所连接数据的名称 User ID登录用户名 Password密码
ON ERROR GOTO errMsg
Dim adoConn As ADODB.Connection
dim strConn as String
Set adoConn = New ADODB.Connection
adoConn.CursorLocation = adUseClient
strConn= "Provider=SQLOLEDB.1;Data Source=192.168.0.1;Initial Catalog=TEST;User ID=xxxxx;Password=yyyyy"
adoConn.Open strConn
eixt sub
errMsg:
msgbox "sql连接失败"
end sub其中Data Source表示的是当前所连接的SQL服务器名称
Initial Catalog表示的当前所连接数据的名称
User ID登录用户名
Password密码