IBM Exam C2090-623 Topic 11 Question 63 Discussion

Actual exam question for IBM's C2090-623 exam

Question #: 63
Topic #: 11

[All C2090-623 Questions]

IBM Cognos Analytics is installed on a non-Windows platform. An administrator receives the following error after setting up a datasource connection:

''XQE-DS-0014 Unable to logon to the data source. An unexpected error from the JDBC driver ''com.microsoft.sqlserver.jdbc.SQLServerDriver'':

''java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) version 1.8 is not supported by this driver. Use the sqljdbc4.jar class library, which provides support for JDBC 4.0.''

What should the administrator do to rectify this problem?

AElevate the permission of the driver folder.

BCheck the user account for proper logon permission.

CCopy the sqljdbc4 driver to the install location\drivers directory.

DCopy the sqljdbc4 driver to the install location\5dataserver\lib directory.

Show Suggested Answer

Suggested Answer: C

Based on the error message that is displayed, it is likely that the JDBC driver is unable to read the correct '.jar' file. When performing an update of the JDBC driver to receive the new '.jar' file, the original '.jar' file is still likely to be stored in the same location as it contains the same file path that is held in the installer of the software.

Ensure that JDBC drivers are in the correct location. For the IBM Cognos Analytics, the JDBC drivers must be copied to the install_locationdrivers directory.

References:

https://developer.ibm.com/answers/questions/292756/the-xqe-ds-0014-error-message-appears-after-carryi-1.html

https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.bi_install_faq.doc/c_inst_crit_config.html

by Dulce at May 29, 2024, 10:17 AM

Limited Time Offer

25%

Off

Get Premium C2090-623 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Margret

6 months ago

Finally, a question that doesn't involve quantum computing or blockchain! Just a good old-fashioned database connection problem. C'mon, people, this is IT 101.

upvoted 0 times

...

Raylene

6 months ago

Wait, they're using a non-Windows platform? No wonder they're having issues with the SQL Server JDBC driver. Maybe they should switch to a more compatible database, or at least use the correct driver version.

upvoted 0 times

Dorethea

5 months ago

Yeah, using the correct driver version is crucial for compatibility.

upvoted 0 times

...

Malcom

5 months ago

They should definitely update the driver to the correct version for compatibility.

upvoted 0 times

...

Lasandra

5 months ago

C) Copy the sqljdbc4 driver to the install location\drivers directory.

upvoted 0 times

...

Art

5 months ago

C) Copy the sqljdbc4 driver to the install location\drivers directory.

upvoted 0 times

...

Dottie

5 months ago

A) Elevate the permission of the driver folder.

upvoted 0 times

...

Ozell

6 months ago

A) Elevate the permission of the driver folder.

upvoted 0 times

...

Jonell

6 months ago

I'm glad I don't have to deal with this kind of IT stuff. Sounds like a real headache. At least the answer is straightforward - copy the right driver and you're good to go.

upvoted 0 times

...

Shoshana

6 months ago

I agree with Laquanda. That seems like the most logical solution to fix the issue.

upvoted 0 times

...

Glendora

6 months ago

This is a classic case of not reading the error message carefully. The answer is right there - just copy the sqljdbc4 driver to the correct directory.

upvoted 0 times

...

Laquanda

6 months ago

I think the administrator should copy the sqljdbc4 driver to the install location\drivers directory.

upvoted 0 times

...

Beckie

6 months ago

The error message clearly states that the JDBC driver is not compatible with the current JRE version. The solution is to use the sqljdbc4 driver, which supports JDBC 4.0.

upvoted 0 times