x2bool / xlite

Query Excel spredsheets (.xlsx, .xls, .ods) using SQLite
MIT License
1.24k stars 47 forks source link

extension won't load in windows #14

Open Shtirla opened 8 months ago

Shtirla commented 8 months ago

under Windows OS in sqlite tools (sqlite3.exe) it is not possible to load the extension, I tried both dlls under x64, x86 OS, always an error: the application is not x32. I also tried loading via select load_extension('. xlite.dll'); in different interpretations the answer is always - application not found. in sqlitestudio the same picture

x2bool commented 8 months ago

Hi!

Is SQLite itself compiled for x86 or x64? To help investigate this would you be able to compile 'xlite' - this is as simple as cargo build --release if you have Rust installed on your system.

Shtirla commented 8 months ago

Unfortunately, I don't use rust, and I have problems with compiling. but I can say that I am using the latest version of the cli from the site sqlite.org sqlite-tools-win32-x86-3430200.zip. The problems may be related to the fact that sqlite.org does not supply an x64 version of the sqlite3.exe console, and my operating system is win7 x64. but on the other hand other sqlite extensions load without problems