Re: My sqlmobile data file corrupted

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

Ginny,

Of course, I did but I couldn't even have connection established
though. So It doesn't work at all. Thanks for your help. I almost give
up getting through this at the moment.

Regards,

Ginny Caughey [MVP] เขียน:
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: Restore of DB Backup gave some errors
    ... With many messages I would recommend checking the entire database using: ... A column nullability inconsistency was detected in the ... The index may be corrupt. ... Run DBCC CHECKTABLE to verify consistency. ...
    (microsoft.public.sqlserver.programming)
  • Re: Form does no longer bind to table
    ... The symptoms you describe indicate that the form has become corrupt, ... Then compact the database to get completely rid of this stuff. ... > I'm only using VBA code and no macros. ... > The form does not bind without filter either. ...
    (microsoft.public.access.forms)
  • Re: There isnt enough memory? -- cannot open form
    ... When you tried the SaveAsText where were you? ... Try this - close the database then reopen it and open the VB Editor. ... > I've now tried "decompile" with no success. ... >> and keep a backup of the corrupt database. ...
    (microsoft.public.access.forms)
  • Re: Cant save form as..error msg
    ... It's a common way to recover a corrupt form or database to copy the code out ... compile it empty and then paste it back in and re-compile. ... Of course it could be that the database is corrupt or mis-compiled. ...
    (microsoft.public.access.forms)
  • RE: File Lock Sharing Violation
    ... programs are on a 20 Gig C:drive on the same 800mz machine. ... Data in an Access Database because of a total Computer Hard Drive Crash. ... This is why I like Access 2000 and Windows 2000 Pro. ... With a table you might get corrupt data or corrupt indexes. ...
    (microsoft.public.access.tablesdbdesign)