Solved

Installing SQLNCLI10 on Windows Server 2003

Posted on 2013-12-18
4
1,008 Views
Last Modified: 2013-12-19
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?
0
Comment
Question by:leskelly
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 40

Expert Comment

by:lcohan
ID: 39727942
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.
0
 
LVL 83

Accepted Solution

by:
Dave Baldwin earned 500 total points
ID: 39728071
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.
0
 

Author Closing Comment

by:leskelly
ID: 39729382
Thanks Dave.
0
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 39729839
You're welcome, glad to help.
0

Featured Post

Guide to Performance: Optimization & Monitoring

Nowadays, monitoring is a mixture of tools, systems, and codes—making it a very complex process. And with this complexity, comes variables for failure. Get DZone’s new Guide to Performance to learn how to proactively find these variables and solve them before a disruption occurs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question