问题描述
我在 Windows XP 上有一个应用程序,它从移动设备 (Windows Mobile 5.0) 获取 sdf 文件 (SQLServerCE3.0) 导入并删除一些数据,然后将其放回设备.它一直工作正常.
I've have an application on Windows XP that takes an sdf file (SQLServerCE3.0) from a mobile device (Windows Mobile 5.0) import and delete some data and then put it back to the device. It has allways worked correctly.
现在,当我在 Windows 7 x64 上执行此操作时,sdf 文件在返回时会在设备上执行一些奇怪的行为.
Now, when i do it on Windows 7 x64 the sdf file does some strange behaviour on the device when it goes back.
当我使用字符串进行连接时,例如:
When i do a join with strings, example:
从 EMPRESES E 内部加入供应商 V 上选择 EMPRESA V.EMPRESA_GUID = E.GUID where V.GUID='{XXX-XXX}'
SELECT EMPRESA FROM EMPRESES E INNER JOIN VENDORS V ON V.EMPRESA_GUID = E.GUID where V.GUID='{XXX-XXX}'
当它有数据要返回时,它不返回任何东西(在 Windows XP 上它可以正常工作).
It doesn't return anything, when it has data to return (On Windows XP it works correctly).
我已经对其进行了测试,只是为了从 Windows 7 上的设备(使用 RAPI 或手动)获取文件并将其放回无法再使用的设备.
I've tested it, and only to take the file from device on Windows 7 (with RAPI or manually) and putting it back to the device it can't be used anymore.
我不知道为什么会发生这种情况,尝试更改 SQLServerCE 版本但没有帮助.任何人都可以知道发生了什么或以前遇到过同样的问题吗?
I don't know why this is happening, tried changing SQLServerCE version but no help.Can anybody knows what's going on or had same problems before?
我在这里找到了类似的东西:http://www.codeproject.com/Questions/98676/c-app-on-xp-makes-sdf-works-same-exe-on-windows-7
I found something similar here:http://www.codeproject.com/Questions/98676/c-app-on-xp-makes-sdf-works-same-exe-on-windows-7
谢谢.
推荐答案
您必须使用此处记录的 3.1 引擎(3.0.5300 或更高版本):http://blogs.msdn.com/b/sqlservercompact/archive/2009/04/01/after-moving-the-database-from-one-platform-to-other-the-first-sqlceconnection-open-takes-more-time.aspx
You must use the 3.1 engine (3.0.5300 or higher) as documented here: http://blogs.msdn.com/b/sqlservercompact/archive/2009/04/01/after-moving-the-database-from-one-platform-to-other-the-first-sqlceconnection-open-takes-more-time.aspx
这篇关于Windows 7 上的 SQLServerCE SDF 文件的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!