OLEDB Problem

Hi Experts,

I have a problem with OLEDB Connection.  I have a MSACCESS Table with 200 fields when i select a recordset using OLEDB it takes nearly 10 seconds fetch records.  Whereas it works good with ODBC.  My project is already built on OLEDB so I could not change now. Your help in solving this problem is very much appreciated. ( I use ADO 2.5 libraries with service pack 5)
vksharathAsked:
Who is Participating?
 
SpideyModConnect With a Mentor Commented:
per recommendation

SpideyMod
Community Support Moderator @Experts Exchange
0
 
Roshan DavisCommented:
But in MSDN says

"You cannot call OLE DB interfaces directly from Visual Basic because OLE DB is a pointer-based interface. A Visual Basic-based client can access an OLE DB data source through ADO."

in the Topic "Accessing Heterogeneous Data with Microsoft SQL Server 7.0"

Roshmon
0
 
TimCotteeHead of Software ServicesCommented:
The issue I assume is that you are using OLDEB 4.0 with a Microsoft access 97 database. If you change the provider to 3.51 instead of 4.0 you should see a performance increase. The reason being that the OLEDB.4.0 provider is significantly slower at accessing older access databases than the specific provider for access 97. Don't ask me why, ask Microsoft!
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
Éric MoreauSenior .Net ConsultantCommented:
how many rows?

do you have a where clause?
0
 
vksharathAuthor Commented:
No it is not with MS ACCESS 97.  It is with MS ACCESS 2000.
0
 
DanRollinsCommented:
Hi vksharath,
It appears that you have forgotten this question. I will ask Community Support to close it unless you finalize it within 7 days. I will ask a Community Support Moderator to:

    Refund points and save as a 0-pt PAQ.

vksharath, Please DO NOT accept this comment as an answer.
EXPERTS: Post a comment if you are certain that an expert deserves credit.  Explain why.
==========
DanRollins -- EE database cleanup volunteer
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.

All Courses

From novice to tech pro — start learning today.