Smart Device Connection String

Hi,

I'm currently working on a project, and I cannot figure out how to establish communication with a smart device application and a SQL Server database.

Here is everything I am using. My development environment is Microsoft Visual Studio 2008 w/ SP1. Within this environment, I am using .net Compact Framework 3.5 to write a C# smart device application for a Windows Mobile 6 deployment.

Right now I am testing my code using the emulator, but this code will ultimately be run on an actual PDA and the intention is for this PDA to communicate with a remote SQL Server 2008 database. I don't know how to write the connection string to accomplish this.

This is what I understand the code should look like:

SqlCeConnection myConnection = new SqlCeConnection();
myConnection.ConnectionString = "";
myConnection.Open();

Basically I need very specific instructions of how to put together the connection string. Also I would like to reference the location of the database by server instead of by using drive letters\directories.

I am essentially a beginner at this stuff and any help would be greatly appreciated.

Thanks and I hope someone will be able to help me solve this.

About two year ago i worrked with Win mobile 5,6 and i had such trouble.
As i remember, if you use SqlCe.... classes you have to work with SQL Mobile database ( it's not desktop MS SQL Server).

But if you want to connect to the desktop MS SQL database from your PDA you have to:
- create connection between PDA and desktop ( ActiveSync);
- use SqlClient classes ( classes that you use when you create usual desktop application for connection to the SQL Server database).