Creating reports and dashboards | Stimulsoft community forum

Hi all,

i´m adding Stimulsoft.Report.SqlCeDatabase dll, wich i obtain from your site, to my Designer.exe directory in order to work with this databases on my pc, and everything works fine. The problem comes when i try to connect from the designer to a Sql Server database, giving the followinr error:

"Database Stimulsoft.Report.Dictionary.StiSqlDatabase not found"

To make it work i need to delete the SqlCe dll from the designer directory, so i need to copy and delete this dll all the time. It´s even worse when i use this dll in a .NET win project becouse i need to compile with or without the sqlCE depending on the database i want to use (SqlServer / SqlCE).

I think the SqlCE dll hides beneath the Sql Server class or something like that which i think is a bug, is this right? can this be solved? have you this issue solved?
i´m using the demo version by now.

Thanks in advance

Hello,

We need some additional time to check this issue. We let you know about the result in this topic.

Thank you.

Hello,

Can yu obtain full error stack for this error?

Thank you.

Hi,

the following is the error stack trace:

en Stimulsoft.Report.Dictionary.StiSqlDatabase.RegData(StiDictionary dictionary, Boolean loadData)
en Stimulsoft.Report.Dictionary.StiDictionary.CreateDatabases(Boolean loadData)
en Stimulsoft.Report.Dictionary.StiDictionary.Connect(Boolean loadData)
en Stimulsoft.Report.Engine.StiRenderProviderV2.ConnectToData(StiReport report)
en Stimulsoft.Report.Engine.StiRenderProviderV2.Render(StiReport report, StiRenderState state)
en Stimulsoft.Report.Engine.StiReportV2Builder.RenderSingleReport(StiReport masterReport, StiRenderState renderState)
en Stimulsoft.Report.StiReport.RenderReport(StiRenderState renderState)
en Stimulsoft.Report.StiReport.Render(StiRenderState renderState, StiGuiMode guiMode)
en Stimulsoft.Report.StiReport.Show(Form parentForm, IWin32Window win32Window, Boolean dialogForm)
en Stimulsoft.Report.StiReport.Show()
en WinVisorInformesP1.PruebaSQLServer_online.Form1_Load(Object sender, EventArgs e) en C:\Users\x\Documents\Visual Studio 2008\Projects\WinVisorInformesP1\WinVisorInformesP1\PruebaSQLServer_online.vb:línea 21
en System.EventHandler.Invoke(Object sender, EventArgs e)
en System.Windows.Forms.Form.OnLoad(EventArgs e)
en System.Windows.Forms.Form.OnCreateControl()
en System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
en System.Windows.Forms.Control.CreateControl()
en System.Windows.Forms.Control.WmShowWindow(Message& m)
en System.Windows.Forms.Control.WndProc(Message& m)
en System.Windows.Forms.ScrollableControl.WndProc(Message& m)
en System.Windows.Forms.ContainerControl.WndProc(Message& m)
en System.Windows.Forms.Form.WmShowWindow(Message& m)
en System.Windows.Forms.Form.WndProc(Message& m)
en System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
en System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
en System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
en System.Windows.Forms.SafeNativeMethods.ShowWindow(HandleRef hWnd, Int32 nCmdShow)
en System.Windows.Forms.Control.SetVisibleCore(Boolean value)
en System.Windows.Forms.Form.SetVisibleCore(Boolean value)
en System.Windows.Forms.Control.set_Visible(Boolean value)
en System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
en System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
en System.Windows.Forms.Application.Run(ApplicationContext context)
en Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.OnRun()
en Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.DoApplicationModel()
en Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.Run(String[] commandLine)
en WinVisorInformesP1.My.MyApplication.Main(String[] Args) en 17d14f5c-a337-4978-8281-53493378c1071.vb:línea 81
en System.AppDomain._nExecuteAssembly(Assembly assembly, String[] args)
en System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args)
en Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
en System.Threading.ThreadHelper.ThreadStart_Context(Object state)
en System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
en System.Threading.ThreadHelper.ThreadStart()

Thanks in advance and best regards

Hello,

MovilGes wrote:Hi,

the following is the error stack trace:

As I see from error stack report engine can't find Sql Database adapter in StiConfig.Services collection. Can you show all code which you use for registration SQLCe adapter?

Thank you.

Hello,

if i understand well you want me to provide you the following code:

StiConfig.Services.Add(New Stimulsoft.Report.Dictionary.StiSqlCeAdapterService())
StiConfig.Services.Add(New Stimulsoft.Report.Dictionary.StiSqlCeDatabase())

i wrote it down exactly as the sqlServerCE library instructions said
Thanks once again for your attention

Hello,

Most probabaly there is no SQL Adapter in the configuration. Please check it, possibly the Clear() method for configuration is called somewhere.
Also, please try to remove designer settings by the following path:
Win 7
[C]:\Users\[UserName]\AppData\Local\Stimulsoft\
XP
[C]:\Documents and Settings\[UserName]\Local Settings\Application Data\Stimulsoft\

Thank you.