Cannot connect to database with Microsoft SQL Server 2008 and WebSphere Application Server 7
While configuring the database connection in the server setup application for IBM Rational Asset Manager, when you test the connection, you see that the "Java Runtime Environment (JRE) is not supported by this driver."
You see the following error: "CRRAM703I: Database - Java Runtime Environment (JRE) version 1.6 is not supported by this driver. Use the sqljdbc4.jar class library, which provides support for JDBC 4.0."
If you try to use the sqljdbc4.jar file, you see the same error.
You must use version 1.2 of the sqljdbc.jar file.
Installing Rational Asset Manager V220.127.116.11 or V18.104.22.168 on WebSphere Application Server V7 with Microsoft SQL Server 2008
Resolving the problem
Instead of using V2.0 of the sqljdbc.jar file for SQL Server 2008, download the V1.2 driver from the Microsoft Download Center.
Follow the instructions to download and extract the sqljdbc.jar file.
Then, use that file when the server setup application for Rational Asset Manager prompts you for the JDBC file for your database server.
More support for:
Rational Asset Manager
Software version: 22.214.171.124, 126.96.36.199
Operating system(s): AIX, Linux, Windows
Software edition: Enterprise, Standard
Reference #: 1440789
Modified date: 14 July 2010