Refresh Method of ADODC ignores new value of ConnectionString Property 1

[jerjim]

Let me restate my previous question succintly.

I have a data control whose ConnectionString property was of course set at design time. I now set the ConnectionString property at runtime
with a new value and then call the refresh method, like this.

With adodc
.ConnectionString = new value of connection string
.Refresh
end with

The Refresh method looks for the old value of the connection string property.
Even though, when I checked in the debugger, the Connection string is set to the new value.

SO WHAT IS THE CORRECT PROCEDURE FOR SETTING THE CONNECTION STRING PROPERTY OF AN ADO DATA CONTROL AT RUNTIME.

 

[harmmeijer]

I was using Microsoft ADO Data Control 6.0 (OLEDB) and it worked fine, the connection string is set immediately though you do not need refresh. You need to refresh if the RecordSource property is changed.
Try to set a valid RecordSource property before refreshing.

Private Sub Command1_Click()
Debug.Print Adodc1.ConnectionString
Adodc1.RecordSource = "select * from muziek"
Adodc1.Refresh
Adodc1.ConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.3.51;Data Source=muziek.mdb;"
Debug.Print Adodc1.ConnectionString
End Sub

Private Sub Form_Load()
Adodc1.ConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.3.51;Data Source=d:\muziek.mdb;"
End Sub