Can't connect to SQLite

[hmdmmdi]

Hi, i create Stimulsoft.Report.SQLiteDatabase.dll by searching in topics. add dll's to Stimulsoft Reports.Net path and Stimulsoft Reports.Net also show sqlite connection in connections list but when i want to create a connection Stimulsoft Reports.Net says below error:

Code: Select all

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

Code: Select all

Framework: v4.0.30319

Code: Select all

Stimul Version: Version: 2012.2.1304 from 4 May 2012

I add this files to stimul path:
Stimulsoft.Report.SQLiteDatabase.dll, Stimulsoft.Report.SQLiteDatabase.pdb, System.Data.SQLite.DLL and System.Data.SQLite.xml
How can i fix this error?
Thanks

[HighAley]

Hello.

Could you describe your issue more detailed?
Did you read the installation.txt file?
How did you create the Stimulsoft.Report.SQLiteDatabase.dll file?
Please, write us a step-by-step instruction how to reproduce your issue.

Thank you.

[hmdmmdi]

Hi
My application Database is a SQLite database and i want to set a SQLite database for StimulReport.net as DataSource.
I create Stimulsoft.Report.SQLiteDatabase.dll by installation.txt.
after download SQLiteDatabase.zip extract it and open by VS2010. then add this refrences:
Stimulsoft.Base, Stimulsoft.Controls, Stimulsoft.Database, Stimulsoft.Editor, Stimulsoft.Report, Stimulsoft.Report.Design and System.Data.SQLite,
before build delete this code because don't use this refrence in codes:

Code: Select all

using Stimulsoft.Report.WpfDesign;

Build the project and copy this file to StimulReportDir/bin:
Stimulsoft.Report.SQLiteDatabase.dll, System.Data.SQLite.DLL, Stimulsoft.Report.SQLiteDatabase.pdb and System.Data.SQLite.xml
when open stimulreport designer in datasource list and connection list SQLite is added but when i want create connection this errors happened:

and

[Alex K.]

Hello,

We couldn't reproduce this bug.
Can you please send us the following information from you:
• Product name and its version;
• Detailed description of the problem and how to reproduce it;
• Your operational system (98, ME, 2000, XP, Vista or Seven), its version and localization, installed service-packs;
• Version the of Microsoft .Net Framework package installed and its localization;
• Name of your development framework and its version;
• Additional information that can help us to solve your problem.

Also please check the last prerelease build. And check the version of .dll files which you use for compile and which you copy to folder.
Thank you.

[hmdmmdi]

Hi
Name : Stimulsoft Reports.Ultimate 2012.2.1304 from 4 May 2012
I describe all of things dong in previous post.
Win 7 Service pack 1 updated until last month. localized : en
.Net framework : 4.0.30.319

[HighAley]

Hello.

Please, try to copy the SQLite.Interop.dll file to the bin folder.

Thank you.

[hmdmmdi]

Hi
where is SQLite.Interop.dll ?
thanks

[HighAley]

Hello.

This is an assembly which distributes with System.Data.SQLite.
http://system.data.sqlite.org/index.htm ... loads.wiki
Thank you.