Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SQL Driver 10.0

Posted on 2011-09-06
4
Medium Priority
?
518 Views
Last Modified: 2012-05-12
How do I get SQL Server Driver 10.0 on a client machine?

I have been using SQL 2000 for a long time, but have moved over to SQL 2008 recently.  My problem is that my connection string used the driver/provider below, however at times I have problems wit it.  I need to use the new 10.0 driver, but I have no idea how to get the new driver on each individual Client's machine.  They all use Windows XP.
      Old -->  DRIVER=SQL Server;      --  New  --> DRIVER=SQL Server Native Client 10.0;
       Old -->  Provider=SQLOLEDB.1;  --  New  --> Provider=SQLNCLI10.1;

Thanks in advance for any help
LJG

Old Conn String
ODBC;Provider=SQLOLEDB.1;DRIVER=SQL Server;SERVER=MyServer;Trusted_Connection=Yes;DATABASE=MyDatabase;TABLE=dbo.tbl_MyTable

New Conn String
ODBC;Provider=SQLNCLI10.1;DRIVER=SQL Server Native Client 10.0;SERVER=MyServer;Trusted_Connection=Yes;DATABASE=MyDatabase;TABLE=dbo.tbl_MyTable


|
0
Comment
Question by:LJG
  • 3
4 Comments
 
LVL 84

Accepted Solution

by:
Dave Baldwin earned 2000 total points
ID: 36490310
The current version, Microsoft® SQL Server® 2008 R2 Native Client, can be found in about the middle of this page: http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=16978
0
 
LVL 84

Expert Comment

by:Dave Baldwin
ID: 36490318
Yes, it works on XP, I have it on 6 different XP computers.
0
 
LVL 2

Author Closing Comment

by:LJG
ID: 36491560
Thanks so much for making my life easier today.

LJG
0
 
LVL 84

Expert Comment

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

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…

879 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