用于Sql server2005的Window CE 5.0连接 [英] Window CE 5.0 Connection for Sql server2005

问题描述

你好先生

i我正在使用窗口CE 5.0移动设备，我在智能设备窗口CE中创建了一个应用程序，我连接sql server但连接给我错误SqlException



第一次使用这个简单的连接

1）SqlConnection SqlCOn = new SqlConnection（Data Source = SOFTWARE \\SQLEXPRESS; Initial Catalog = ALMS; Integrated Security = True;用户ID = sa;密码= 123;）;

他给我SqlException错误



2）比我之后在net上发现了一些数据
但是他也给了我一些错误

SqlConnection SqlCOn =新的SqlConnection（数据源= 192.168.0.3,1433;初始目录= ALMS;集成安全=真;用户ID = sa;密码= 123;）;



任何有关此错误的建议请告诉我

hello sir
i am using window CE 5.0 mobile device and i made one application in smart device window CE and i ma connect sql server but connection give me error SqlException

first time i ma use this simple connection
1) SqlConnection SqlCOn = new SqlConnection("Data Source=SOFTWARE\\SQLEXPRESS;Initial Catalog=ALMS;Integrated Security=True; User ID=sa;Password=123; ");
he give me SqlException error

2) than after i ma found some data on net
but he also give me some error
SqlConnection SqlCOn = new SqlConnection("Data Source=192.168.0.3,1433;Initial Catalog=ALMS;Integrated Security=True; User ID=sa;Password=123; ");

any suggestion for this error please tell me

推荐答案

你 不能 将智能设备（WinCe操作系统）与SQLServer连接，除非你使用 SqlCE [ ^ ]。

查看我过去的回答：如何从窗口Mobile 6（WindowCE）建立到MS Access数据库的连接[ ^ ]



Morea关于：

SQL Server CE的SQL参考 [ ^ ]

http://www.dotnetperls.com/sqlce [ ^ ]

http：//blogs.msdn。 com / b / sqlservercompact / [ ^ ]

http://www.outformations.com/resources/SQLCE_GettingStarted.pdf [< a href =http://www.outformations.com/resources/SQLCE_GettingStarted.pdftarget =_ blanktitle =新窗口> ^ ]



有趣的CP文章：

向Windows Mobile应用程序添加数据复制的5个步骤 [ ^ ]

You can't connect smart device (WinCe operating system) with SQLServer, unless you are using SqlCE[^].
See my past answer: How to extablish connection to MS Access database from window Mobile 6 (WindowCE)[^]

Morea about:
SQL Reference for SQL Server CE[^]
http://www.dotnetperls.com/sqlce[^]
http://blogs.msdn.com/b/sqlservercompact/[^]
http://www.outformations.com/resources/SQLCE_GettingStarted.pdf[^]

Interesting CP article:
5 Steps to Adding Data Replication to a Windows Mobile Application[^]

这篇关于用于Sql server2005的Window CE 5.0连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！