Access模糊查询 内存溢出！高手看看

[caicheng]

SELECT * FROM table1 WHERE name Like 'a%a%' ok
SELECT * FROM table1 WHERE name Like 'a%' ok
SELECT * FROM table1 WHERE name Like '%' ok
SELECT * FROM table1 WHERE name Like '%a%a%' 内存溢出
SELECT * FROM table1 WHERE name Like '%a' 内存溢出
使用的是oleDBcommand,oleDBDataAdapter
难道是ADO.net的问题？？？

[新鲜鱼排]

提示错误是“内存溢出”？？

[caicheng]

对的，抛出异常：“内存溢出”
那个表中有61W记录，不过我再Access中可以这样查询

[dazhu2]

不会吧?

[caicheng]

我也不希望如此，大家帮帮忙看看

[7ero]

ACCESS中有61W记录，怎么+进去的？也够强的了。

[caicheng]

帮忙看看啦

[zhongwanli]

意思说，有一两百万数据，楼主配置

[bumm]

关注，帮你顶一下。

[SeeSunSet]

这么大数据量还用ACCESS?自找麻烦嘛..

[yaopeng117]

SELECT * FROM table1 WHERE name Like '%a%a%'

好象要用转意字符

[caicheng]

up~~没人知道吗？？#_#

[muffle]

我曾经也遇到过access模糊查询时出现“内存溢出”的错误，当时使用的是ADO。最后发现在需要检索的字段中有非法字符，当时导致溢出的非法字符是一些日文的片假名（不是全部的片假名），后来清除了这些导致错误的片假名后就一切正常了。

[caicheng]

再顶一下，没人遇到此类问题吗？

[caicheng]

我的记录里面没有日文俄，而且ADO是可以的

[nccxf]

vb.net中若出现“内存溢出”很有可能是变量类型不对，你可以从这方面找找原因。
好比你在picturebox中想显示一张图片，但却错误的调入了一个文本文件，这时就有可能报"内存溢出"错误。

[zcl24]

private string FiterJp(string Str) //过虑Acess日文字符
{
string[] FiterStr={"ガ","j30AC","ギ","j30AE","グ","j30B0","ゲ","j30B2","ゴ","j30B4","ザ","j30B6","ジ","j30B8","ズ","j30BA","ゼ","j30BC","ゾ","j30BE","ダ","j30C0","ヂ","j30C2","ヅ","j30C5","デ","j30C7","ド","j30C9","バ","j30D0","ビ","j30D3","ブ","j30D6","ベ","j30D9","ボ","j30DC","パ","j30D1","ピ","j30D4","プ","j30D7","ペ","j30DA","ポ","j30DD","ヴ","j30F4"};
for(int i=0;i<FiterStr.Length;i++)
{
Str=Str.Replace(FiterStr[i],FiterStr[i+1]);
i++;
}
return Str;
}
private string GetFiterJp(string Str)
{
string[] FiterStr={"ガ","j30AC","ギ","j30AE","グ","j30B0","ゲ","j30B2","ゴ","j30B4","ザ","j30B6","ジ","j30B8","ズ","j30BA","ゼ","j30BC","ゾ","j30BE","ダ","j30C0","ヂ","j30C2","ヅ","j30C5","デ","j30C7","ド","j30C9","バ","j30D0","ビ","j30D3","ブ","j30D6","ベ","j30D9","ボ","j30DC","パ","j30D1","ピ","j30D4","プ","j30D7","ペ","j30DA","ポ","j30DD","ヴ","j30F4"};
for(int i=0;i<FiterStr.Length;i++)
{
Str=Str.Replace(FiterStr[i+1],FiterStr[i]);
i++;
}
return Str;
}

用这两个函数做一下字符转换 就不会溢出了

[caicheng]

还是没有解决，不过谢谢大家了

[koomis]

每次查询后放掉内存,别以为你的机器有够多的内存可以装入这么多查询结果.