An ADO application does not run on down-level operating systems after you recompile it on a computer that is running Windows 7 SP 1 or Windows Server 2008 R2 SP 1 or that has KB983246 installed

• Microsoft Visual C++
• Microsoft Visual Basic for Applications (VBA)
• Microsoft Visual Basic 6
• Microsoft .NET applications

#import " msado15.dll" no_namespace rename("EOF","EndOfFile")
 
int main()
{
  CoInitialize(NULL);
  _ConnectionPtr pConnection = NULL;
     HRESULT hr = pConnection.CreateInstance(__uuidof(Connection)); //hr gets E_NOINTERFACE here
}

Private Sub Form_Load()
 Dim Conn As New ADODB.Connection ‘Runtime error here: Class does not support Automation or does not support expected interface
End Sub

Back to the top

• In Windows 7 and in earlier versions of Windows, the _Connection IID is 00000550-0000-0010-8000-00AA006D2EA4.
• In Windows 7 SP1, the _Connection IID is 00001550-0000-0010-8000-00AA006D2EA4, and the IID for _Connection_Deprecated is 00000550-0000-0010-8000-00AA006D2EA4.

Back to the top

Back to the top

Method 1

• Method 2 does not apply VBA to applications. The compiled Access file (*.mde or *.accde) has to read the downloaded typelib (.tlb) file at runtime, and it is unlikely that the downloaded .tlb file will be present on end-user computers.
• To download files, go to the "Downloads" subsection of this section.
• Running the CMD prompt as an Administrator during the registration process for the type library may be necessary on the Windows 7 machines.

For 32-bit computers

1. Download Msado60_Backcompat_i386.tlb to a local directory (e.g. C:\temp).
2. Copy the downloaded file to a deployed directory. For example:
   C:\temp\Msado60_Backcompat_i386.tlb "%CommonProgramFiles%\System\ado\Msado60_Backcompat.tlb"
3. Register the downloaded file on the system. For example:
   %windir%\Microsoft.NET\Framework\v4.0.30319\regtlibv12 "%CommonProgramFiles%\System\ado\msado60_Backcompat.tlb"
   
   Note Adjust the path for regtlbv12.exe if the .NET Framework 4.0 was not installed on the system.
4. Verify that the following registry key was created:
   HKEY_CLASSES_ROOT\TypeLib\{0C0FF45D-87C8-4333-9075-3D9B4D64F9FC}\6.0
5. Verify that the following registry value is pointing to "%CommonProgramFiles%\System\ado\Msado60_Backcompat.tlb" (the path in the registry may be expanded into an absolute path):
   HKEY_CLASSES_ROOT\TypeLib\{0C0FF45D-87C8-4333-9075-3D9B4D64F9FC}\6.0\0\win32

For AMD 64 computers

1. Download Msado60_Backcompat_i386.tlb to a local directory (e.g. C:\temp).
2. Download Msado60_Backcompat_x64.tlb to a local directory (e.g. C:\temp).
3. Copy the downloaded files to a deployed directory. For example:
   
   C:\Temp\Msado60_Backcompat_i386.tlb "%CommonProgramFiles(x86)%\System\ado\Msado60_Backcompat.tlb"
   C:\Temp\Msado60_Backcompat_x64.tlb "%CommonProgramFiles%\System\ado\msado60_Backcompat.tlb"
4. Register the downloaded files on the system. For example:
   
   %windir%\Microsoft.NET\Framework\v4.0.30319\regtlibv12 "%CommonProgramFiles%\System\ado\Msado60_Backcompat.tlb"
   %windir%\Microsoft.NET\Framework\v4.0.30319\regtlibv12 "%CommonProgramFiles(x86)%\System\ado\Msado60_Backcompat.tlb"
   
   Note Adjust the path for regtlbv12.exe if the .NET Framework 4.0 was not installed on the system.
5. Verify that the following registry key was created:
   HKEY_CLASSES_ROOT\TypeLib\{0C0FF45D-87C8-4333-9075-3D9B4D64F9FC}\6.0
6. Verify that the following registry value is pointing to "%CommonProgramFiles(x86)%\System\ado\msado60_Backcompat.tlb" (the path in the registry may be expanded into an absolute path):
   HKEY_CLASSES_ROOT\TypeLib\{0C0FF45D-87C8-4333-9075-3D9B4D64F9FC}\6.0\0\win32
7. Verify that the following registry value is pointing to "%CommonProgramFiles%\System\ado\msado60_Backcompat.tlb" (the path in the registry may be expanded into an absolute path):
   HKEY_CLASSES_ROOT\TypeLib\{0C0FF45D-87C8-4333-9075-3D9B4D64F9FC}\6.0\0\win64

For IA64 computers

Downloads

• Msado60_Backcompat_i386.tlb (http://download.microsoft.com/download/6/4/3/64318ED2-7E18-4A5C-80E2-9BDA0DF02DB3/msado60_Backcompat_i386.tlb)
• Msado60_Backcompat_x64.tlb (http://download.microsoft.com/download/6/4/3/64318ED2-7E18-4A5C-80E2-9BDA0DF02DB3/msado60_Backcompat_x64.tlb)
• Msado60_Backcompat_ia64.tlb (http://download.microsoft.com/download/6/4/3/64318ED2-7E18-4A5C-80E2-9BDA0DF02DB3/msado60_Backcompat_ia64.tlb)

For C++ developers

1. Replace line 1 with line 2:

   1. #import "msado15.dll" no_namespace rename("EOF","EndOfFile")

   2. #import "msado60_Backcompat.tlb" no_namespace rename("EOF","EndOfFile")

2. Recompile the application.

For Visual Basic 6 developers

1. On the Project menu, click References.
2. Click to clear the Microsoft ActiveX Data Objects * Library and Microsoft ActiveX Data Objects Recordset * Library entries.
3. Click to select the Microsoft ActiveX Data Objects 6.0 BackCompat Library entry.
4. Recompile the application.

Back to the top

Method 2

Back to the top

• Interface: ADORecordsetConstruction
• Interface: ConnectionEventsVt
• Interface: _Connection
• Interface: Connection15
• DispInterface: ConnectionEvents
• Interface: _Command
• Interface: Command25
• Interface: Command15
• Interface: Fields
• Interface: Fields20
• Interface: Fields15
• Interface: Field
• Interface: Field15
• Interface: Field20
• Interface: _Parameter
• Interface: Parameters
• Interface: _Record
• Interface: _Recordset
• Interface: Recordset21
• Interface: Recordset20
• Interface: Recordset15
• DispInterface: RecordsetEvents
• Interface: RecordsetEventsVt
• Interface: _Stream

Back to the top