[Microsoft][ODBC SQL Server 驱动程序]通信链接失败
我需要你们的帮助来解决这些问题！！！！
在将文件上传到数据库期间，会发生此错误。 [Microsoft][ODBC SQL Server Driver]通信链接失败
现在，这是我迄今为止根据我所阅读的文章所做的操作。 1.我重新启动了相关服务器。 2. 我添加了一个新的 DNS 连接，以对其用于连接数据库的模式进行设置。
但所有这些都失败了。我不知道该怎么办，因为这现在很关键，而且已经过去一周了。
请帮我...
I need your help on this guys!!!!
During the upload of the files to a database, this error occurs.
[Microsoft][ODBC SQL Server Driver]Communication link failure
Now here's what I did so far based on the articles which I've been reading.
1. I restarted the servers that are involved.
2. I've added a new DNS connection to pattern to what they are using to connect to the database.
But all of these failed. I don't know what to do because this is now critical and it's been a week now.
Please help me...
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
试试这个，它对我有用......
try this one, it work for me......
您是否尝试过此处提出的解决方案：
--[Microsoft][ODBC SQL Server Driver]Communication Link Failure
http://social. msdn.microsoft.com/Forums/en-US/sqldataaccess/thread/b7a4c6f2-0d1b-44ba-bb55-0e7848d64198/
和此处：
--应用程序连接到正在运行的服务器上的 SQL Server 时出现错误消息Windows Server 2003：“一般网络错误”、“通信链路故障”或“传输级错误”
http://support.microsoft.com/kb/942861
也许您应该查看日志， SQL Server的服务是否有问题。
have you tried solutions proposed here:
--[Microsoft][ODBC SQL Server Driver]Communication Link Failure
http://social.msdn.microsoft.com/Forums/en-US/sqldataaccess/thread/b7a4c6f2-0d1b-44ba-bb55-0e7848d64198/
and here:
--Error message when an application connects to SQL Server on a server that is running Windows Server 2003: "General Network error," "Communication link failure," or "A transport-level error"
http://support.microsoft.com/kb/942861
Maybe you should look into logs, on whether there are no problems with SQL Server's service.
如果您在作业或 SSIS 包中以一种或另一种形式收到以下错误消息：
很可能的原因是正在运行的代码是在 BIDS 中创建的，该代码使用 Visual Studio 2008 作为其 SDK 基础，并且包或作业已移动到基于 Visual Studio 2012 的 SQL Server 2012 服务器。
在这种情况下，您不能简单地进入包并更改连接服务器名称。 BIDS（又名 VS 2008）使用 SQL Server 连接 Provider=SQLNCLI10.1。 TFS（又名 VS 2012）使用 SQL Server 连接 Provider=SQLNCLI11.1。如果您要重构最初在 VS 2008 中创建的包，请在 VS 2012 中执行此操作，然后使用 2012 提供程序删除并重新创建连接，它是向后兼容的。2008 提供程序不向前兼容。如果您要创建新包，请在 VS 2012 中执行此操作。这通常可以解决问题。
If you receive the following error messages in one form or another in a job or SSIS package:
A very likely cause is the code being run was created in BIDS which uses Visual Studio 2008 as its SDK base and the package or job was moved to a SQL Server 2012 server which is Visual Studio 2012 based.
You cannot simply go into the package and change a connections server name in this case. BIDS (aka VS 2008) uses
SQL Server connection Provider=SQLNCLI10.1. TFS (aka VS 2012) usesSQL Server connection Provider=SQLNCLI11.1. If you are refactoring a package that was originally created in VS 2008 please do so in VS 2012 and drop and recreate the connections using the 2012 provider, it is backward compatible.The 2008 provider is not forward compatible. If you are creating a new package please do so in VS 2012. This, most often, will solve the problem.