C# coding connection to sql 2005 express on pocket pc 2003

  • Thread starter Thread starter Gary
  • Start date Start date
G

Gary

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();
}

}
 
Gary pisze:
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";
Click to expand...

Instead of instance of database try use a port.

Instead of
192.168.11.3\sqlexpress
try
192.168.11.3,port
 
What is the exception message? ensure the SQL Server has tcp/ip connectivity
enabled.
 
Back
Top