SQL Server Compact Edition 3.5 给出了“多步操作生成的错误”简单查询出错
我通过 Microsoft 的 OLEDB 3.5 SQL CE 驱动程序使用 SQL Server CE 数据库。这是我的连接字符串：
Provider=Microsoft.SQLSERVER.CE.OLEDB.3.5;Data Source=C:\Users\me\Desktop\test1.sdf
这个查询工作正常：
SELECT Thing FROM OtherThing WHERE name = 'TextThing'
这个查询失败：
SELECT Foo FROM Stuff
这是我得到的错误：
Multiple-step operation generated errors. Check each status value.
表本身的唯一结构差异是一个有一个文本主键，另一个有一个 bigint 标识字段作为主键。
我尝试过的操作：
- http://support.microsoft.com/kb/269495 （都没有的解析条件对我来说是正确的）
- 将cursorLocation属性从adUseClient切换到adUseServer（这导致我的任何查询都不起作用 - 同样的错误）。也就是说，我想也许我不应该放弃这个（想法？）。
I'm using a SQL Server CE database via Microsoft's OLEDB 3.5 SQL CE Driver. Here's my connection string:
Provider=Microsoft.SQLSERVER.CE.OLEDB.3.5;Data Source=C:\Users\me\Desktop\test1.sdf
This query works fine:
SELECT Thing FROM OtherThing WHERE name = 'TextThing'
This query fails:
SELECT Foo FROM Stuff
And this is the error I get:
Multiple-step operation generated errors. Check each status value.
The only structural difference in the table themselves is that one has a text primary key and the other has a bigint identity field as a primary key.
What I've tried:
- http://support.microsoft.com/kb/269495 (neither of the resolution conditions are true for me)
- Switched the cursorLocation property from adUseClient to adUseServer (this caused none of my queries to work - same error). That said, I think maybe I shouldn't give up on this one (thoughts?).
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
问题与导致抛出该异常的表的字段类型为 nvarchar 且大小为 255 的事实有关。我将它们更改为 ntext 或将大小减小到 100，并且没有抛出异常。
The problem has to do with the fact that the tables that caused that exception to be thrown were ones with fields of type nvarchar and sizes of 255. I changed those to ntext or reduced the size to 100 and no exception was thrown.