SQL SERVER2008 DBX Error: Driver could not be properly initialized

时间:2023-02-05 07:29:22

raised exception class TDBXError with message 'DBX Error:  Driver could not be properly initialized.  Client library may be missing, not installed properly, of the wrong version, or the driver may be missing from the system path.'.

http://docwiki.embarcadero.com/RADStudio/XE7/en/DbExpress_Database_Specific_Information

Install the SQL Server Native Client for Windows

2008

http://msdn.microsoft.com/en-us/sqlserver/ff658533.aspx

2014

http://msdn.microsoft.com/en-us/library/ms131321.aspx

SQL Server 2000:sqlsrv32.dll、Ntwdblib.DLL

SQL Server 2005:Sqlncli.dll

SQL Server 2008:Sqlncli10.dll

SQL Server 2008 R2:Sqlncli10.dll

SQL Server 2012:Sqlncli11.dll

http://jimshu.blog.51cto.com/3171847/1397348

sql2008在这里下载操作系统对的sqlncli.msi setup ok!!

http://www.microsoft.com/en-us/download/confirmation.aspx?id=27596

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

安装包给system32和SysWOW64路径下 放2个文件sqlncli10.dll、sqlnclir10.rll

win7 64位os,删除C:\Windows\SysWOW64\sqlncli10.dll文件,就连接失败!把sqlncli10.dll放到应用服务器的exe目录下也不行,说明是只能识别到SysWOW64目录里。

2015-01-19 14:38:31  [FireDAC][Phys][ODBC]由于系统错误  126: 找不到指定的模块。 (SQL Server Native Client 10.0, C:\windows\SysWOW64\sqlncli10.dll),指定驱动程序无法加载。

如果没有安装包sqlncli.msi,从已安装的机器上拷贝这2个文件,也是报错

2015-01-19 14:55:49  SQL State: 08001, SQL Error Code: 0
A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote

connectios.For more information see SQL SERVER  Books Online.

总结:只能安装sqlncli.msi来解决

2015-01-19 14:55:49  SQL State: 08001, SQL Error Code: 0
A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow r