I have an Excel 2010 application that accesses a SQL Server 2008 R2 server using an OBDC connection string.
When my co-workers try to use the application, it cannot connect to the database. I discovered that the ODBC driver (sqlncli10.dll) referenced in the connection string is not installed on their Windows XP Pro workstations. It's installed on my machine because
I have Visual Studio installed.
I tried copying the file from Windows\System32 on my machine and adding it to one of their machines (in the same location), then registering it using this command in Start -> Run: regsvr32\windows\system32\sqlncli10.dll, but the PC responds with
"can't find regsvr32\windows\system32\sqlncli10.dll". Tried rebooting then registering again, but no joy.
What is the correct way to get this driver installed? I can use either sqlncli.dll or sqlncl10.dll I think.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.