Solved

SQL Driver 10.0

Posted on 2011-09-06
4
501 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
[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
  • 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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Insert parts by customer 12 53
why sql server only update some statistics in the database ? 3 40
SQL Improvement  ( Speed) 14 37
TSQL Challenge... 7 44
This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
In this article I will describe the Copy Database Wizard 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.

749 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