• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 382
  • Last Modified:

DBGrid doesn't work

Why is that DBGrid do not work with ADO data control. I have DBGrid with SP3 and VB6 with SP4 and Access 2000. I need help urgently. Please help!! anybody!!
(I get the message no compatible data source found.)

ADODC connection i use as follows:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\NewPos\NewPos.mdb;Persist Security Info=False
0
ahmed021399
Asked:
ahmed021399
  • 5
  • 3
  • 2
  • +1
1 Solution
 
ahmed021399Author Commented:
For any more clarifications please ask.
0
 
TimCotteeCommented:
Simply because the DBGrid control was not designed to be compatible with the ADODB.Recordset object. If you have to use ADO rather than DAO then I would suggest that you use the DataGrid control which is very similar to the DBGrid control but does support the ADODB.Recordset (and hence the ADO Data Control - ADODC).

Essentially your options are:

1) Use DAO not ADO
2) Use another Grid such as the DataGrid.

You will NOT get any answer that will enable you to use the DBGrid with any form of ADO recordset.
0
 
corvanderlindenCommented:
>>You will NOT get any answer that will enable you to use the DBGrid with any form of ADO recordset.

Tim is right

I would suggest stick to ADO, but opt for another grid
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
TimCotteeCommented:
Indeed that would be my preference but for some reason ahmed may prefer DAO and the DBGrid instead.
0
 
corvanderlindenCommented:
Was just thinking about .NET and the future
0
 
TimCotteeCommented:
I agree entirely, I abandoned DAO pretty much as soon as ADO 2.0 came out and haven't touched it since except to deal with problems here and on similar forums. ADO.NET may not be identical to ADO but it is certainly more similar than DAO so would be a logical step. However there is no accounting for personal taste.
0
 
pierrecampeCommented:
you can use the dbgrid with ADO or with any kind of data for that matter
just use it in unbound mode
as for DAO versus ADO
i love ADO wonderfully flexible
but i never use it against an access db
againts an access db DAO is magnitudes faster then ADO
0
 
pierrecampeCommented:
btw it is not an either/or situation you can use both ADO and DAO in the same project
0
 
pierrecampeCommented:
oops forgot to look at your grading record
PLEASE do NOT accept my comments as an answer
0
 
TimCotteeCommented:
Oh not a good grading record indeed ahmed!
0
 
ahmed021399Author Commented:
Hope this would make me a good grader.
0
 
TimCotteeCommented:
Well it is indeed a start ahmed.
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 5
  • 3
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now