Adodb.Record Activex Object seems to be broken RRS feed

  • General discussion

  • Since Windows Vista the Provider Msdaipp.dso (dll = msdaipp.dll) used by the Activex Object "Adodb.Record" used to open files, table inside MS Access MDB files, SQL Statements like "Select From * something" has been discontinued, because these OSes contained a builtin WebFolders module,  not needing this DLL, breaking all previous working codes that used the "Adodb.Record" Activex Object. I have tried using alternate providers like "Microsoft Excel Driver", "Microsoft Text Driver", "Microsoft Access Driver", "Microsoft Jet OLE DB Provider 4" (the name is this or similar) and then, to open the "Record", I used "Table1" for Microsoft Access file (yes the table name is exactly that), "[Shee1]" for Microsoft Excel file, Sql Statements for both of them including Microsoft Text Driver, this of course inclusing the providers mentioned above, and even anothe provider named (If I am not mistaken MSDADSO) but nothing works. The Error message is always the same, it says the connection is closed, seeming that only "MSDAIPP.DSO" provider works.

    Could someone (specially the Microsoft developer team) provide me an explanation and a solution for this ?

    If there is no solution, then the "Adobd.Record" Activex Object should have also been discontinued starting from Windows Vista.

    By the way I get no errors with "Adodb.Recordset". Ah, I tried opening an opened Recordset object, but also get an error.

    I have also tried the "MS Remote" provider and the "MSDAIPP.DSO" Provider in the webserver (it is correctly registered and the IIS user has read access to the directory. The IIS server is running on a Windows XP SP3 machine, and in there the "MSDAIPP.DSO" and "Adodb.Record" works pretty well, but it did NOT work. Anyways I read that the "MS Remote" provider will be discontinued in future Windows versions, so even if that worked I would run into problems in the future, so doesnt seem a good solution if thinking ahead.

    so, any explanations and a possible solution to get this Activex Object to work on Windows Vista, 7 and above ?

    look forward for a feedback.

    Thank you.


    Tuesday, May 7, 2013 7:31 AM

All replies

  • Hi,

    It’s more of a development side, it’s suggested to submit a new post in the MSDN forum to get more suggestions.


    The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

    Tracy Cai
    TechNet Community Support

    Wednesday, May 8, 2013 6:38 AM
  • thank you. will do that :)
    Thursday, May 9, 2013 2:00 AM