Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Express Edition and Compact Edition (2005)
 Specified SQL server not found

Author  Topic 

rockerboy
Starting Member

1 Post

Posted - 2009-09-26 : 21:50:26
Hi, I am new to SQL server and I am trying to set up a SQL server compact database to use in a C# application on a Windows Mobile phone. I have created a .sdf file using "Add Connections" in Visual Studio 2008 and added it to the C# smart device project. I have populated the table and have been able to execute SL queries from the server explorer. But when I try to access the database from my C# code, I am getting the following error: "Specified SQL server not found: <path>\\MyDatabase#1.sdf".

I am using the following connection string: Data Source=<path>\\MyDatabase#1.sdf;Persist Security Info=True, where <path> is the location of the .sdf file on my computer.

Please help.

Thanks,
   

- Advertisement -