steve_h


Hi,

For various reasons a new desktop application I am developing is using the SQL Server 2005 Compact Edition Release Candidate to store local data. On my development machine (XP SP2, VS2005, SQL Server 2005 Developer Edition) the software is able to create the database file, and read and write to it fine.

However on our test machine, which does not have any of the development tools the software is unable to create the database. A System.Data.SqlServerCe.SqlCeException is thrown. The message is: "SQL Mobile usage is restricted on this platform. To use SQL Mobile, you must install SQL Server 2005, Visual Studio 2005, or the Tablet PC SKU." Obviously this goes somewhat against the blurb for SQL Server CE.

Is this something that will be fixed shortly Or is it the intention that databases can't be created on machines that do not SQL Server or Visual Studio installed (Incidentally the reason for creating the database on the fly is that we are encrypting it, using the users credentials, so that only they can open the database.)

Thanks, Steve




Re: Creating databases on WinXP SP2 with SQL Server 2005 CE RC

Rajagopal R V


The restriction has been removed in RC1 bits. Have you installed RC1 bits on your test machine It looks like your test machine is using the old bits.

Thanks

Raja






Re: Creating databases on WinXP SP2 with SQL Server 2005 CE RC

steve_h

Hi,

I thought I was using the RC1 version of the software. Is there a list of the DLL's and versions that I can check against my machine, and the test machine

Thanks, Steve






Re: Creating databases on WinXP SP2 with SQL Server 2005 CE RC

Rajagopal R V

Sorry for the delayed reply. RC1 bits are of the version 3.0.5258.0

When you are running your app through VS, please check the location and version of sqlcese30.dll. It should be loaded from C:\Program Files\Microsoft SQL Server Everywhere Edition\v3.1 and of the version 3.0.5258.0

Thanks

Raja