You are not logged in.
Hi, I am a new one in ReportServer
I know establish connection to MySQL database.
But I need also establish connection with sybase database. Please can someone provide me manual how I can set this connection (settings in report server and adding the source), but in my case must be like for dummies. I am real new one and I don't have a many skills for this moment.
Thank you all
Last edited by Dimitrix (2017-06-15 07:58:15)
Offline
Hi Dimitrix,
You have to add the Sybase JAR file jconn4.jar to this location:
\Bitnami\reportserverenterprise-3.0.2-6\apache-tomcat\webapps\reportserver\WEB-INF\lib
You should be able to also add it to: \Bitnami\reportserver-3.0.2-6\apps\reportserver\reportserver-conf\lib but, just to make sure, first try here: \Bitnami\reportserverenterprise-3.0.2-6\apache-tomcat\webapps\reportserver\WEB-INF\lib
Then you should create a JDBC relational datasource. More information here:
https://reportserver.net/en/guides/admi … -Databases
The Sybase JDBC URL is:
jdbc:sybase:Tds:IP:2638?ServiceName=SERVICENAME
The server must have been previously started. You have to replace "IP" with your "IP". The default port 2638 must also be changed if necessary.
To start the sybase server, you can start the program dbsrv17.exe. Here you can choose your "SERVICENAME" and select the database to be reached.
Please note that with the current reportserver version there is a bug with Sybase and Saiku:
https://forum.reportserver.net/viewtopic.php?id=751
This bug is corrected in the upcoming 3.0.3 reportserver version.
Best regards,
Eduardo
Offline
Hi edulid,
Thank you a lot, it was very helpful for me
Offline