Prev
Next
Forums Lawson Business Intelligence/Reporting/Crystal

Setting DataSource in Smart Notification

Sort:
You are not authorized to post a reply.
Author
Messages
Hasmukh
New Member
Posts: 5
New Member
4/1/2009 10:53 AM

    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
    4/1/2009 12:15 PM
      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/
      You are not authorized to post a reply.