Setting DataSource in Smart Notification

 1 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
Hasmukh
New Member
Posts: 5
New Member

    I installed LBI 9.0.3 on our current windows environment running on LSF9.0 and WAS 6.1.17.  I was able to setup datasource in RS but not in SN.  I am using the following for the JDBC connection

    com.microsoft.jdbc.sqlserver.SQLServerDriver.

    When I do the test settingsI am getting the following message

    Test of Data Source Failed!

    com.microsoft.jdbc.sqlserver.SQLServerDriver.

    I am also not able to setup data source using DME connection also. 

    Did I miss anything during the installation? 

    Matthew Nye
    Veteran Member
    Posts: 514
    Veteran Member
      there should be a lot more settings than that. Have you looked in the SN Admin Guide? There are basic setup instructions there. The easiest way to set up a data source is to use the JNDI option. Set up the JDBC in WebSphere (documentation is far more thorough), note the JNDI name you give it, then use that value in the JNDI text box within the SN datasource.

      hth
      matt
      If any of my answers were helpful an endorsement on LinkedIn would be much appriciated! www.linkedin.com/pub/matthew-nye/1a/886/760/