none
How to install missing ODBC driver

    Question

  • 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.

    Thanks for your help . . .


    Tuesday, December 13, 2011 4:32 PM

Answers

  • I would recommend to install the original drivers, downloaded the application form the manufacturer.

    Haw to install liblary standalone ... make a .bat file & run:

       @copy sqlncli10.dll %systemroot%\system32\
       @%systemroot%\system32\regsvr32 sqlncli10.dll

     

    edit:...

    try this: http://www.microsoft.com/download/en/details.aspx?id=16978


    X86 Package (sqlncli.msi)
    X64 Package (sqlncli.msi)


    Oskar Shon, Office System MVP

    Press if Helpful


    Tuesday, December 13, 2011 6:48 PM