Bug on "ADODB.RECORD" ActiveX object on Windows Vista, 7, 8, Server 2008, Server 2012. This Activex is "broken" RRS feed

  • General discussion

  • Hi everyone :)

    Microsoft support staff asked me to post this topic here, so am doing.

    There is a bug on 1 of the ADO objects, the "ADODB.record". When you try to script it to retrieve some file located in a webserver it returns an error that the object is "closed".

    The problem is with the "MSDAIPP.DSO" provider which does not exist anymore since Windows Vista. The module responsible for it is "MSDAIPP.DLL" and someone from the Microsoft team told me the dll was removed for security purposes. Could we know what security risks it involved ?

    Also if we try to use the "open" method using other available providers or an SQL statement, it also returns an error. It seems this ActiveX object was intended to function only with this "MSDAIPP.DSO" provider. So it is currently "broken".

    Possible solutions:

    1) Provide a new light "MSDAIPP.DLL" without security risks only for providing this "MSDAIPP.DSO" provider to ADODB.record object and nothing more.

    2) change the ADODB.record to work with other providers and have another default provider capable of retrieving files on webserver.

    And then provide the updated module(s) in a future update.

    Wednesday, July 17, 2013 6:45 AM

All replies

  • Hi,

    Thank you for your feedback and sharing. Since this issue is also database related, you can also post in SQL forum.


    Vincent Wang
    TechNet Community Support

    Thursday, July 18, 2013 6:54 AM
  • You should be able to use the FileSystemObject control depending on the method of authentication. This will access a WebDAV share via the WebClient service.

    The path will need to be modified to a UNC format.

    Instead of:




    Wednesday, November 20, 2013 11:11 PM