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.
-Leo
Adodb.Record Activex Object seems to be broken
