SQLite adapter not showing in Designer

Stimulsoft Ultimate discussion
ec20
Posts: 8
Joined: Thu May 02, 2013 12:05 am

SQLite adapter not showing in Designer

Post by 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
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: SQLite adapter not showing in Designer

Post by HighAley »

Hello.

Could you specify what designer do you use?

Thank you.
ec20
Posts: 8
Joined: Thu May 02, 2013 12:05 am

Re: SQLite adapter not showing in Designer

Post by ec20 »

Stimulsoft Reports.Ultimate 2013.1
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: SQLite adapter not showing in Designer

Post by 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
Posts: 8
Joined: Thu May 02, 2013 12:05 am

Re: SQLite adapter not showing in Designer

Post by 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.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: SQLite adapter not showing in Designer

Post by Alex K. »

Hello,

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

Thank you.
Attachments
Stimulsoft.Report.SQLiteDatabase.zip
(24.87 KiB) Downloaded 348 times
ec20
Posts: 8
Joined: Thu May 02, 2013 12:05 am

Re: SQLite adapter not showing in Designer

Post by ec20 »

your assemblies are showing in the designer now.
ec20
Posts: 8
Joined: Thu May 02, 2013 12:05 am

Re: SQLite adapter not showing in Designer

Post by 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
Posts: 8
Joined: Thu May 02, 2013 12:05 am

Re: SQLite adapter not showing in Designer

Post by 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.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: SQLite adapter not showing in Designer

Post by 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.
Post Reply