Problems with SQLCE Database Pack

[jamesmuir]

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

Code: Select all

Connection error: Unable to load DLL 'sqlceme30.dll': The specified module could not be found.

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

Code: Select all

Connection error: An attempt was made to load a program with an incorrect format.

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?

[HighAley]

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.

[jamesmuir]

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.

[jamesmuir]

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

[Alex K.]

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.

[jamesmuir]

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.

[Andrew]

Hello,

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

Have a nice day!