asg017 / sqlite-regex

A fast regular expression SQLite extension, written in Rust
Apache License 2.0
166 stars 7 forks source link

Windows "module not found" error #23

Closed talatoncu closed 4 months ago

talatoncu commented 4 months ago

In windows, I use the following statement to load the extension:

db.Execute "select load_extension('F:\download1\Visual Basic\sqlite\00regexploadableextension\regex0.dll')"

I get the error

"The specified module could not be found"

I check the path as

?dir("F:\download1\Visual Basic\sqlite\00regexploadableextension\regex0.dll")

and see that the module exists in the specified directory.

Am I missing something?

Thanks and regards

talatoncu commented 4 months ago

I tried

e:\regex0.dll

same error

talatoncu commented 4 months ago

I deleted ".dll" from the file name and now I got the error

%1 is not a valid Win32 application.

talatoncu commented 4 months ago

OK! I found the problem.

The dll is compiled for win64. I am using sqlite under Visual Basic 6 which is 32 bit.

Hence, it cannot load the extension.