使用sqldmo对象
引用microsoft sqldmo object library
microsoft sqlnamespace object library
Dim srvSQL As SQLServer
Private Sub cmbView_Click()
On Error GoTo eh_sqldmo
'Initializing SQL DMo Object
Set srvSQL = New SQLServer
srvSQL.Connect srvName, user, Pass
'Set property of rtbox to text of selected View
rtBox.Text = srvSQL.Databases("pubs").Views("视图名").Text
srvSQL.Disconnect
Set srvSQL = Nothing
Exit Sub
eh_sqldmo:
MsgBox Err.Description, vbCritical, "Error Initializing SQL DMO Object"
End Sub