[RESOLVED] SQLClient connection problem

[Radhesham]

Hi All
I am trying to use sqlclient from Pocket PC app I am developing for connecting to SQL Server 2005 database on server.
I have referance to sqlclient.
Code looks like as under..

SqlConnection s_Conn;
s_Conn = new SqlConnection("Persist Security Info=False;Integrated Security=False;Server=xxx.xxx.xx.xx,xxxx;database=xxxxxx;user id=xxxx;password=xxxx;");
s_Conn.Open();

I started app in Pocket PC Emulator SE.
But I getting following error
Sql Server does not exists or access denied.
All user id , password etc are correct still I am not able to open connection.

Please help resolving this.
Thanks in advance.

[petevick]

Hi,
you tried taking the firewall down whilst you try to connect?

[szlamany]

I just had this issue and it was corrected by me "docking" the emulator.

http://www.vbforums.com/showthread.php?t=483020

[Radhesham]

Thanks
szlamany's link helped a lot and I could connect to sql database.
Connection happens only if I first Connect and Cradle the emulator (VS2005 Tools-> Device Emlator Manager) and then start debug.
If I start debug first and then Cradle, it does not connect and says 'Network Error'.
Is this the intended behaviour of mob apps. I am new to mob app develpoment so not clear on this.
Thanks again
Radhesham

[szlamany]

Actually it is incredibily helpful to the developer to be able to "debug" a mobile app with either of those two conditions being emulated!

Obviously if you want to connect to a network sql server you had better have the emulator state set to "docked".

And being able to "debug" your app in an "undocked" state is helpful to test logic operations that try to talk to the network.

I actually like to debug against a real device as well.