Menu

Can't load SQL database

Anonymous
2014-09-26
2020-02-14
  • Anonymous

    Anonymous - 2014-09-26

    Can't load Sdf database on Win 8.1 /64. (Doesn't work under Win 7 too!) Older version 1.34 doesn't work too. Some time ago it worked fine.
    The Error message says:

    Unable to open the database:
    Could not load file or assembly 'System.Data.SqIServerCe, Version=4.0.0.0, Culture= neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.

     

    Last edit: Anonymous 2014-09-26
  • compactview

    compactview - 2014-09-26

    Hi,

    Please reinstall the database server: within this web go to "Home" tab, then use links suplied to download the version 4 and install it.

     
  • Anonymous

    Anonymous - 2019-04-18

    I get the same error after changing the database from 4.0 to 3.5.
    Do you know how to make it usable in 3.5?

     
  • compactview

    compactview - 2019-04-20

    Hi,
    You have installed the version 3.5 server?
    https://www.microsoft.com/en-us/download/details.aspx?id=5783

     

    Last edit: compactview 2019-04-20
  • Anonymous

    Anonymous - 2019-05-20

    Yes. I installed the version 3.5 SP2

     
  • compactview

    compactview - 2019-05-21

    Hi, Please attach a screenshot of the error

     
  • Anonymous

    Anonymous - 2019-05-27

    I use japanese. This message has the same meaning as that of the above

     
  • compactview

    compactview - 2019-05-27

    Hi,

    The error message refers to the missing assembly corresponding to version 4.0, therefore the database you are opening is version 4.0

    Please reinstall server version 4.0 SP1:
    https://www.microsoft.com/en-US/download/details.aspx?id=30709

     
  • Anonymous

    Anonymous - 2019-05-28

    Thank you for your support.
    I hope use version 3.5 SP2 bicause the program is not compatible with version4.0 or later. And I can not rewrite the program.
    I used version4.0SP1 at the beginning but program did not move, so I used version3.5SP2 after erasing version3.5SP2.

     
  • compactview

    compactview - 2019-05-28

    Hi,

    To downgrade your database to version 3.5 you can try the following:
    1) Install both servers version 3.5 and 4.0
    2) Open your database version 4.0 and export all (menu File - Export)
    3) Create a new empty database version 3.5 (menu Tools, press the button "..." to choose a file and enter a new file name. Select version 3.5 for the database. Press the button "Create")
    4) Open your new database version 3.5 and import from the file previously exported

     
  • Anonymous

    Anonymous - 2020-02-14

    I can't open database on W 8.1/64. The error says there is a problem with sqlcese40.dll. I have reinstalled SQL server version 4.0 SP1 (SSCERuntime_x64-ENU.exe), but no way...

     
  • Anonymous

    Anonymous - 2020-02-14

    Continue...
    There is C:\Windows\System32\sqlcese40.dll version 4.0.9600.1 dated 2014 and
    "C:\Program Files\Microsoft SQL Server Compact Edition\v4.0\sqlcese40.dll" version 4.0.8876.1 dated 2012.

     

Anonymous
Anonymous

Add attachments
Cancel