ADO and DAO

[paulw]

I have an environment where I cannot control the set-up

The DAO data control works fine. The ADO data control won't work at all.

I can't get either one to work in code...

What files do I need to set the environment up for ADO with Access 97. At home, I have just bunged on every file I can find and it works great...

Hopefully,

P.

[kovan]

not sure what you wanna do man
can ya elaborate"?

[paulw]

Well, how does the DAO DataControl connect? What DLLs does it use etc. Why can't I do it through code?

ADO is another matter, but I am not sure which files that needs to be supported.

General interest q really, not vital.

P.

[rameshbaboov]

hi,

I am not sure what you want. What i think is ADO and DAO are not installed properly. You can get the ADO from MDAC at the microsoft website's download section.

regards

[paulw]

That is what I think but I have no control over my environment

I need to know which DLLs are needed for ADO and which references do what so that I can argue it out with my IT department...

Cheers,

P.

[shippyatdrexel]

I am having the same problems. I have developed an application on Windows 98 with Access 2000 and VB6 using ADO, but I have found that it will not install on systems running Windows NT, Access 97, and no VB. I have found out that, in order to use ADO, you must have MDAC installed on the client pcs. The Package and Deployment Wizard includes the MDAC install (MDAC_typ.exe). The problem is that installing MDAC can cause all kinds of problems (a.k.a. Dll Hell). I think I'm going to switch to DAO. I believe that DAO does NOT require MDAC, and you only need to include the DAO .dll (dao360.dll in my case) in the install to make it work. I am not positive this is true though. I'm looking for answers too.

Here are a couple of sites that may help:
http://www.able-consulting.com/ADO_Faq.htm#Q4
http://www.microsoft.com/data/MDAC21info/MDACinstQ.htm
http://msdn.microsoft.com/library/te..._redistmdac.ht

You can also go to this site to find out which dlls are installed with which packages:
http://support.microsoft.com/service...p?fr=0&sd=msdn

Good luck!

[makai]

maybe the following demos will help

http://pages.about.com/vbmakai/dao.htm
http://pages.about.com/vbmakai/ado.htm