Creating reports and dashboards | Stimulsoft community forum

I am trying to connect Stimulsoft Designer to a SQLCE .sdf file. I downloaded and built the Stimulsoft.Report.SqlCEDatabase project and copied the Stimulsoft.Report.SqlCeDatabase.dll library up to the designer directory and opened the designer. When i try to test the connection string I get
I added the sqlceme30.dll as well as the other required sqlce dlls to the designer directory and tried testing the connection again. This time I get the error message
I have verified that the Database Pack project build properties has Platform Target set to "Any CPU".

I'm not sure what I am doing wrong here but the installation.txt didnt mention anything about having to copy the sqlce dlls to the designer directory.

I was wondering if anyone has run into this before and if there might be a solution to this problem?

Hello.

Could you send us more detailed description of your issue or it's better to see a sample project with database file?

Thank you.

I have uploaded a zip file containing the designer with the database pack dll including within. I have also uploaded the solution that I used to build the database pack. I have not included the .sdf as it contains proprietary data but any .sdf should work as I cannot get to the point of actually connecting to it.

sorry, it appears that the upload did not work correctly. The designer zip file can be found here http://www.filedropper.com/stimulsoft and the data pack solution can be found here http://www.filedropper.com/stimulsoftsqlcedbpack

Hello,

Please check the version of your database (.sdf file). In your case it needs have version 3.0
Version of System.Data.SqlServerCe should comply with database version.

Thank you.

You were correct. My SQLCE database version was 4.0. I removed the reference to SQLCE.dll 3.0 and added 4.0 from Nuget. When I complied and dropped the resulting library into the designer it worked. I have uploaded the updated project to Github in case anyone else could use it. It can be found here https://github.com/jamesamuir/stimulsof ... tapack.git. Thank your for your help on this.

Hello,

Thank you for letting us know about the solved issue and sharing your experience with others.

Have a nice day!