binding DataGrid to adodc

[freewilly]

Hi team

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

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

[bumbala]

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

Also you may try this:

adoStoreCodes.CursorLocation = adUseClient

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