Can thee CREATE DB command be executed succesfully against sql server ce?If yes, can username and password be specified during the exection?

Question

0.00/5 (No votes)

See more:

Can thee CREATE DB command be executed succesfully against sql server ce?If yes, can username and password be specified during the exection?

I have never heard of anyone I know executing the CREATE DB command.Is it really executabe?Can password and username be specified during its execurion?What conditions must be met in order to execute it?

Posted 28-Feb-14 2:32am

Gbenbam

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2014-02-28T02:52:00

Solution 1

Since the SqlCE connection string must include a filename (which is the database) it is difficult to see how you would execute CREATE DB: but the MSDN documentation insists you can: http://technet.microsoft.com/en-us/library/ms174454.aspx[^]

But...you don't realy need it: and empty (zero byte) file opened with the connection string is a valid (if empty) database file.

Posted 28-Feb-14 2:52am

OriginalGriff

Comments

Gbenbam 28-Feb-14 9:11am

Do you mean that if at run time I use writefile to create an empty file with a .sdf extension, that means I have a new database?Kindly expansiate on it.
What about the username and password issue, how does one secure the "new database"

OriginalGriff 28-Feb-14 9:38am

Yes. An empty SDF file is a valid SQLCE database.
Then use the Compact method:
http://msdn.microsoft.com/en-us/library/system.data.sqlserverce.sqlceengine.compact(VS.80).aspx

PIEBALDconsult · Answer 2 · 2014-02-28T05:12:00

Solution 2

I use the SqlCeEngine to CreateDatabase:

http://msdn.microsoft.com/en-us/library/system.data.sqlserverce.sqlceengine(v=vs.100).aspx[^]

Adding users, I haven't tried yet.

It appears that you can't create users in SQL Server CE
http://msdn.microsoft.com/en-us/library/ms171955.aspx[^]

Posted 28-Feb-14 5:12am

PIEBALDconsult

Updated 28-Feb-14 5:47am

v2