Sqlite connection error

(townsend) #1

I downloaded the sqlite-netFx45-setup-bundle-x86-2012- from system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki
I installed the driver on my Win10 x64, VS2017 x64, RO DA for .net Server Edition
Unfortunately, I can’t connect to my sqlite database now, neither Schema Modeler 7 now my application which can work before.
I used a console app to test, when connection.Open(), it throws “assembly for SQLite.NET, can not load System.Data.SQLite, Version=…”. I tested another cpp program, it works fine with this newer driver.

But now, I even can’t connect with RO after I uninstalled the new driver. How can I do?

(antonk) #2


Since you have updgraded the driver version you need to register this updated version in the DataAbstract.daConfig as well. In your case it is as simple as change the version # in the line

<AssemblyName Value="System.Data.SQLite, Version=, Culture=neutral, PublicKeyToken=db937bc2d44ff139" />


<AssemblyName Value="System.Data.SQLite, Version=, Culture=neutral, PublicKeyToken=db937bc2d44ff139" />

Then you’ll need to add the changed file as Embedded Resource to your application AND to put the changed file next to the Schema Modeler. This will allow both the client app and the Schema Modeler to use the updated driver.


(townsend) #3

thanks, it’s solved.