#1 2019-07-12 13:57:21

nikhil.kumar3
Member
Registered: 2019-07-12

Unable to connect to Oracle Database and SQL Server Database

Hi,

I have downloaded ojdbc6.jar and sqljdbc42-6.0.8112.jar  and deployed them to  C:\Program Files\Apache Software Foundation\Tomcat 8.5\webapps\root\WEB-INF\lib. the root is reportserver folder.

But when i login to the reportserver and try to add a relational database it displays that oracle and sql drivers are missing. please help and let me know how can i resolve this issue.

Offline

#2 2019-07-12 15:25:34

eduardo
Administrator
Registered: 2016-11-01
Website

Re: Unable to connect to Oracle Database and SQL Server Database

Hi nikhil.kumar3,

for oracle you need all: ojdbc6.jar, orai18n.jar, xdb6.jar and xmlparserv2.jar or newer versions.

Regards,
Eduardo

Offline

#3 2019-07-12 19:33:48

nikhil.kumar3
Member
Registered: 2019-07-12

Re: Unable to connect to Oracle Database and SQL Server Database

Hey Eduardo,
I have put all the below mentioned jaroorat but still I am facing the same issues of driver missing...do I need to try something else...please could you help me out..I need this urgently..I have downloaded the community edition report server 3.0.7

Offline

#4 2019-07-29 06:08:38

eduardo
Administrator
Registered: 2016-11-01
Website

Re: Unable to connect to Oracle Database and SQL Server Database

Hi nikhil.kumar3,

we use reportserver together with oracle extensively so we know this works. Which oracle version are you using exactly ?
Do you get any logs regarding this in your tomcat logs?

The same for sql server. Just putting the driver in the lib libraries should work.

Could you post some screenshots?

Regards,
Eduardo

Offline

Board footer

Powered by FluxBB