using ADO from Excel 2007

T

TrumpCoup

We just upgraded to Vista from XP and on some PCs get an error message
about MSRDO20.dll not being installed when I try and connect to a
SYBASE database using ADO.
I have asked the technology group for help installing this (some PCs
have it, some don't)

My question is - fromteh VBA Developer screen (inside Excel) under
Tools - References - which referneces do I need to include to be able
to use ADO?

What I'm wondering is if in Vista there is a reference I should add in
that I have not used before.

Is it sufficient that I just downlaod MSRDO20.DLL from the internet
and hope it installs/registers correctly? Is that all thats needed?
 
G

GS

TrumpCoup formulated the question :
We just upgraded to Vista from XP and on some PCs get an error message
about MSRDO20.dll not being installed when I try and connect to a
SYBASE database using ADO.
I have asked the technology group for help installing this (some PCs
have it, some don't)

My question is - fromteh VBA Developer screen (inside Excel) under
Tools - References - which referneces do I need to include to be able
to use ADO?

What I'm wondering is if in Vista there is a reference I should add in
that I have not used before.

Is it sufficient that I just downlaod MSRDO20.DLL from the internet
and hope it installs/registers correctly? Is that all thats needed?

The lib to use ADO is called Microsoft ActiveX Data Objects n.n
Library, where n.n is the version installed on your machine. The latest
version I have installed (n.n=2.8) is msado15.dll. Previous versions
were '.tlb' files preceeded by their version, as follows:

ADO 2.0: msado20.tlb
ADO 2.1: msado21.tlb
ADO 2.5: msado25.tlb
ADO 2.6: msado26.tlb
ADO 2.7: msado27.tlb

HTH
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top