Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 383
  • 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
 
TimCotteeHead of Software ServicesCommented:
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
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
TimCotteeHead of Software ServicesCommented:
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
 
TimCotteeHead of Software ServicesCommented:
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
 
TimCotteeHead of Software ServicesCommented:
Oh not a good grading record indeed ahmed!
0
 
ahmed021399Author Commented:
Hope this would make me a good grader.
0
 
TimCotteeHead of Software ServicesCommented:
Well it is indeed a start ahmed.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

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