SQLite adapter not showing in Designer
SQLite adapter not showing in Designer
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?
Am I missing something?
Re: SQLite adapter not showing in Designer
Hello.
Could you specify what designer do you use?
Thank you.
Could you specify what designer do you use?
Thank you.
Re: SQLite adapter not showing in Designer
Stimulsoft Reports.Ultimate 2013.1
Re: SQLite adapter not showing in Designer
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.
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.
Re: SQLite adapter not showing in Designer
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"
Services are not found in "C:\Program Files (x86)\Stimulsoft Reports.Ultimate 2013.1\Bin\Stimulsoft.Report.SQLiteDatabase.dll"
Re: SQLite adapter not showing in Designer
Hello,
Please check the .dll files and modified project in attachment.
Thank you.
Please check the .dll files and modified project in attachment.
Thank you.
- Attachments
-
- Stimulsoft.Report.SQLiteDatabase.zip
- (24.87 KiB) Downloaded 348 times
Re: SQLite adapter not showing in Designer
your assemblies are showing in the designer now.
Re: SQLite adapter not showing in Designer
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.
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.
Re: SQLite adapter not showing in Designer
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?
Re: SQLite adapter not showing in Designer
Hello,
Please try to set the "Any CPU" platform target property in build settings and let us know about the result.
Thank you.
Please try to set the "Any CPU" platform target property in build settings and let us know about the result.
Thank you.