leskelly
asked on
Installing SQLNCLI10 on Windows Server 2003
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 .Connectio n")
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?
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
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?
In my opinion the quickest and cleanest is to create an interim ODBC and use that one instead in your code above as you can't really install only the SQLNCLI10 provider.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks Dave.
You're welcome, glad to help.