Re: My sqlmobile data file corrupted

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I agree. Can you open the database using SQL Server Management Studio or SQL Express sp2 Management Studio? There is a Repair option under database properties with that tool.

--
Ginny


"Optimus" <sarunnio@xxxxxxxxx> wrote in message news:1171981974.253314.128280@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
By the way, my database doesn't have the password.
It seems like the password is not required here.

Ginny Caughey [MVP] เขียน:
Assuming that you really are using the right pasword, I don't. Passwords are
cases sensitve remember.

--
Ginny


"Optimus" <sarunnio@xxxxxxxxx> wrote in message
news:1171942228.913905.6600@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi Ginny,

I've tried what you suggested me to do, but I got an error which is
"[System.Data.SqlServerCe.SqlCeException] = {"The specified password
does not match the database password."}.

Any idea?

Regards,

Optimus เขียน:
> Thanks, Ginny. I'll give it a try.
>
> Ginny Caughey [MVP] เขียน:
> > Optimus,
> >
> > I don't know what caused the problem, but have you tried the Repair
> > method?
> >
> > http://msdn2.microsoft.com/en-us/library/system.data.sqlserverce.sqlceengine.repair(VS.80).aspx
> >
> > --
> > Ginny
> >
> >
> > "Optimus" <sarunnio@xxxxxxxxx> wrote in message
> > news:1171872820.188880.137620@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> > > Hi all,
> > >
> > > I'm developing a ppc app using .netcf 2.0 with sqlmobile database
> > > (sqlmobile v3.0). And, I've some problems having the sdf file
> > > corrupt. I've got an
> > > error that said "The database file may be corrupted. Interface
> > > defining error:
> > > IID_IDBInitialize". Another thing, It can not be recovered by using
> > > menu "compact" in sql
> > > analyzer.
> > >
> > > And, What I would like to know are What caused the error? and Could
> > > the
> > > corrupted file be recovered?
> > >
> > > Can anyone pls help with my problem?
> > >
> > > Thanks in advance,
> > > optimus
> > >

.

Relevant Pages

  • Re: SCECLI 1202
    ... I tried both web links. ... When I ran the esentutl /g the database came back ... I attempted to do the recovery and repair option but that ... Security policies are propagated with warning. ...
    (microsoft.public.win2000.security)
  • Re: My sqlmobile data file corrupted
    ... There is a Repair option under database ... my database doesn't have the password. ... I'm developing a ppc app using .netcf 2.0 with sqlmobile database ... corrupt. ...
    (microsoft.public.sqlserver.ce)
  • Compact and repair db question
    ... I run the compact and repair option but the database does not ... Did the compact and repair fail or did it succeed and I just need to rename ... the db1 file to the database? ...
    (microsoft.public.access.tablesdbdesign)
  • repair database password... Help
    ... Any ideas how to use the repair option for a corrupted MS Access 2000 ... On opening the database, Access prompts for the password as normal. ... become corrupt and do you want to repair. ... message a window appears that an invalid password has been entered! ...
    (comp.databases.ms-access)
  • Re: SQL Server 2005 Express - only one connection
    ... to include "User Instance= False" and it fixed my problem. ... connection and SSMS is connecting through the main instance. ... C# application to access the database. ... Management Studio, but not both. ...
    (microsoft.public.sqlserver.connect)