Ship 64bit sqlite instead of 32bit

[SinaBina]

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.

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

[JosephMDavis]

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]

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]

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