Solved

Installing SQLNCLI10 on Windows Server 2003

Posted on 2013-12-18
4
952 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 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

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Slow Connectivity over ODBC 8 37
SQL view 2 27
VB.NET 2008 - SQL Timeout 9 24
T-SQL: New to using transactions 9 31
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
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.

810 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