JDBC Driver for SQL - No Suitable Driver Found
Hello,
I have installed BI Publisher 11.1.1.5 and I am not able create JDBC connection for SQL Server 2008 successfully. Connection is getting failed when I provided all the details and click on 'Test Connection' button. I found the following warning messages in the log file. I have sqljdbc4.jar file in C:\BIPub11G\user_projects\domains\bifoundation_domain\lib location and sqljdbc 3.0 and 4.0 folders in program files location.
What is the suitable driver for 11.1.1.5 version? Is there any other place (folder) where I should copy the jar file?
[2012-09-05T14:16:12.359-05:00] [AdminServer] [WARNING] [] [oracle.xdo] [tid: 11] [userId: <anonymous>] [ecid: 138f08af71a2d4b1:-48d8c41:13997bae9a3:-8000-0000000000000266,0] [APP: bipublisher#11.1.1] jdbc:hyperion:sqlserver//WBHONPSQL.wbhq.com:1436;DatabaseName=JDE_Development
I have installed BI Publisher 11.1.1.5 and I am not able create JDBC connection for SQL Server 2008 successfully. Connection is getting failed when I provided all the details and click on 'Test Connection' button. I found the following warning messages in the log file. I have sqljdbc4.jar file in C:\BIPub11G\user_projects\domains\bifoundation_domain\lib location and sqljdbc 3.0 and 4.0 folders in program files location.
What is the suitable driver for 11.1.1.5 version? Is there any other place (folder) where I should copy the jar file?
[2012-09-05T14:16:12.359-05:00] [AdminServer] [WARNING] [] [oracle.xdo] [tid: 11] [userId: <anonymous>] [ecid: 138f08af71a2d4b1:-48d8c41:13997bae9a3:-8000-0000000000000266,0] [APP: bipublisher#11.1.1] jdbc:hyperion:sqlserver//WBHONPSQL.wbhq.com:1436;DatabaseName=JDE_Development
0