Forum Discussion

Jose_Carlos_Salazar's avatar
Jose_Carlos_Salazar
Copper Contributor
May 24, 2023

Problem with SQLOLEDB

Hi all:   We are having a problem with an old application (32 bits) that needs to establish an ADO connection from a Windows Server 2016 to a MS SQL Server 2019 (in another Windows Server 2016) usi...
SQLOLEDB
Jose_Carlos_Salazar's avatar
Jose_Carlos_Salazar
Copper Contributor
May 25, 2023

Hi:

 

It does not work. I think we are going to try in a new server, because we have install/uninstall/install a few things and we are not sure about the state of the server...

 

Regards,

Jose Carlos Salazar

 

Dave Patrick's avatar
Dave Patrick
MVP
May 25, 2023
Those old MDAC versions are unlikely to run on a newer operating system. You may need to stand up an XP or 2003 virtual machine to run on.

  • Jose_Carlos_Salazar's avatar
    Jose_Carlos_Salazar
    Copper Contributor
    May 26, 2023
    Hi:

    Thanks, but that's not an option. Anyway, we have it running in some Windows Server 2016 and 2019...

    Regards
    Jose Carlos Salazar
    • Dave Patrick's avatar
      Dave Patrick
      MVP
      May 26, 2023

      Then the better option may be to convert it to some newer platform and move on.    

       

      MDAC 2.8 

      Supported Operating System

      Windows 2000, Windows 98, Windows ME, Windows NT, Windows Server 2003, Windows XP  

       

       

       

       

Resources