O.K. I'm getting close. So far this what I was able to come up with

GLOBAL myFirstConnect as New Connection

Sub Connect()

myFirstConnect.Open

End Sub

Sub OpenMyFirstSQLTable()
Dim mtbl as New Recordset

mtbl.open "SELECT name FROM myFirstTable where Name = "Jimmy"

if mtbl.EOF = false
<fail safes here?>
end if

End Sub

I've gotten ADO (..not DAO as I had accidentally mentioned) 2.0 referenced into the scene but can't find the DataEnvironment(DE) component or object I need to enter the following parameters to simply use the
mtbl.open line.

Provider=??
Security=??
Persist Security Info=??
Initial Catalog=??
Data Source=??

Can some one direct me too this?