I need to upgrade the connection of some reports in OLEDB (ADO) from SQL Server 2005 Native Client (SQLNCLI) to SQL Server 2008 Native Client (SQLNCLI10).
I tried to change the property "Provider" of the connection from SQLNCLI to SQLNCLI10 but as soon as I preview, it's changing back automatically to SQLNCLI !?!?
I also tried to create a new connection in SQLNCLI10 and update the database item without sucess...
Is it possible to do it without re-starting the report from scratch ?