Re: System.Data.SqlServerCe wont work

a lot of people had this issue with System.Data.SqlServerCe not showing up
in the list of .NET Assemblies on the Project-->Add References dialog and
it is usually the result of not cleaning up some previous install of VS2005
Release Candidate or Beta/CTP properly.

whoever told you to install sqlce30setupen.msi to solve this was mistaken -
this installs the SQL Mobile Server Tools which are required for replication
and RDA. it does not "reinstall" SQL Mobile.

here is the procedure to properly clean up and get a good install of
VS2005.
http://msdn.microsoft.com/vstudio/support/uninstall/default.aspx

some of the MVPs have reported that you have to run the

vs_uninst.exe multiple times.
--
Darren Shaffer
..NET Compact Framework MVP
Principal Architect
Connected Innovation
www.connectedinnovation.com



"Andreas Roth" <AndreasRoth@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:19E3315B-FC42-4268-A694-7DF0F74EF85A@xxxxxxxxxxxxxxxx
>I installed VS2k5 and SQL Server 2k5 lately and am now trying to build a
> databasedriven CE Applikation. First System.Data.SqlServerCe was not in
> one
> of the locations it should have been. I found it somewhere in the SQL
> Server
> Programm folders and added it. I built a Database with SQL Server
> Management
> Studio and added it to the project, did a lot of coding. And It didn't
> compile, telling me I had to do a reference to System.Data Version 2.0.0.0
> which was already. I learned that I should do an installation of
> C:\Program
> Files\Microsoft SQL
> Server\90\Tools\Binn\VSShell\Common7\IDE\sqlce30setupen.msi for which I
> had
> to install IIS (which I didn't like very much) and the result is still the
> same. No DLLs where they should be, silly error while compiling. I
> restarted,
> added a new Project and tried to add all I need there. When it comes to
> the
> database file VS2K5 warns me:
> "The data provieder requiered to connect to the local data file could nt
> be
> found. The file will be added to the project but the typed DataSet
> associated
> with the file will not be generated.
>
> System.Data.SqlServerCe is referenced, and theres no typed dataset
> anywhere
> arround. I still can´t develop an database application after evenings of
> installation back and forth and thats driving me nuts. What might be wrong
> here. How can I fix that? And is microsoft calling this a final after such
> a
> long development phase? They are nearing Linux in the complexity of
> installing software.


.

Relevant Pages

  • Re: DB Architecture Questions (for joe celko)
    ... So a deck of punch cards or a mag tape is just like an SQL Schema to ... a table has a name in the database. ... OCCURS clause. ... This rule would be enforce by a REFERENCES clause on the Orders table ...
    (microsoft.public.sqlserver.programming)
  • Re: Syntax to add records if primary key = list
    ... SQL and RDBMS. ... Modern data processing began with punch cards, ... The users might not all have the same database access rights ... This rule would be enforce by a REFERENCES ...
    (comp.databases.ms-sqlserver)
  • RE: SPS WSS SQL 2000 same machine
    ... that the MSSQL$SHAREPOINT SQL Service instance is not running. ... both are installed on the SQL Server Default instance. ... You MUST install WSS before SPS. ... However, when selecting the Database ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Offline application for reporting and collect data
    ... Build one user interface that points to either you SQL Server database (when ... Build custom synchronization routines to deal with 'data exchange / ... to install SQL server and restore the database backup in the system. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Newbie question on table design.
    ... The early SQL systems were also ... built on a queues and locking model because that is what we had. ... a row is defined in the database ... REFERENCES clause on the Orders table which references the Inventory ...
    (comp.databases.theory)