connection error :DBD: No suitable driver found for jdbc

building semantic layer
1

Hello Friends,
I am working on upgrade project where I need to upgrade BO XIR2 to BO XIR4 system.
We have BO XIR4 on win 2008 server and it has oracle 11g 64 bit.
Now I am trying to create connection with our existing database which is oracle 10g 32 bit.
I am getting follwoing error.

DBD: No suitable driver found for jdbc

Thanks in Advance.

Manoj.s

manoj.s :india: (BOB member since 2012-08-07)

2

You need 32 bit driver to be installed on the server as well.

What are you planning to use ODBC, OLEDB or JDBC ?

BO_Chief :us: (BOB member since 2004-06-06)

3

Hello BO_Chief
Thanks for the reply.
The problem is solved it is JDBC driver issue.
And we need to copy that driver at below location with creating oracle as folder name.

C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer\jdbc\drivers
in this path create a folder as name oracle and copy the ojdbc14 driver into this problem is solved.

But now I am facing new problem
I have configure everything my previous reports also get opened from BI launchpad but it works only with localhost, if I put server ip address or server name instead of localhost then I am not able to logon into this launchpad, due to this I can not able to access this from other system.
The same problem is with CMC also.
If you have any idea please suggest me.

Thanks
Manoj.s

manoj.s :india: (BOB member since 2012-08-07)

4

Does this server has configured with DNS ? You might need to knock the door of your Network team.

Check the HOSTS file as well.

BO_Chief :us: (BOB member since 2004-06-06)

5

Thanks for Reply

I made IP enrty into HOSTS file, but same problem.
I will talk with network team about DNS configuration.

Thanks
Manoj.s

manoj.s :india: (BOB member since 2012-08-07)