p2p.wrox.com Forums

Need to download code?

View our list of code downloads.

  Return to Index  

asp_databases thread: re: ADO 2.5. Have you heard of this MDAC2.5 problem?

Message #1 by markc@w... on Mon, 17 Jul 2000 15:52:28
-----Original Message-----

From: Paul Wolborsky [mailto:paulw@p...]

Sent: 17 July 2000 04:18

To: Support@W...

Subject: re: ADO 2.5. Have you heard of this MDAC2.5 problem?


    I'm a big Wrox fan.  And not so big a fan of Microsoft right now.

    I've made numerous attempts to install MDAC2.5 on my NT4.0 Server and

Win98 Development machine, and found that 1) I didn't have a Data Link 


type available, 2) no MSADC folder on my IIS (also version 4), 3) ISAM


    I ran Component Checker, a program made available by Microsoft, and

found 8 file errors, mostly version mismatches.  After uncompressing

MDAC2.5, I found out that sure enough, the critical files included

(OLEDB32.dll, Oleaut, ex) were of the wrong version.

    I deinstalled MDAC25, replaced it with MDAC21.  It works.  Now the

problem is, my IE5 browser won't accept the following VBscript syntax...

    dim keyRS, keyConn

    set keyRS = Createobject("ADODB.Recordset")

    set keyConn = Createobject("ADODB.Connection")

'Error - ActiveX controls unable to create ADODB object


    dim keyRS As New ADODB.Recordset


    dim keyRS As ADODB.Recordset

    set keyRS = New ADODB.Recordset

Further background:  Yes, the ADODB 2.1 library is referenced, and 


in Object Browser in the VBA editor.

    The declaration of the RDS.Datacontrol passed muster with the 


    Any ideas on why this syntax won't work in a 2.1 environment?  Or, 


is the correct syntax?   Or, what further settings must I make on my

machines so that this will work?

    And, have you heard any word from Microsoft about a fix release for 



    I am the sole IT person at a small non-profit, responsible for 


our first Intranet-based database system with grave strategic value.  All 


have to go on are your books, John Papa's ADO 2.5 and ASP 3.0, and what

little information I can glean from the vast spiderweb of Microsoft's

Web-page.  And asking them these questions?  Forget it, we're not very 


I'm falling behind in my project, and this snag is the reason why, so, any

help you can offer would be greatly appreciated.

    Thank you for your time, I hope to hear from you soon.

Paul Wolborsky

IT Administrator

Project HIRED


Assisting People with disabilities gain competitive employment

  Return to Index