System.Data.SQLite

I'm using version 1.0.58.0 of the provider. When I'm trying to connect to a database that contains the following trigger - the connection fails: CREATE TRIGGER empty_trigger UPDATE OF name ON test1 BEGIN END Of course there is no reason for such trigger to be there in the first place but still - I'd expect the connection to succeed despite of this weird SQL construct. The error message is: The database disk image is malformed malformed database schema (empty_trigger) - near "END": syntax error Thanks in advance Liron

Upgrade. I think that was fixed in the SQLite engine a while ago.

 

Hi Robert, I've tested it with the latest version (1.0.61.0) and it still fails .. If you can provide me with a hint where to look in the provider solution I'll try fix this myself :-) Thanks in advance Liron

That's just it -- it's not a provider issue.  Try opening the database using the sqlite3.exe command-line and verify.

 

Hi Robert I've tried this and it works OK with the sqlite3.exe utility. BTW - it also works OK with many other non-.NET sqlite database managers (like SQLiteMaestro). Liron

E-mail me the database:  robert at blackcastlesoft dot com

I'll run tests on it here