Page 1 of 1

help, could not connect firebird database

Posted: Sat Dec 06, 2014 4:33 am
by riady
hi all, i need to connect to firebird database via stimulsoft .net report designer. the connection does not show up, i have download the firebird datapack from the website, unzip dan compile via visual studio 2010 C#. first i compile i get the error 'Error 1 'Stimulsoft.Report.Dictionary.StiFirebirdDatabase.ApplyDatabaseInformation(Stimulsoft.Report.Dictionary.StiDatabaseInformation, Stimulsoft.Report.StiReport, Stimulsoft.Report.Dictionary.StiDatabaseInformation)': no suitable method found to override D:\FireBird\coba\Firebird\Stimulsoft.Report.FirebirdDatabase\StiFirebirdDatabase.cs 84 30 Stimulsoft.Report.FirebirdDatabase'

here is the error:
public override void ApplyDatabaseInformation(StiDatabaseInformation information, StiReport report, StiDatabaseInformation informationAll)
{
#region Tables

foreach (DataTable dataTable in information.Tables)
{
StiFirebirdSource source = new StiFirebirdSource(this.Name,
StiNameCreation.CreateName(report, dataTable.TableName, false, false, true));
string table = dataTable.TableName;
if (table.Trim().Contains(" ")) table = string.Format("[{0}]", table);
source.SqlCommand = "select * from " + table;

foreach (DataColumn dataColumn in dataTable.Columns)
{
StiDataColumn column = new StiDataColumn(dataColumn.ColumnName, dataColumn.DataType);
source.Columns.Add(column);
}
report.Dictionary.DataSources.Add(source);
}
#endregion
}

public override void ApplyDatabaseInformation(StiDatabaseInformation information, StiReport report)
{
ApplyDatabaseInformation(information, report, null);
}


then i change 'public override void ApplyDatabaseInformation(StiDatabaseInformation information, StiReport report, StiDatabaseInformation informationAll)' to 'public Virtual void ApplyDatabaseInformation(StiDatabaseInformation information, StiReport report, StiDatabaseInformation informationAll)'

the compile success. then i get the result 'Stimulsoft.Report.FirebirdDatabase.dll' and 'Stimulsoft.Report.FirebirdDatabase.pdb'. btw i'm using 'FirebirdSql.Data.FirebirdClient.dll' version 2.5.2.

then i copy 'Stimulsoft.Report.FirebirdDatabase.dll' and 'Stimulsoft.Report.FirebirdDatabase.pdb' to 'designer.exe' location directory C:\Program Files\Stimulsoft Reports.Ultimate 2011.1 Trial\Bin.

then i open up the designer.exe but the firebird connection didn't show up in create new connection. could any body help me? thx.

Regards,
Riady

Re: help, could not connect firebird database

Posted: Mon Dec 08, 2014 6:23 am
by Alex K.
Hello,

Please check the adapter from the archive in the attachment.
Also please check the last version and let us know about the result.

Thank you.