Direct access to SQL Server 2005 from Windows Mobile

Hi everyone,

I've created a SQL Server database in Visual Studio 2005 and I am also planning to create a Windows Mobile application to access, edit and update this data.
So I heard that it is possible to directly access to SQL Server from the device using SQLClient rather than creating an SQL ServerCE.

I tried to use that method but I get a connection error. Here is the bit of code that was generated.

this._connection = new System.Data.SqlClient.SqlConnection();
this._connection.ConnectionString = "Data
Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirecto ry|\\MainRestaurantManagementdb.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True;";
}

Can anyone help me on this please as I am stuck and can't figure out how to solve it?

Quote:

Originally Posted by Hezal

Hi everyone,

I've created a SQL Server database in Visual Studio 2005 and I am also planning to create a Windows Mobile application to access, edit and update this data.
So I heard that it is possible to directly access to SQL Server from the device using SQLClient rather than creating an SQL ServerCE.

I tried to use that method but I get a connection error. Here is the bit of code that was generated.

this._connection = new System.Data.SqlClient.SqlConnection();
this._connection.ConnectionString = "Data
Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirecto ry|\\MainRestaurantManagementdb.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True;";
}

Can anyone help me on this please as I am stuck and can't figure out how to solve it?

Moved to SQL forum. This is more of an applications issue then a mobile specific issue.

Differerence between SQL Mobile and SQL CE ?

Hi ,

Can any one explain me how SQL CE and SQL Mobile different\similar to each other?

It's the same product, only renamed.

|||

That was the impression I had. But see this

"Microsoft SQL Server 2005 Compact Edition is the next version of SQL Server Mobile adding the desktop platform. SQL Server Compact extends the SQL Server Mobile technology by offering a low maintenance, compact embedded database for single-user client applications for all Windows platforms including tablet PCs, pocket PCs, smart phones and desktops."

The link is http://www.microsoft.com/sql/editions/compact/default.mspx

Again it shows they are different.?

|||

Well, they are different versions: 3.0 and 3.1 respectively. Basically SQL CE 3.1 has some bugs fixed from SQL Mobile (3.0) and removs restrictions for desktop support.

|||Is there a link on the Internet that lists the bugs fixed in SQL CE 3.1? I'm not having much luck finding one....

Specifically, I'd be interested to know if any bug fixes are related to "Not enough storage is available to complete this operation"...

Thanks
|||

This KB article has all the gritty details (fixes at the very bottom); http://support.microsoft.com/?kbid=920700

|||Thanks Erik , that was really great..

Differerence between SQL Mobile and SQL CE ?

Hi ,

Can any one explain me how SQL CE and SQL Mobile different\similar to each other?

It's the same product, only renamed.

|||

That was the impression I had. But see this

"Microsoft SQL Server 2005 Compact Edition is the next version of SQL Server Mobile adding the desktop platform. SQL Server Compact extends the SQL Server Mobile technology by offering a low maintenance, compact embedded database for single-user client applications for all Windows platforms including tablet PCs, pocket PCs, smart phones and desktops."

The link is http://www.microsoft.com/sql/editions/compact/default.mspx

Again it shows they are different.?

|||

Well, they are different versions: 3.0 and 3.1 respectively. Basically SQL CE 3.1 has some bugs fixed from SQL Mobile (3.0) and removs restrictions for desktop support.

|||Is there a link on the Internet that lists the bugs fixed in SQL CE 3.1? I'm not having much luck finding one....

Specifically, I'd be interested to know if any bug fixes are related to "Not enough storage is available to complete this operation"...

Thanks
|||

This KB article has all the gritty details (fixes at the very bottom); http://support.microsoft.com/?kbid=920700

|||Thanks Erik , that was really great..