sql-server – 如果我选择超过15个字段,我会遇到灾难性的失败

使用sql server 2012我正在使用Pervasive SQL连接到链接服务器.

当我选择*或选择field1,field2,field3 …. field15我收到此错误：

Msg 7399,Level 16,State 1,Line 1
The OLE DB provider "MSDASQL" for linked server "KSLAP208" reported an error. The provider reported an unexpected catastrophic failure.
Msg 7330,State 2,Line 1
Cannot fetch a row from OLE DB provider "MSDASQL" for linked server "KSLAP208".

我觉得有某种记忆问题？它不允许我选择超过一定数量的数据？

而如果我选择少量数据选择field1,field2它没有问题.

我究竟做错了什么？

解决方法

In the ODBC Data Source Administrator panel on the server,configure your linked server from System DSN. Under the Performance tab,uncheck the box ‘Enable pre-fetch of data for queries’. OK,OK. Delete and re-create your linked server in SQL Management Studio.

You can disable the prefetch by clearing the “Enable pre-fetch of data for queries” check box in the Performance tab when creating a DSN or adding “PREFETCH=0” to the connection string when creating a DSN-less connection.

由于我无法访问Pervasive的下载区域(并且SQL Server的ODBC连接在我的Server 2012安装上看起来完全不同),我无法对此进行测试.无论如何它仍然可以帮助你…

（编辑：开发网_新乡站长网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!