red_evolve 1 Posting Whiz

Greetings.
On my previous project, I have used the adodc.
According to a friend of mine, he said that using a data control is easier (implementation/coding matter).
I am still very confused with the difference of this 2 controls. :-|
I am not sure which connection string is to apply for which of those 2 controls.

Private Sub Form_Load()
    Dim con As New ADODB.Connection
    Dim rs As New ADODB.Recordset

    con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=db1.mdb;Persist Security Info=False"
    con.Open
    rs.Open "select com_name from competency", con, adOpenKeyset, adLockOptimistic
End Sub

Is the above code for a Data control?
Alright, about DSN, I have to set up the DSN for an adodc.
What about Data control? Do I have to create a DSN too?
Please advise. :confused:

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.