Question

Locked

How to recover a corrupted .sdf file (SQL database run on a CE device)?

By LeonPatter23 ·
Tags: Windows, Software
The user could no longer access this file like normal. When I try to look at it using Query Analyzer on a CE device, all I can see is the filename, but I can't view anything about the file, such as the table names--like I can normally do.

I don't get any errors when trying to view the database structure using Query Analyzer, but it just doesn't show anything. However, if I try to a simple query, such as 'select * from tablea;', I get error 0x800004005 E_FAIL, Native Error: (0), Interface defining error: IID_IDBCreateSessaion---whatever all THAT means.

I have found a few places on the internet that say they can fix a .sdf file. But I'm wondering if there is a tool I can download to fix it--at a reasonable price--or some other way I can deal with it myself. TIA

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Share your knowledge
Back to Windows Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums