Installing SQLNCLI10 on Windows Server 2003
Posted on 2013-12-18
We have a asp.net 1.0 application with a SQL Server 2000 back end running on a Windows Server 2003 SP 2 machine.
I'm in the process of migrating it to two Windows Server 2008 R2 SP 1 machines. One will house the front end and one will store the data in SQL Server 2008 R2.
We are doing the migration in two phases. Yesterday the first phase of the migration was completed and the data was migrated to the new machine. All went well except for one thing. There is also a classic asp.net single page application that accesses one table in the database. This is also on the Windows Server 2003 machine.
I modified the code with the connection string to this:
SET dbOpenShifts = Server.CreateObject("ADODB.Connection")
dbOpenShifts.Open "PROVIDER=SQLNCLI10;DATA SOURCE=<server name>;DATABASE=<database name>;Integrated Security=SSPI"
but when loading the page I now get the error:
"ADODB.Connection error '800a0e7a'
Provider cannot be found. It may not be properly installed.
/open_shifts.asp, line 21"
The problem is that SQLNCLI10.dll doesn't exist on the old server. The Microsoft pages that used to allow you to download the installation files are no longer active.
So my question is does anyone know where I can download the files to install the SQL native client onto a Windows 2003 machine?