Ship 64bit sqlite instead of 32bit

i7MEDIA / mojoportal

mojoPortal is an extensible, cross database, mobile friendly, web content management system (CMS) and web application framework written in C# ASP.NET.

https://www.mojoportal.com

Other

197 stars 100 forks source link

Ship 64bit sqlite instead of 32bit #208

Open SinaBina opened 1 year ago

SinaBina commented 1 year ago

In a clean installation under SQLite data-layer the following error is shown before setup. Further investigation showed that under 64bit OS the sqlite runtime need to be replaced by 64bit sqlite3.dll.

Screenshot 2023-06-10 at 11-42-04 An attempt was made to load a program with an incorrect format (Exception from HRESULT 0x8007000B)

The following version fixed the issue: https://www.sqlite.org/2023/sqlite-dll-win64-x64-3420000.zip

JosephMDavis commented 1 year ago

Another fix for this is to set the "Enable 32-bit Applications" option on the application pool.

Do you think we should ship the 64-bit version instead of the 32-bit version?

SinaBina commented 1 year ago

I think 32-bit is now legacy and the default settings should be based on 64-bit binaries.I also haven't found any issues using 64-bit Sqlite so far.

JosephMDavis commented 1 year ago

We'll start shipping 64-bit. Thank you!