当我选择*或选择field1,field2,field3 …. field15我收到此错误:@H_301_3@
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".
我觉得有某种记忆问题?它不允许我选择超过一定数量的数据?@H_301_3@
而如果我选择少量数据选择field1,field2它没有问题.@H_301_3@
我究竟做错了什么?@H_301_3@
解决方法
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.@H_301_3@
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.@H_301_3@
由于我无法访问Pervasive的下载区域(并且sql Server的ODBC连接在我的Server 2012安装上看起来完全不同),我无法对此进行测试.无论如何它仍然可以帮助你…@H_301_3@