Solved

Installing SQLNCLI10 on Windows Server 2003

Posted on 2013-12-18
4
931 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
  • 2
4 Comments
 
LVL 39

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 82

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 82

Expert Comment

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

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
PL/SQL query 14 46
SQL Script to find duplicates 16 19
C# Error - Add Failed 12 39
Stored procedure 23 9
Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

757 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now