, . . 23.5 ( ), .
. 23.5
( )
, ( ) | |||
UserForm | Name | Form1 | , . |
Caption | SQL-DMO (1) | . | |
Frame | Name | Frame1 | |
Caption | SQL Server | Combo1. | |
ListBox | Name | List1 | . |
CommandButton | Name | Command1 | . |
Caption |
23.1 , . 23.6 . 2 sqlOb SQLDMO.SQLServer. 5 SQLDMO.SQLServer, 6 Connect ( , ). 8 obj1 . 1012 List1 ( Databases).
23.1
1: Private Sub Form_Load()
2: Dim sqlOb As SQLDMO.SQLServer
3: Dim obj1 As Object
4:
5: Set sqlOb = New SQLDMO.SQLServer
6: sqlOb.Connect "TOSHIBA-USER", "Nata", "Nata"
7:
8: Set obj1 = sqlOb.Databases
9:
10: For Each dbs1 In obj1
11: List1.AddItem dbs1.Name
12: Next dbs1
13:
14: End Sub
15:
16: Private Sub Command1_Click()
17: Unload Me
18: End Sub
. 23.6
( )