Problem to connect PDA with database.
-
I am using VS2008(VB.NET) and SQL Server2005 to make a Pocket PC application.The program is running successfully into PDA to connect Sql Server2005.But when I try connect PDA with Sql Express.Then it shows sql server access denied.For express I used SERVER=.\SQLEXPRESS.But its not working.Pls help me. :(
-
I am using VS2008(VB.NET) and SQL Server2005 to make a Pocket PC application.The program is running successfully into PDA to connect Sql Server2005.But when I try connect PDA with Sql Express.Then it shows sql server access denied.For express I used SERVER=.\SQLEXPRESS.But its not working.Pls help me. :(
Check, if you have enabled a remote access to the express server. It's disabled by default. http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277[^]
Pavel
-
I am using VS2008(VB.NET) and SQL Server2005 to make a Pocket PC application.The program is running successfully into PDA to connect Sql Server2005.But when I try connect PDA with Sql Express.Then it shows sql server access denied.For express I used SERVER=.\SQLEXPRESS.But its not working.Pls help me. :(
-
Whats your connection string with sql2005?? in your connection to sqlexpress you are using the piriot ".\sqlexpress", doesnt that mean local? or is sqlexpress installed in pda?
Alexei Rodriguez
I have written theConnection String for Sql Server 2005:-"Server=MyServer;Initial Catalog=MyDatabase;Uid=sa;PWD=".Surface Area Configuration Manager->Remote Connections->Using both TCP/IP and named pipes.