> I am working a project which using pocket pc 2003 connect to sql 2005
> express database.
> string connstr = @"data source=192.168.11.3\SQLEXPRESS;Initial
> Catalog=FYP;User ID=sa;Password = 61818030";

"Gary" wrote:

> Dear All
>
> I am working a project which using pocket pc 2003 connect to sql 2005
> express database.
>
> When I try to deploy a testing program on C# 2005, i cannot create the
> connection with a Sql Exception error.
>
> Do anyone have such experience and provide me a solution.
>
> my devlice is O2 XdaIIi and the .net CF is 2.0
>
> my coding as below:
>
> ---------------------------------------------------
>
>
> string connstr = @"data source=192.168.11.3\SQLEXPRESS;Initial
> Catalog=FYP;User ID=sa;Password = 61818030";
>
> try
> {
> conn = new SqlConnection(connstr);
> conn.Open();
>
> if (conn.State == ConnectionState.Open)
> {
> MessageBox.Show("A");
> }
> {
> MessageBox.Show("B");
> }
>
>
> }
> catch (Exception ex)
> {
> MessageBox.Show(ex.Message);
> conn.Close();
> }
>
> }
> ------------------------------------------------
>
> Best Regards