connecting sql server from windows ce application

Question

I've connected my Motorola MC3090R having Windows CE 5 through cradle (Windows Mobile Device Center) with my laptop having Windows 7 (there is no network), my question is that how i will connect to sql server (it's on my laptop) from my handheld app? what will be my connection string inside my handheld app? as there is no network what ip i will use in the connection string?

please help

Answer 1

private void form1Load(Object sender, EventArgs e)
        {
            String strConnection =
                "Data Source=your_ip;Initial Catalog=your_database;Integrated Security=True; User ID=your_db_user;Password=your_db_password;";

        try
        {
            conn = new SqlConnection(strConnection);
            conn.Open();
            MessageBox.Show("You Success!!");
        }
        catch (SqlException ex)
        {
            MessageBox.Show("You failed!" + ex.Message);
            conn.Close();
        }
    }

Answer 2

When you say "connected through cradle" I assume you are using Active Sync on the device. If that is the case, you will have a dynamic IP address assigned to your connection, in answers to this question you will find how to retrieve this address so that you can use it to build the connection string.

Answer 3

I solved it with this connection string.

m_Desktopconn = New SqlConnection(
  "Data Source=192.168.55.100,1433;Initial Catalog=Testing;Persist Security Info=True;User ID=sa;Password=sa;")

I had two instances MYPC\SQL2005 & MYPC\SQL2008, and then installed SQL 2005 Express on MYPC (Without instance)

Answer 4

If I understand your setup

PDA -> PC ->Sql Server(Remote).

If that's the setup you can configure via the Windows Mobile Device Center.

1. Connect the device to your PC
2. Open Windows Mobile Device Center
3. Click on Mobile Device Settings
4. Connection Settings.
5. Select 'The Internet' on the combo 'This computer is connected to:'