problems connecting to SQL Server 2005 Express from Pocket PC


Joined
Nov 28, 2005
Messages
2
Reaction score
0
Hi! I'm developping an application for pocket pc using SQL Server. I have no problems connecting to SQL Server 2000 from the pocket pc, but I cannot connect to SQL Server 2005 Express. I use Visual Studio .NET 2005 and .NET Compact Framework 2.0. I have enabled the TCP/IP protocol on the SQL Server and SQL Server Browser service. I'm able to connect to the SQL Server Express from any computer in the workgroup but not from the pocket pc. I use the System.Data.SqlClient namespace the connection string I use is MainForm.connString = @"Data Source=KAMEN\SQLEXPRESS;Initial Catalog=Kamen;User ID=kamen;Password=20052005";
This works with the .NET Framework but not with the .NET Compact Framework. The device is connected via Active Sync 4.0 and as I said has no problem to remotely connect to SQL Server 2000. Any suggestions?
 
Ad

Advertisements

Joined
Nov 28, 2005
Messages
2
Reaction score
0
I solved the problem. However if anyone has the same problem you should reinstall the SQL Server Express and remove the named instance (SQLEXPRESS).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top