DotConnect for SQLite 4.2.77 and Visual Basic Express 2010 Problem

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for SQLite
Post Reply
Derdev
Posts: 3
Joined: Fri 14 Sep 2012 17:37

DotConnect for SQLite 4.2.77 and Visual Basic Express 2010 Problem

Post by Derdev » Fri 14 Sep 2012 17:52

I have just upgraded to DotConnect for SQLite 4.2.77 from a previous version (sorry, can't remember the version). In VB Express 2010, I have successfully gone through the manual installation of components as described in Help. However, when I open projects previously created, I get dozens of errors listed wherever the DotConnect code is used and I can't get further than the page headed "To prevent possible data loss before loading the designer, the following errors must be resolved:". I also have Visual Studio 2012 for Desktop Applications installed, where I get a similar result. Any ideas as to how I can solve the problem?

Thanks in advance.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: DotConnect for SQLite 4.2.77 and Visual Basic Express 2010 Problem

Post by Shalex » Tue 18 Sep 2012 17:04

Please remove the references to the assemblies from the previous version of dotConnect for SQLite and re-add the references to the assemblies from dotConnect for SQLite 4.2.77, rebuild the project and try to re-open the form designer.

If this doesn't help, specify the exact texts of the errors which "must be resolved".

Derdev
Posts: 3
Joined: Fri 14 Sep 2012 17:37

Re: DotConnect for SQLite 4.2.77 and Visual Basic Express 2010 Problem

Post by Derdev » Wed 19 Sep 2012 12:30

Thanks for your reply.

I removed all references to the assemblies in VB Express 2010 and then re-added them. Unfortunately, the result is the same as before.

Images of the error messages can be viewed here:

http://www.jempson.me.uk/vbexpress/

Thanks again,

Derek Jempson

Derdev
Posts: 3
Joined: Fri 14 Sep 2012 17:37

Re: DotConnect for SQLite 4.2.77 and Visual Basic Express 2010 Problem

Post by Derdev » Thu 20 Sep 2012 11:35

I hadn't previously tried rebuilding the project, so I did as you suggested and received the following error messages after building:

http://www.jempson.me.uk/vbexpress/4.JPG

If I then close the project and re-open, I get the same errors as before. As you say, for some reason VB Express can't find the assemblies.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: DotConnect for SQLite 4.2.77 and Visual Basic Express 2010 Problem

Post by Shalex » Thu 20 Sep 2012 15:35

Could not locate the assembly "Devart.Data, Version=5.0.313.0...
Could not locate the assembly "Devart.Data.SQLite, Version=3.50.214.0...
These errors say that there are references to the assemblies from the old (3.50.214.0) version of dotConnect for SQLite instead of the new one (4.2.77.0) in your application. Send us your project so that we can reproduce the issue in our environment.

Post Reply