Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
using ADO from Excel 2007
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
using ADO from Excel 2007
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 -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 files not showing on screen when opened in Excel 2007 | Setting up and Configuration of Excel | |||
Conflict in excel 2007 with Outlook 2007 attachment excel | Excel Discussion (Misc queries) | |||
Labels: Unable to import all records Excel 2007 to Word 2007 Mailm | Excel Discussion (Misc queries) | |||
Excel 2007, I write macros in 2003 is 2007 similar for VBA? Pros andcons please | Excel Programming | |||
Excel 2007 Macro Help (Excel 2003 not working in 2007) | Excel Discussion (Misc queries) |