The tag has no usage guidance.

learn more… | top users | synonyms

0
votes
1answer
273 views

SQL Server CE 4.0 network share access

In our application we are planning to use SQL Server CE 4.0 using OLE DB. The connection string is shown below. Dim strConn As String = "Provider=Microsoft.SQLSERVER.CE.OLEDB.4.0;Data ...
0
votes
2answers
21 views

Added a unique index, but cannot find it in TABLE_CONSTRAINTS

I'm running the following command in my DB: CREATE UNIQUE INDEX [UK_NAME1] ON [TABLE1] ([COLUMN1] ASC); Now, I'm running the following query: SELECT * FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS ...
0
votes
1answer
40 views

Locking the database to a single user so that other user wont change it

I am using SQL Server CE 4.0. In office the database (.sdf) file are on a server. When I want to change design of the database I have to copy it to local PC and access it since n/w connection to a ...
0
votes
0answers
95 views

Default value for SQL Server CE 4.0 column

I am writing a tool to convert a system from XML data files into a SQL Server CE format. Not the most efficient way to do this, but essentially it will be digesting XML files created by another ...
-1
votes
1answer
133 views

SQL Server CE tools to modify database in network share

I am using SQL Server CE 4.0 SP1. I am using Web Developer 2010 Express to connect to database and perform operations like creating table, modifying column etc. But we cannot connect a database in a ...