My company has been using msado 1.5 for a long time and I have a lot of C++ and VB6 legacy code to support. I am looking at moving us to a Windows 7 environment. I am investigating what components have to be updated to succeed.
Must I use the msado60_backcompat_i386.tlb or will msado15.dll work just fine as long as we don't install mdac 2.8? The reason I ask is that our components can't log in to the SQL Server database on Windows 7 at the moment. (access denied issues)
I read the long thread about the changes to the IID's of msado to support 64-bit Windows 7. (We're still using 32-bit platforms.) I am wondering if our inability to connect to our database has something to do with these mdac IID changes?
Unlikely. Are you able to provide the exact error message?
MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt) MCT, MCPD, MCITP, MCDBA
Blog: Mr. Wharty's Ramblings
Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
Hi, a KB article has been release to summary this issue:
Hope it to be helpful!
Hello,After downloading the file mentioned above, do the following:- Copy the file to the directory C:\Program Files\Common Files\System\ado- Register the file with the command %windir%\Microsoft.NET\Framework\v4.0.30319\regtlibv12 C:\Program Files\Common Files\System\ado\msado60_Backcompat.tlbOBS. If you should not have the v4.0.30319 directory, then place your respective directory regarding your Framework.- In the project, clear the use of reference Microsoft ActiveX Data Objects 2.1 Library, which points to the file C:\Program Files\Common Files\System\ado\msaado21.tlb
- Click on Browse and select the file you recorded earlier.Tks...
MTAC - Microsoft Technical Audience Contributor
As a follow up to your helpful information it was my experience that it was not necessary to run the regtlibv12, this in fact produced an error, and the v4.0.30319 directory does exist on the computer. The key was substituting the existing ADO Data Objects reference with the new Microsoft ActiveX Data Objects 6.0 BackCompat Library. This is a VB6 project. Just wanted to clarify, thanks.