Hi
I would like to use the Firebird as database to ReportServer, it is possible?
I didn’t found the rs schema in ddl folder to Firebird.
Tks
Carlos
Hi Carlos,
have a look at http://blog.datenwerke.net/2013/06/adding-support-for-additional-databases.html.
More information is also available in the script and admin guides.
Cheers
Arno
Arno
Thank you for your help!
But Do I need to setup the persistence.xml to use firebird as my default reportserver database?
Tks
Carlos
Carlos,
firebird is officially only supported as a datasource, not as storage for the reportserver database. That doesn’t mean it won’t work, but it requires some extra work:
in the persistence.xml use these settings:
dialect: org.hibernate.dialect.FirebirdDialect
driver class: org.firebirdsql.jdbc.FBDriver
jdbc url: jdbc:firebirdsql://host[:port]/
to create the tables you have to adapt one of the ddl scripts provided with reportserver so it works with firebird.
Cheers,
Thorsten
Thorsten
Than you for your information!
I am going to test it.
Tks
Carlos
Carlos,
I didn’t test them, but instead of writing you on ddl based on one of the existing script, you can also try these:
http://www2.datenwerke.net/files/forum/t913/reportserver-RS2.2.1-a35ca373-schema-Firebird_CREATE.sql
http://www2.datenwerke.net/files/forum/t913/reportserver-RS2.2.1-a35ca373-schema-Firebird_DROP.sql
Thorsten
Thorsten
Thank you for these scripts.
I runned it but it didn´t work very well. I changed the script but it not work yet.
I am still working in this issue.
Tks
Cadu