Page 1 of 1

Can't connect to SQLite

Posted: Sun Oct 21, 2012 10:22 am
by 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

Re: Can't connect to SQLite

Posted: Mon Oct 22, 2012 6:57 am
by 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.

Re: Can't connect to SQLite

Posted: Mon Oct 22, 2012 7:16 am
by 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:
Image
and
Image

Re: Can't connect to SQLite

Posted: Mon Oct 22, 2012 10:32 am
by 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.

Re: Can't connect to SQLite

Posted: Tue Oct 23, 2012 6:28 am
by 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

Re: Can't connect to SQLite

Posted: Tue Oct 23, 2012 11:28 am
by HighAley
Hello.

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

Thank you.

Re: Can't connect to SQLite

Posted: Tue Oct 23, 2012 7:26 pm
by hmdmmdi
Hi
where is SQLite.Interop.dll ?
thanks

Re: Can't connect to SQLite

Posted: Wed Oct 24, 2012 5:29 am
by HighAley
Hello.

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