Choosing the Right MS SQL Driver for Client
Article ID: KB0070374
Updated On:
| Products | Versions |
|---|---|
| ibi WebFOCUS | 9.0.3 |
Description
During the installation process, when selecting the Repository connection, users are prompted to choose the driver to utilize.
In previous versions such as 82 and 92, older drivers compatible with Java 8 were commonly used. However, with the transition to Java 11, there are now several options available for drivers.
These options include:
sqljdbc 12.2
sqljdbc 12.4
sqljdbc 8.4
All of these options offer compatibility with Java 11. However, users may wonder if there are any preferences or recommendations for selecting a driver.
Resolution
The recommended course of action is to avoid using sqljdbc 12.4 and instead opt for the sqljdbc 8.4 Java 11 jar.
This recommendation is based on compatibility, stability, and performance considerations. Using the sqljdbc 8.4 Java 11 jar ensures seamless integration with the updated Java environment while maintaining reliability and optimal performance within the WebFOCUS system.
Issue/Introduction
Which MS SQL Driver to for WebFocus 9.0.3
Feedback
Yes
No
Powered by
