Help with understanding ADO

[deadseasquirrels]

Some very gracious people have been helping me with trying to use VBA to hit an oracle database. I've gotten as far as this code below:

Private Sub SQLTest()

    Dim dbsNDF As New ADODB.connection
    Dim connString As String
    Dim dbRS As Object
    Dim sqlString As String
    
    connString = "Provider=MSDAORA.1;Password=[pwd];User ID=[id];Data Source=DKARCH1.WORLD;Persist Security Info=True"
    dbsNDF.connectionString = connString
    dbsNDF.Open

    sqlString = "Select SO.STUDENT.LAST_NAME FROM SO.STUDENT WHERE First_Name = 'Michelle' and LAST_NAME like 'De%'"
'    Debug.Print MsgBox(sqlString)
 '   Stop
    
    Set dbRS = dbsNDF.Execute(sqlString)
    
    Cells(106, 1).CopyFromRecordset dbRS
    
    If dbRS.EOF And dbRS.BOF Then
        MsgBox "End of File"
        GoTo CleanUpAndClose
    Else

        dbRS.MoveFirst
        Do While Not dbRS.EOF
            If dbRS.RecordCount = 0 Then
                MsgBox ("empty")
            End If
            MsgBox (dbRS.Fields(1).Value)
            dbRS.MoveNext
        Loop
    End If
    
CleanUpAndClose:
    dbRS.Close
    dbsNDF.Close
    Set dbRS = Nothing
    Set dbsNDF = Nothing
End Sub

with very simple SQL scripts the above script works. But now the SQL string that is in there right now. I don't know what technology this is even, is this ADO? Whatever it is, I'd like to learn more, so that I can more properly debug the issues myself. For example right now I have no idea what

 If dbRS.EOF And dbRS.BOF Then
        MsgBox "End of File"
        GoTo CleanUpAndClose
    Else

        dbRS.MoveFirst
        Do While Not dbRS.EOF
            If dbRS.RecordCount = 0 Then
                MsgBox ("empty")
            End If
            MsgBox (dbRS.Fields(1).Value)
            dbRS.MoveNext
        Loop
    End If

that whole section is about. If somebody can give me a hand, explain, or even point me to some documents that can explain I would greatly appreciate it. Thank you.

 

[BrianB]

If you put the cursor into a command word in the VB Editor and press F1 key then you get help.

Also have a look at View/Object Browser. You can use F1 there too.

Otherwise use the Help menu.

Do a Google seach on terms/keywords.

I have learned more this way than any other.

 

[deadseasquirrels]

I find the help file within word pretty inadequate for ADO. I need more structural explanations.

 

[XL-Dennis]

May I suggest that You buy a book on the subject.

Books are still indeed highly valuable as sources for good knowledge.

The advantage compared with online resources is that books have been reviewed both by the publishers as well as people with high technicall skillness & knowledge.

You find two good books here for ADO:
http://www.excelkb.com/article.aspx?id=10142&cNode=7D1Y4I


You can also search for the ADO210.chm file on Your local drive as a start.

 

[deadseasquirrels]

The website wiht the list of books is a helpful resource, I'll look those books up. Thanks.

However I've always felt the internet was actually the best place. I found an equal amount of errors from what I've read in printed form as what I've read on the internet, but I find the internet is more up to date, and the people who decide to put something up on the internet usually use more real-life examples, and colloquial speak. Much like reading financial books, the internet is just more up to date.

There may not be many java developers here, but if there are, I think they would agree that the internet and the sun site is by far better than 95% of the books out there (there are actually books that are just printed version of the site). But thanks for the suggestion anyhow.