SQLite adapter not showing in Designer

[ec20]

I have downloaded the SQLite Adapter from the Stimulsoft site and followed the instructions to compile the assembly. I then copied the Stimulsoft.Report.SQLiteDatabase.dll and System.Data.SQLite.dll assemblies to the bin directory as I have with other adapters I have added. However, when I try to add a new connection, the SQLite connection is not showing in the list of available adapters. I also added the SQLite.Interop.dll as per another forum post I saw but it did not make any difference.

Am I missing something?

[HighAley]

Hello.

Could you specify what designer do you use?

Thank you.

[ec20]

Stimulsoft Reports.Ultimate 2013.1

[Alex K.]

Hello,

Please try to add the SQLite provider from Configurator utility (select "Edit - Synchronize" menu item and then "Add Services" - and select your compiled .dll file).
Also please try to add the following code in your project:
StiConfig.Services.Add(new Stimulsoft.Report.Dictionary.StiSQLLiteAdapterService());
StiConfig.Services.Add(new Stimulsoft.Report.Dictionary.StiSQLLiteDatabase());

Please let us know about the result.
Thank you.

[ec20]

I am getting an error of:

Services are not found in "C:\Program Files (x86)\Stimulsoft Reports.Ultimate 2013.1\Bin\Stimulsoft.Report.SQLiteDatabase.dll"

[Alex K.]

Hello,

Please check the .dll files and modified project in attachment.

Thank you.

[ec20]

your assemblies are showing in the designer now.

[ec20]

The connection now shows and can be added to the report. However, when I go to create a datasource on the connection, I am getting

Could not load file or assembly 'System.Data.SQLite, Version=1.0.66.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139' or one of its dependencies. An attempt was made to load a program with an incorrect format.

[ec20]

Was your test compile of the application on a x86 or x64 machine? Does this sound like an issue with the build settings and the x86 vs x64 assemblies?

[Alex K.]

Hello,

Please try to set the "Any CPU" platform target property in build settings and let us know about the result.

Thank you.