Can't Connect To Remote Sql 2005 From Mobile 5 Emiulator

m_strRDA_DBConnectionString = @"Data Source=servername;Initial Catalog=dbname;User ID=username;Password=goodpassword;Integrated Security =true; ";



Failure to open SQL Server with given connect string. [ connect string = ;Data Source=servername;Initial Catalog=dbname;User ID=username;Password=goodpassword;Integrated Security =true; ]



i used several format for servername (sql server name; machine name, IP adress and IPaddress with port number) but no able to connect..



can you tell me where /whatis the problem?



thanks

IFR



Note:

I can connect to sql 2005 database through other win C# program with no problem.

The same code with mobile 5 with sql 2000

I have no problem. Once I moved to sql 2005 (without and with SP2 istalled) .

I can access the http://ipaddress/MobileDeviceApp/sqlcesa30.dll via the mobile browser no problem.





stack list:

at System.Data.SqlServerCe.NativeMethods.CheckHRESULT()

at System.Data.SqlServerCe.SqlCeRemoteDataAccess.Pull()

at MobileDeviceApp.RDAForm.btnRDAGetData_Click()

at System.Windows.Forms.Control.OnClick()

at System.Windows.Forms.Button.OnClick()

at System.Windows.Forms.ButtonBase.WnProc()

at System.Windows.Forms.Control._InternalWnProc()

at Microsoft.AGL.Forms.EVL.EnterMainLoop()

at System.Windows.Forms.Application.Run()

at MobileDeviceApp.Program.Main()





the code for MobileDeviceApp.RDAForm.btnRDAGetData_Click()



if (File.Exists(m_strLocalDBFileName))

File.Delete(m_strLocalDBFileName);



SqlCeRemoteDataAccess pSqlCeRemoteDataAccess = null;

SqlCeEngine pSqlCeEngine = null;



try

{

pSqlCeEngine = new SqlCeEngine();

pSqlCeEngine.LocalConnectionString = m_strLocatConnectionString;

pSqlCeEngine.CreateDatabase();



pSqlCeRemoteDataAccess = new SqlCeRemoteDataAccess(m_strRDA_URL, m_strLocatConnectionString);

pSqlCeRemoteDataAccess.InternetUrl = m_strRDA_URL;

pSqlCeRemoteDataAccess.LocalConnectionString = m_strLocatConnectionString;



pSqlCeRemoteDataAccess.Pull("tb1", "SELECT id1, name FROM tb1", m_strRDA_DBConnectionString);

lblMessage.Text = @"Done";



}

catch (Exception oException)

{

lblMessage.Text = "Error: " + oException.Message;



}

pSqlCeEngine.Dispose();

pSqlCeRemoteDataAccess.Dispose();



lblMessage.Refresh();