• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1170
  • Last Modified:

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.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?
  • 2
1 Solution
lcohanDatabase AnalystCommented:
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.
Dave BaldwinFixer of ProblemsCommented:
The most current version of SQLNCLI10 is on this page: http://www.microsoft.com/en-us/download/details.aspx?id=27596  When you click on Download you will get a list of files to choose from.  Select ENU\x86\sqlncli.msi which is the 32-bit version.
leskellyAuthor Commented:
Thanks Dave.
Dave BaldwinFixer of ProblemsCommented:
You're welcome, glad to help.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now