Cyber Monday 2024! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

IBM Exam C2090-623 Topic 8 Question 76 Discussion

Actual exam question for IBM's C2090-623 exam
Question #: 76
Topic #: 8
[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?

Show Suggested Answer Hide 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


Contribute your Thoughts:

Gilbert
1 months ago
C is the right choice. Unless the administrator has a magic wand to update the JRE version, the sqljdbc4 driver is the way to go.
upvoted 0 times
...
Laura
1 months ago
I agree with Thurman. That seems like the most logical solution to rectify the problem.
upvoted 0 times
...
Vicente
2 months ago
Haha, looks like someone forgot to check the JRE version before setting up the data source. Option C seems like the way to go.
upvoted 0 times
Donette
2 hours ago
Agreed, always important to check compatibility with the drivers.
upvoted 0 times
...
Lavera
27 days ago
Make sure to double check the JRE version next time before setting up a data source.
upvoted 0 times
...
Willis
29 days ago
Yeah, copying the sqljdbc4 driver to the install location\drivers directory should fix the issue.
upvoted 0 times
...
Dona
1 months ago
I think option C is the best solution here.
upvoted 0 times
...
...
Carol
2 months ago
I'd go with D. The error message mentions the 'install location', so the driver needs to be placed in the 'dataserver/lib' directory.
upvoted 0 times
Virgilio
6 days ago
That makes sense. Placing the driver in the correct directory should resolve the issue.
upvoted 0 times
...
Cristen
7 days ago
I agree with D. The error message specifically mentions the 'dataserver/lib' directory.
upvoted 0 times
...
Mickie
8 days ago
D) Copy the sqljdbc4 driver to the install location\\5dataserver\\lib directory.
upvoted 0 times
...
Hester
19 days ago
C) Copy the sqljdbc4 driver to the install location\\drivers directory.
upvoted 0 times
...
...
Dulce
2 months ago
I think the answer is C. The error message clearly states that the JDBC driver is not supported, so we need to use the sqljdbc4 driver instead.
upvoted 0 times
Malissa
29 days ago
C) Copy the sqljdbc4 driver to the install location\\drivers directory.
upvoted 0 times
...
Rusty
1 months ago
B) Check the user account for proper logon permission.
upvoted 0 times
...
Arlette
1 months ago
A) Elevate the permission of the driver folder.
upvoted 0 times
...
...
Thurman
2 months ago
I think the administrator should copy the sqljdbc4 driver to the install location\\drivers directory.
upvoted 0 times
...

Save Cancel