search

siara-cc / esp_arduino_sqlite3_lib

Sqlite3 library for ESP8266 Arduino core
Apache License 2.0
92 stars 19 forks source link

ESP8266 NodeMCU: SQL error: file is encrypted or is not a database #15

Closed basementmedia2 closed 3 years ago

basementmedia2 commented 3 years ago

Hi,

i tried to use your library with my ESP8266 NodeMCU (SD Card Reader connected).

When i try the example "sqlite3_sdfat" which comes with the library i get the following output:

Opened database successfully
Opened database successfully
Select * from surnames where name = 'MICHELLE'
SQL error: file is encrypted or is not a database
Time taken:40043

The SD Card was formated in FAT32 and i copied the files from the data-folder of the example directory to the SD Card (via Linux).

Do you have an idea what i could try to get the example working?

Best wishes Daniel

basementmedia2 commented 3 years ago

Solved it. Sorry, i was too lame to read that i have to use sdFat 1.0.7. Now it works fine. Thanx for that great library by the way!