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
Old Conn String
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