SQL Server 2005 and MDAC

  • Hi,

    I have been trying to find our which versions of MDAC can connect to a SQL2k5 database as we are planning to migrate our 7 and 2000 DBs to 2005 and have a right old mix of client PCs with various versions of MDAC.

    We do not want to upgrade MDAC if it is not required so, if for example, MDAC 2.3 has no problems connecting then that is good news.

    Any help is much appreciated.

    John

  • WE had issues with MDAC 2.3 when we upgraded some ACCESS Databases over to SQL 2005 and also Clients sometime RUn reports off Access 97(Still). So we Decided to upgrade them to ACCESS 2003 and SOME Client to MDAC 2.8.. so its a Mixture of everything.. So You have to upgrade from version 2.3 and maybe you guys will have to re-write any client side SMART APPLICATIONS to work with SQL Server 2005.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply