1 Reply Latest reply: Oct 28, 2009 9:03 AM by user109227 RSS

    Smart Space 9.3.1 Verifying JDBC Drivers

    user109227
      The instructions tell me to verify my JDBC Drivers.

      I am on SQL Server and the instructions tell me this:

      Optional: Verify the SQL Server JDBC Drivers
      The free TDS JDBC driver, is installed with Smart Space. These values are setup in
      Hyperion_Home\SmartSpace\9.3\Collaborator\conf\wildfire.xml:
      ● driver: net.sourceforge.jtds.jdbc.Driver
      ● serverURL: jdbc:jtds:sqlserver://
      host:port:database/ ;appName=Collaborator



      When I look at the wildfire.xml document it has this (it was installed this way):

      <database>
      - <defaultProvider>
      <driver>net.sourceforge.jtds.jdbc.Driver</driver>
      <serverURL>jdbc:jtds:sqlserver://hscuschlws00045.harsco.com/HFM_SmartSpace;appName=jive</serverURL>

      hsc....45.harsco.com is the host and HFM_SmartSpace is the database name.

      Do I need to add the port and remove the / in front of HFM_SmartSpace and replace it with a :

      Should the appName=jive be Collaborator instead?