Stay connected throught Twitter - Avnet Services, Twitter - Avnet Academy, LinkedIn, Facebook, Google+ and YouTube.Check out the latest IBM Cognos tips and tricks in the BSP Chronicles. Join our Mailing List.
how to create jdbc drivrer for 11 cognos
I wonder what are the limitations for datasources to be used to create data modules?I am getting "Results are empty" after selecting Data server.Database is Oracle, jdbc6.jar is located at \Drivers and I can use the connection in FM (C11 version) to create DQM packages so everything should be ok.
Yes, setting that option was first thing I did (the connection will not show as Data server without it).
Found the reason! My own laziness, I think!I had used ojdbc6.jar from ancient Oracle 11.2 distribution, dated from 2011.I replaced it with ojdbc7.jar downloaded directly from Oracle 12.1 download page and now I can see my schemas in db.Either that or some aggressive caching: I must confess I initially tried to create data module before I placed the odjbc6.jar in the right place. I rebooted the server a few times but that did not help. Waiting over the weekend might have done the trick but replacing the driver was first thing I did this morning...