Data control & DataGrid ocx problem

[Tomexx]

Hi,
I’m using a VB6 Pro SP4 (the latest). Here’s the problem:
1. I add Data control and DataGrid control (MSDATGRD.OCX) to the form
2. I connect Data control to Biblio.MDB and set RecordSource to one of the tables (Authors)
3. When I try to set DataSource of DataGrid I get the following error

Error Message:
No compatible data source was found for this control. Please add an OLEDB data source such as Data Enviroment or Microsoft ADO Data Control to the form or project.

I also get this message:

Error Message:
Can't bind this control to Data1. Select a different data source (eq - ADODC1, or DataEnviroment1...)

I would really appreciate your help for I need to use data control & bound it to data grid ocx.

Thanks.

Hi, the error message only means that the Data control u r using is not compatible to Data Grid. It is like this, when Microsoft introduced ADOs they have provided new controls also like this Data Grid and all. So, even ADODC is a new control i.e., data control provided by ms for use with ADOs. SO, go ahead and use ADODC instead and you wouldnt find much difference and infact feel much more interested in using it. To use Data Grid use ADODC. (Microsoft's New Data Control for ADOs). Hope this helps u.

All the best...vijay

[Tomexx]

Thanks, but how am I gonna get a new Data control, since it's an intristic control? Or should I get an updated DataGrid control?
Thanks

[Tomexx]

Anyone?

[Tomexx]

Any other thoughts?

[PJB]

go to Project|Components and add Microsoft ADO Control 6.0, connect that to your database then your grid to that

[Tomexx]

Ok, so there's no way for me to use the intristic Data control then? Am I going to have to use an external OCX (MS ADO control) for all my data manipulation instead?

[PJB]

if your dead set on using that data control then use a different grid, i don't necissarily consider the ADO an external control just because it doesn't show up in the toolbar by default

the 'intristic' control is the DAO data control, you
can use this one with the older version of the databound
grid.

if you want to use the newer grids (OLEDB = ADO) you
have to use the ADO data control (ADODC).

good luck

Sascha

[v_harish]

hi
if u want to use datagrid you have to use adodc
suppose if you want to use datacontrol only then you go with dbgrid control i.e. microsoft databoundgrid control foun in components
set dbgrid property to datasource=data1
and after that goto the form select the dbgrid and rightclick the mouse and select retrieve fields it will gives u total fields then run the form

ok bye
harish