Hi all,

I'm using SQL Server CE 3.5. I am using SQL Server Management Studio 2008 to
put together a SQL script for the creation of tables and I have two
questions.

First, is it in anyway possible to check for the existence of a table before
dropping it? The "IF" statement from regular SS is not supported in SSCE.
Remember I am using SS Management Studio so I don't want to do this
"programmatically". I need to do it in a SQL script.

Second, I have a foreign key constraint where a column in table A references
a column in table B. This means I cannot drop table B unless I drop table A
first or, alternatively (and what I would prefer), I drop the constraint
that A holds on B. Unfortunately there seems to be no way to simply drop a
constraint in SSCE. Basically I want to drop the constraint A holds on B.

If you know how to do either of these please let me know. And BTW, you
cannot directly manipulate the tables in INFORMATION_SCHEMA

Hi,

I'm working on smartphone windows Mobile 5. I want to use SQLCE2.0 in my
project. but I didn't find any files for SQLCE2.0 for smartphone.

can any please help me. From where do i get SQLCE2.0 for smartphone?

Please help me its urgent

Thanks

I'm naively trying to reserve a couple of fields in my database when I
create it, like this.
{L"CREATE TABLE PieceDefinition (ID INT, OwnerID INT NOT NULL, StartTime
INT NOT NULL, EndTime INT NOT NULL)"},
{L"INSERT INTO PieceDefinition VALUES (0, 0, 0, 0)"}, // outing specific
data.
{L"INSERT INTO PieceDefinition VALUES (1, 0, 0, 0)"}, // entire outing
length
{L"ALTER TABLE PieceDefinition ALTER COLUMN ID IDENTITY (2, 1)"}, // now
set up index.

Unfortunately, I'm getting an error whe I try to change the ID column to an
identity.

The error is:
SSCE_M_CANTMODIFYIDENTITYATTRIBUTE
"The column cannot become an identity column after it is created."

Is there any way around this?

Anthony Wieser
Wieser Software Ltd

Hello All,
I am having major issues trying to get to the point where I have SQL
Serverce 3.5 installed for both Desktop use as well as for Smart Devices.
I have spent the better part of my day installing and unistalling these msi
files that Microsoft says works!!!!!!

If I create a project in VS2008 (win forms or smart device) and try to
assign a Data Source of Sql Server 3.5 the data source dialog has no entry
for SSCE 3.5

What am I doing wrong????????????????

*****VISUAL STUDIO INFORMATION*****
Microsoft Visual Studio 2008
Version 9.0.30729.1 SP
Microsoft .NET Framework
Version 3.5 SP1

Installed Edition: Enterprise

Microsoft Visual Basic 2008 91899-153-0000007-60777
Microsoft Visual Basic 2008

Here I go again. I am moving to VS2008 on a Vista machine. I need both the
desktop capability of sqlce 3.5 in addition to
the mobile functionality. I understand that SQLCE 3.5 is installed via
VS2008 sp1 correct? It does not show up in "Add Remove Program" I installed
SQLCE 3.5 sp1 anyways and tried to connect to a existing SQLCE 3.1 database
thru VS2008 with no luck. I have reviewed the previuos posts here and tried
some of the recommendations with no luck. Do I need to uninsatll VS2008 and
SQLCE 3.5 sp1 and start over?

Thanking you in advance

Chuck Hecht

I want to copy the whole .sdf to another file as a db backup.

It would be convenient to do this from the application while leaving the db
connection open.

I've tested just a bit, and it seems to work fine. But it does leave me
feeling a little uneasy. I'd hate to find out later that it sometimes
raises an access exception, or worse, that there is some subtle data
corruption.

Curious to know what other people think.

Matt

When I re-start my system I have been getting an error message....
The exact message is....
"SQL Dumper library failed initialization. Your installation is either
corrupt or has been tampered with. Please uninstall then re-run setup to
correct this problem."

I think I did this accidentally when I was in add/remove programs. All I
know is I removed something (I was in a hurry and tired) accidentally and now
when I restart my computer, I get the above message. I don't know what the
program is that this message is referring to in order to remove it and add it
back.

I would appreciate it if you could direct me in the right direction.

Thank you in advance. Sreenivas

Hi,

I am trying to copy the data from one database table to another database.
The code executes without error but the data is not copied across.

My code I am using:

Dim oDS As New System.Data.DataSet

Dim connSDF1 As New System.Data.SqlServerCe.SqlCeConnection("Data
Source=F:\Database1.sdf")
Dim daSDF1 As New System.Data.SqlServerCe.SqlCeDataAdapter("SELECT *
FROM Table1", connSDF1)

connSDF1.Open()
daSDF1.Fill(oDS)
connSDF1.Close()

Dim connSDF2 As New System.Data.SqlServerCe.SqlCeConnection("Data
Source=F:\Database2.sdf")
Dim daSDF2 As New System.Data.SqlServerCe.SqlCeDataAdapter("SELECT *
FROM Table1", connSDF2)

connSDF2.Open()
daSDF2.Update(oDS)
connSDF2.Close()

Where do you guys think the .sdf should go if you're deploying to the
desktop? I'll be installing on XP and Vista (maybe even Win 2000).

I have been installing the .sdf in the application directory (actually
DataDirectory with no adjustments, same effect). This has worked OK so
far, but I don't think it is best practice, especially for Vista.

Has anyone done desktop installments supporting Vista? Thoughts on .sdf
locations? Links to best practices?

Thanks for any suggestions.

Matt