Windows 7 上的 SQLServerCE SDF 文件 [英] SQLServerCE SDF file on Windows 7

问题描述

我在 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 文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！