We have a program which developed under SQL Server 2005. In the
program the provider of the connect string is hard coded as "SQLNCLI".
It's ok running on SQL Server 2005. Now, for some reasons, this program
must run under SQL Server 2008 (x64). But our program
cannot access the SQL Server.
We check the reason, found that, in SQL Server 2008, SQLNCLI is changed to SQLNCLI10, this caused our program cannot run.
So I want to ask, is there any patch of SQL2008, so that the legacy
program can normal access SQLserver with SQLNCLI WITHOUT rebuild a new
version?
Answers:
Since
SQLNCLI is published before SQL Server 2008 is published, it is designed
to connect to SQL Server 7.0, 2000 and 2005. If we use this provide to
connect to SQL
Server 2008, it might work incorrectly. Therefore we recommend that you
use SQLNCLI10 to connect to SQL Server 2008. Meanwhile SQLNCLI10 could
also be used to connect to SQL Server 2005.
Reference: http://social.msdn.microsoft.com/Forums/eu/sqlexpress/thread/652549a7-f02c-4b9a-aab1-1686d303dc6c
No comments:
Post a Comment