SQL Server 2008 Fails to connect to SQL Compact 3.5 Database on Win CE Device 5.0

Question

Hi,

 

I Recently moved from SQL Server 2005 Mobile to SQL Server Compact Edition 3.5 only to find out, that I cannot connect to 3.5 database from SQL Server Management Studio 2005. So I Downloaded SQL Server 2008 trial, which includes SQL Server Management Studio 2008 (SSMS 2008), which supposedly supports connection to 3.5 compact databases. THE PROBLEM is that when I try to connect to 3.5 database on Win CE device  from SSMS 2008, the Device returns an error:

 

************************************************************************

An unexpected error has occoured in TDSSERVER35.EXE

Select Quit and then restart this program, or select Details for more information.

System.Net.Sockets.Socket.

DETAILS:

TDSSERVER35.EXE

ObjectDisposedException

System.Net.Sockets.Socket

at

System.Net.Sockets.Socket:throwIfDisposed()

at System.Net.Sockets.Socket.Send()

at Microsoft.SqlServerCe.Client.TdsParser.FlushBuffer()

at Microsoft SqlServerCe.Client.Tds.TdsSession.SendDonetProc()

.

.

.

etc.

************************************************************************

SSMS 2008 returns an error:

Cannot connect to Mobile Device\Program Files\moboscore\DataBases\MainDataBase.SDF.

------------------------------
ADDITIONAL INFORMATION:

Microsoft SQL Server Compact and/or .NET Compact Framework v2.0 or later is not properly installed on your mobile device or the device is not responding. (SQL Server Compact ADO.NET Data Provider)

************************************************************************

 

PS: SSMS 2008 connects succesfuly to that same 3.5 database if copied to HDD and accessed from there.

PPS: Google never even heard about TDSSERVER35.EXE (there is not even one result about the topic!!!!!!)

Answer 1

Have you installed sqlce.dev.ENU.wce5.armv4i.CAB and sqlce.wce5.armv4i.CAB on the Device?

Answer 2

Eureka!!! Somebody elase has the exact same problem I'm having!! I also haven't a clue. Getting the exact same ....Framework 2.0 error...  Started when I installed VS 2008 SP1. The VS 2008 Server Explorer no longer connected to my Compact 3.5 databases and got that error. It worked in standard VS 2008 no SP's applied. Tried everything but to no avail. I can programatically read/write etc. just fine from my Mobile 5.0 program in the IDE. Makes no sense. Uninstalled everything and started over without the SP1 - still no longer works.

 

As you, I just installed SQL Server 2008 in the hopes it would correct the problem. Get the exact same errors. I also was able to get access both in VS 2008 and SQL 2008 if I moved the databases to my PC hdd.

 

Help! Help! Help!

Answer 3

Tried the suggestion of manually installing the 2 sqlce.......cab files. As I suspected, it made no difference. My Intermec said they were already installed but I installed over them anyway.

 

The fact that I can access/read/write SQL Compact 3.5 on the mobile device 5.0 from my application tells me there's something more insidious at work. As the originater indicated the mobile device reports problems in the TDSSERVER35.exe.

 

Any help from msoft here!!!

Answer 4

I Hard Reseted the terminal installed SQLCE CABs manualy, hard reseted again and let VS do the job for me...always the same result - TDSServer35.EXE crashes when I try to connect to the database on terminal from SSMS 2008.

 

MS HELP HELP HELP !

Answer 5

I am moving this thread to the SQL Compact Forum, which is the proper forum for this issue.

 

Answer 6

Hi there,

 

I'm having the same issue, but only with SP1 of VS 2008 applied... By the way, I'm working with a Windows Mobile 6 Professional device.

 

Olaf

 

[added]

Indeed SP1 for SQL Server Compact 3.5 for Windows Mobile doesn't seem to be part of SP1 for VS 2008.

 

After installing the "Microsoft SQL Server Compact 3.5 Service Pack 1 for Windows Mobile" (from http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=fce9abbf-f807-45d6-a457-ab5615001c8f) on my local machine and then unstalling the SQL Server Compact 3.5 from my device and reinstalling it using the new version in C:\Program Files\Microsoft SQL Server Compact Edition\v3.5\Devices\wce500\armv4i

it's now working fine again...

Answer 7

I'm also having the same issue as the others.  I had no problem connecting to the SQL CE database on my device with VS2008 and SQL Server 2005, then the same error message started to appear after I applied VS2008 SP1 and installed SQL Server 2008.

*Update*

I resolved this issue by installing SQL Server CE 3.5 SP1.  Refer to the blog entry below from Steve Lasker to get the links for the downloads:

http://blogs.msdn.com/stevelasker/archive/2008/08/07/sql-server-compact-3-5-sp1-released.aspx

Once I installed the service pack, I recompiled my device application and deployed it to the device.  After that, I can successfully connect to the SQL Server CE database from both VS 2008 with SP1 and from SQL Server 2008 Management Studio.

Answer 8

Please explain in a little more detail what you did!

 

According to the Lasker site and my computer SQL Server CE 3.5 SP1 was already installed by VS Studio SP1.

• SQL Server Compact 3.5 SP1 for desktop
• SQL Server Compact 3.5 SP1 for Devices
• SQL Server Compact 3.5 SP1 Server Tools (Merge Replication Serve2r Side Config)
• SQL Server Compact 3.5 SP1 Books Online and Samples

Which of the above downloads did you install to make everything work??

Answer 9

UPDATE

 

The previous responder is correct. These are the details of what worked for me.

 

If you've installed VS 2008 SP1 you do not need to install the '...for desktop'

 

You only need to install '...for Devices' and then rebuild your app or as I did pick up the .cab files described previously

 

sqlce.dev.ENU.wce5.armv4i.CAB

sqlce.wce5.armv4i.CAB

 

put them on your smart device and run them.

 

Voila!! everything now works and you can access the databases natively on the smart device thru VS 2008 or SQL Server 2008 management utilities.

Answer 10

UPDATE

 

Its true! SP1 of SQL Compact 3.5 Database solves the problem direct connection of SQL Server 2008 to database on mobile device!

Answer 11

Well... guess I'll have to re-install 3.5 Compact SP1.  My computer says it's 3.5 SP1 is already installed.  And it was, by both VS2008 SP1 and SQL Server 2008.

Everything was working fine until I installed SQL Server 2008.

Answer 12

To update your system to VS 2008 SP1 for Devices, you must also install the 3.5 SP1 device components (not included in VS 2008 SP1) - from here: http://www.microsoft.com/downloads/details.aspx?FamilyID=FCE9ABBF-F807-45D6-A457-AB5615001C8F&displaylang=en