binding DataGrid to adodc

Hi team

I am trying to bing a datagrid to an ADODC with the code below.

VB Code:

adoStoreCodes.ConnectionString = PU.PradaUtilityDBConnection
    adoStoreCodes.RecordSource = "SELECT BondNo, LocationID FROM LocationsDetail"
    adoStoreCodes.Refresh
    Set dgdStoreCodes.DataSource = adoStoreCodes
    dgdStoreCodes.Rebind

It works fine in the IDE but won't work on client machine. I get an error "Cannot initialize data bindings"

Is there something I need to distribute with the app?

Anny other ideas?

Thanks FW

You don't need to Rebind. The records should be displayed automatically when you set the DataSource property.

Also you may try this:

Code:

---

adoStoreCodes.CursorLocation = adUseClient

---

However, if the number of records is too large, then you would prefer adUseServer.