SQLCE 同步 SQLSERVER

Question

在WINCE上使用PULL 方法读取PC数据库里的数据时，提示“将数据发送到运行 IIS 的计算机的请求失败。有关详细信息，请参阅 HRESULT。”，是不是我的数据库配置有问题啊，该如何配置？

Answer 1

How did you set this up? Have any details?

Answer 2

Should replace localhost with server name in connection string and url. In sql connection string, try 'data source = host_name\sqlexpress'.

Answer 3

Yes,I do,but the same result was showed,can you tell me how to config Sql server step by step.Because i think my code is right,thanks a lot!

Answer 4

Can you post your new sql connection string? Tried connect to sql with ip address and port number? Does sql server accept remote connection?

Answer 5

Can't use 127.0.0.1 for remote access because it's loopback address of local host, use sql server's ip address instead.

Answer 6

Sounds networking issue, double check with service provider.

Answer 7

不管如何，都不能连接到服务器，怪了啊，应该如何配置WM6 以及SQL SERVER数据库啊？我现在都怀疑自己了，还请老师不吝赐教，我比较笨些。谢谢老师啦！

Answer 8

使用USB数据线将手机与PC机相连，在手机上可以用http://ip/fibexamsys/sqlcesa35.dll打开SQL CE代理，但就是连不上数据库，均提示“无法使用给定的连接字符串打开SQL SERVER”，这到底是怎么回事啊？

Answer 9

USB is not network connection.

Answer 10

那该如何设置呢？能否告诉我，老师？

Answer 11

You have to work with service provider.

Answer 12

我在WM6仿真上连“http://IP/fibexamsys/sqlcesa35.dll”也连不上啊！

Answer 13

Pocket PC和桌面PC网络连接可以使用Microsoft ActiveSync，也可以使用无线WiFi 802.1x。是这样吗？

Answer 14

ActiveSync needs network connection.

Answer 15

SQL SERVER 2005 EXPRESS 与 WIN CE连接字符串是否正确，有的人怎么说要使用Provide=SQLNCLI啊？难道使用Provide=SQLOLEDB就不行吗？

Answer 16

You can find all kind of connection strins there: http://www.connectionstrings.com/.