index > SQL Server Everywhere Edition > Change database attributes with SQL?

Change database attributes with SQL?

Is there a way to change the password or encryption settings with SQL or do I need to use Compact from code to do so?

I'm trying to work around the issue that USE does not accept a password.

William (Bill) Vaughn -- Mentor, Author, Dad and MVP

William Vaughn

if you have an existing SQL CE 2 or SQL Mobile database and want to change the password or encryption settings, the only option is to run the Compact method on the SqlCeEngine object. If you have forgotten the old password, you are out of luck - there is no way to reset it.

Darren

.NET Compact Framework MVP

Darren Shaffer

I was afraid of that. Again, we need a bit of help in the SQL Ev SQL. The USE statement needs to accept a Password argument for this engine.

William (Bill) Vaughn -- Mentor, Author, Dad and MVP

William Vaughn

reply 3

You can use google to search for other answers

More Articles

• Using Push in RDA for sync the data from sql mobile to sql serve...

• SqlCe Memory issue

• Reg:Error in PULL (RDA) for data sync

• genral network error on .net framework 1.1 using system.data.sqlc...

• DB_E_ROWSNOTRELEASED ADO2.81 Recodset->Seek() after Recordset...

• Replication Error

• BadImageFormatException in tablet application

• SQL Server CE 3 Constraint Problem

• SQL Server Mobile Bug?

• How to set the default value for a datetime culomn?

Welcome to Bokebb New Update

New Articles

• Applying the updates to SQL Mobile Serve
• Select Indexes on Sql CE
• Can I use SQL_Mobile as PC desktop serve
• Windows Mobil ??SQL- Symbol MC70 Problem
• Views or not?
• SQL CE and SQL Server 2005
• Parameterized Query Using Wildcards in V
• any one know whats wrong with it
• "SQL Everywhere" is a Sybase t
• How to drop database table if it exits i
• Add connction Fails in VS.NET with SQL S
• Is there something similar to SQL 2005 r
• SET IDENTITY_INSERT tablename ON
• How to retrieve the GUID value of a SQL
• Data Source error?

Hot Articles

• SQL query problem....newbie question
• Import data to SQL Server Mobile
• unable to connect to sql server from han
• SQLEv & blobs
• Dates problem in SQL Server Everywhere e
• Corrupt SQLCE 2.0 Database File
• Test deploying WinForms app with SQL/e
• System.Data from NETCF and System.Data f
• Merge Replication with SQL Server 2000
• Funny problem (bug?) using MAX() on SQL
• RDA with Linked Servers
• Synchronizing Data Within SQLCE and SQL
• using sql Mobile Databases
• SQL CE Installation Location
• sql mobile question

Recommend Articles

• Will PPC 2003 DLL's for SQL CE work on W
• RDA SQL MOBILE ERROR 28037 HResult = -2
• Not all subscriber types in New Subscrip
• Concurrency violation on Updating Table
• limited number of connections to SQLMobi
• RDA.Pull and INNER JOINS...
• Triggers
• An instance of the SQL Server Reconciler
• duplicated data display
• RAPI fails on CeMountDBVol (WinMobile 5)
• how to start develop database applicaton
• Merge Replication IIS Worker Process Error
• How to deploy SQL Server Everywhere with
• Funny problem (bug?) using MAX() on SQL
• possible to connect to SQL Server Mobile