JDBC driver not installed error for SQL Server 2008

[aminowestster]

I'm using the following:
1- smart client version: v8.2p_2012-11-12/EVAL Development Only
2- Browser Google Chrome Version 23.0.1271.64 m
--------------------------

The problem is:
----------------
I opened the Admin Console in order to create a new data source on sql server 2008 R2 DB. I have an error indicating the JDBC driver not installed.
I already put the sqljdbc.jar and sqljdbc4.jar files in folder ...\smartclientSDK\WEB-INF\lib
the connection data I provided is as follows:
- Database Name: TEST
- Database Type: SQLSERVER
- Obtain connection using: DriverManager
-Driver Implementer: com.microsoft.sqlserver.jdbc.SQLServerDriver
- Specify Explicit driver url : Checked
- Driver URL : jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=TEST;User=sa;Password=mypassword

Also I tried Driver Implementer to be : com.microsoft.jdbc.sqlserver.SQLServerDriver

When I click the test button, I have 6 error messages indicating there is an error
Can anyone help me to solve this problem?

[Isomorphic]

You need to post the complete server-side log for the attempt to connect (always post this log for any server-side issue).

[aminowestster]

Thank you for your reply. I need to know how to check the server log and from where?

[aminowestster]

=== 2012-11-13 08:14:41,766 [sor2] DEBUG BuiltinRPC - Testing DB connection for database: TEST with config: {
dbName:"TEST",
"database.type":"sqlserver",
"interface.type":"driverManager",
dbStatus:"JDBC Driver not installed",
driver:"com.microsoft.sqlserver.jdbc.SQLServerDriver",
"driver.url":"jdbc:sqlserver://AAMIN\\SQLEXPRESS:1431;DatabaseName=TEST;User=sa;Password=Amino1982",
useURL:true,
"driver.serverName":"Embedded in JDBC URL",
_selection_9:true,
"driver.context":"",
"interface.credentialsInURL":true,
"driver.driverType":"thin",
"driver.networkProtocol":"tcp"
}
=== 2012-11-13 08:14:41,767 [sor2] DEBUG PoolableSQLConnectionFactory - Initializing SQL config for 'TEST' from system config - using DriverManager: com.microsoft.sqlserver.jdbc.SQLServerDriver
=== 2012-11-13 08:14:41,767 [sor2] DEBUG PoolableSQLConnectionFactory - com.microsoft.sqlserver.jdbc.SQLServerDriver lookup successful
=== 2012-11-13 08:14:41,767 [sor2] DEBUG PoolableSQLConnectionFactory - DriverManager fetching connection for TEST via jdbc url jdbc:sqlserver://AAMIN\SQLEXPRESS:1431;DatabaseName=TEST;User=sa;Password=Amino1982
=== 2012-11-13 08:14:41,767 [sor2] DEBUG PoolableSQLConnectionFactory - Passing JDBC URL only to getConnection
=== 2012-11-13 08:14:41,769 [sor2] INFO BuiltinRPC - testDB (TEST) error: java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) version 1.7 is not supported by this driver. Use the sqljdbc4.jar class library, which provides support for JDBC 4.0.
=== 2012-11-13 08:14:41,769 [sor2] DEBUG RPCDMI - rpc returned RPCResponse
=== 2012-11-13 08:14:41,769 [sor2] DEBUG RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8
=== 2012-11-13 08:14:41,770 [sor2] INFO Compression - /tools/adminConsoleOperations.jsp: 325 -> 253 bytes
=== 2012-11-13 08:14:53,642 [sor2] INFO RequestContext - URL: '/isomorphic/skins/Enterprise/images/Scrollbar/hscroll_start.png', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.11 (KHTML, like Gecko) Chrome/23.0.1271.64 Safari/537.11': Safari with Accept-Encoding header
=== 2012-11-13 08:14:53,644 [sor2] INFO Download - done streaming: D:/Smart Client/SmartClient_v82p_2012-11-12_Evaluation/SmartClient_v82p_2012-11-12/smartclientSDK/isomorphic/skins/Enterprise/images/Scrollbar/hscroll_start.png
=== 2012-11-13 08:14:53,687 [sor2] INFO RequestContext - URL: '/isomorphic/skins/Enterprise/images/Scrollbar/hscroll_track.png', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.11 (KHTML, like Gecko) Chrome/23.0.1271.64 Safari/537.11': Safari with Accept-Encoding header
=== 2012-11-13 08:14:53,689 [sor3] INFO RequestContext - URL: '/isomorphic/skins/Enterprise/images/Scrollbar/hthumb_stretch.png', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.11 (KHTML, like Gecko) Chrome/23.0.1271.64 Safari/537.11': Safari with Accept-Encoding header
=== 2012-11-13 08:14:53,688 [sor8] INFO RequestContext - URL: '/isomorphic/skins/Enterprise/images/Scrollbar/hscroll_end.png', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.11 (KHTML, like Gecko) Chrome/23.0.1271.64 Safari/537.11': Safari with Accept-Encoding header
=== 2012-11-13 08:14:53,689 [sor1] INFO RequestContext - URL: '/isomorphic/skins/Enterprise/images/Scrollbar/hthumb_start.png', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.11 (KHTML, like Gecko) Chrome/23.0.1271.64 Safari/537.11': Safari with Accept-Encoding header
=== 2012-11-13 08:14:53,691 [sor3] INFO Download - done streaming: D:/Smart Client/SmartClient_v82p_2012-11-12_Evaluation/SmartClient_v82p_2012-11-12/smartclientSDK/isomorphic/skins/Enterprise/images/Scrollbar/hthumb_stretch.png
=== 2012-11-13 08:14:53,690 [sor2] INFO Download - done streaming: D:/Smart Client/SmartClient_v82p_2012-11-12_Evaluation/SmartClient_v82p_2012-11-12/smartclientSDK/isomorphic/skins/Enterprise/images/Scrollbar/hscroll_track.png
=== 2012-11-13 08:14:53,690 [sor7] INFO RequestContext - URL: '/isomorphic/skins/Enterprise/images/Scrollbar/hthumb_end.png', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.11 (KHTML, like Gecko) Chrome/23.0.1271.64 Safari/537.11': Safari with Accept-Encoding header
=== 2012-11-13 08:14:53,689 [sor4] INFO RequestContext - URL: '/isomorphic/skins/Enterprise/images/Scrollbar/hthumb_grip.png', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.11 (KHTML, like Gecko) Chrome/23.0.1271.64 Safari/537.11': Safari with Accept-Encoding header
=== 2012-11-13 08:14:53,696 [sor7] INFO Download - done streaming: D:/Smart Client/SmartClient_v82p_2012-11-12_Evaluation/SmartClient_v82p_2012-11-12/smartclientSDK/isomorphic/skins/Enterprise/images/Scrollbar/hthumb_end.png
=== 2012-11-13 08:14:53,694 [sor8] INFO Download - done streaming: D:/Smart Client/SmartClient_v82p_2012-11-12_Evaluation/SmartClient_v82p_2012-11-12/smartclientSDK/isomorphic/skins/Enterprise/images/Scrollbar/hscroll_end.png
=== 2012-11-13 08:14:53,693 [sor1] INFO Download - done streaming: D:/Smart Client/SmartClient_v82p_2012-11-12_Evaluation/SmartClient_v82p_2012-11-12/smartclientSDK/isomorphic/skins/Enterprise/images/Scrollbar/hthumb_start.png
=== 2012-11-13 08:14:53,699 [sor4] INFO Download - done streaming: D:/Smart Client/SmartClient_v82p_2012-11-12_Evaluation/SmartClient_v82p_2012-11-12/smartclientSDK/isomorphic/skins/Enterprise/images/Scrollbar/hthumb_grip.png
=== 2012-11-13 08:14:54,010 [sor2] INFO RequestContext - URL: '/isomorphic/IDACall', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.11 (KHTML, like Gecko) Chrome/23.0.1271.64 Safari/537.11': Safari with Accept-Encoding header
=== 2012-11-13 08:14:54,021 [sor2] INFO Compression - /isomorphic/IDACall: 81 -> 86 bytes
=== 2012-11-13 08:14:54,090 [sor2] INFO RequestContext - URL: '/isomorphic/IDACall', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.11 (KHTML, like Gecko) Chrome/23.0.1271.64 Safari/537.11': Safari with Accept-Encoding header

[aminowestster]

Finally I solved the problem. Thanks