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安装上看起来完全差异),我无法对此举办测试.无论怎样它如故可以辅佐你…

（编辑：湖南网）

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