Solved

SQL Driver 10.0

Posted on 2011-09-06
4
500 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 83

Accepted Solution

by:
Dave Baldwin earned 500 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 83

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 83

Expert Comment

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

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

860 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