SQL Server Compact 3.5

Forum Home Forums Understanding the Software SQL Server Compact 3.5

This topic contains 3 replies, has 2 voices, and was last updated by Mikhail Mikhail 3 weeks, 2 days ago.

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • #4957
    linkangsun
    linkangsun
    Participant

    Dear Mikhail,
    ScadaAdmin uses reference, System.Data.SqlServerCe,to connect to BaseSDFFile in localDB, like SqlCeconnection conn = new SqlCeconnection(“Data Source =” + @”C:\SCADA\BaseSDF\ScadaBase.sdf”).However,When I did this in ScadaServerSvc.MainLogic.cs, (Reference Path is %programfile%/MicroSoft SQL Server Compact Edition/v3.5/Desktop/System.Data.SqlServerCe.dll),there comes the exception in ScadaServerSvc.log,“Unable to load the native components of SQL Server Compact corresponding to the ADO.NET provider of version 8080. Install the correct version of SQL Server Compact. Refer to KB article 974247 for more details.”
    I have tried to solve the problem by Using SqlCeEngine.Upgrade() to Upgrade BaseSDFFIle from V3.5 to v4.0, but then ScadaAdmin cannot access to BaseSDFFile.
    And what confused me is why in ScadaAdmin the Accesss is fine,however in ScadaServerSvc.MainLogic.cs,the Exception comes.

    #4958
    Mikhail
    Mikhail
    Moderator

    Hello,

    You should not use MSSQL Compact from SCADA-Server. If you need access to the configuration database from SCADA-Server, explore the files in DAT format from C:\SCADA\BaseDAT

    We will get rig of MSSQL Compact soon.

    #4959
    linkangsun
    linkangsun
    Participant

    Dear Mikhail,
    I know I should not use MSSQLCompact from SCADA-Server.The reason I do that is I need to deal with a problem that Once I Click on pass to SCADA-Server in ScadaAdmin application,the Modification in BaseDAT disappears and returns to a state which I did nothing about it,and I realized that BaseSDF rules,it will determine BaseDAT. Is there any approach to Solve this problem?

    #4961
    Mikhail
    Mikhail
    Moderator

    Could you provide the info listed below?
    1. Sequence of steps that reproduces the problem.
    2. Expected result.
    3. Actual result

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic.