Try creating a User or System DSN instead of a file DSN. It may be that
the JDBC-ODBC bridge does not support file DSNs.

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: storman AT us.eyebm DOT com (change eye to i to reply)

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.




murali ramaswamy <muralirama29 AT HOTMAIL DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
10/29/2002 10:44
Please respond to "ADSM: Dist Stor Manager"


        To:     ADSM-L AT VM.MARIST DOT EDU
        cc:
        Subject:        HELP: In TSM (Tivoli storage manager) 5.1 querying its 
databse thorugh
java code



Hi,
  I get following error when I try to run a sample java program
(source code given at end).  I am trying to make JDBC-ODBC connection to
the
TSM database through this code and the Connection call itself gives this
error:
C:\my-java>java TSM
[Microsoft][ODBC Driver Manager] Data source name not found and no default
driver specified

I have created the DSN data source file as given in ODBC doc of TSM and
the
contents of that file (TSM_DSN.dsn) are given below:

[ODBC]
DRIVER=TSM ODBC Driver
UID=admin
TCPADDR=192.168.97.44
TCPPORT=1500

Please see the java code below and let me know what I am doing wrong.
Thanks
-murali
====================
TSMConnect.java
====================

import java.sql.*;
public class TSMConnect
{
   public Connection connect() throws SQLException
  {
     try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); }
     catch (ClassNotFoundException e)
    {
      throw new SQLException("Unable to load JdbcOdbcDriver class");
    }
    // arguments are "jdbc:odbc:yourdsn", "youradmin", "yourpw"
    return DriverManager.getConnection("jdbc:odbc:TSM_DSN", "admin",
"admin");
  }
  public void close(Connection dbc, Statement stmt)
{
   try
  {
    if (stmt != null) stmt.close(); if (dbc != null) dbc.close();
  }
  catch (SQLException sqlex) {}
}
public static void main(String args[])
{
  TSMConnect TC = new TSMConnect(); Connection dbc = null; Statement stmt
=
null;
  try
{
   dbc = TC.connect();
   System.out.println("Connection opened.");
   stmt = dbc.createStatement();
   System.out.println("Created a statement.");
}
catch (SQLException sqlex)
{
   System.out.println(sqlex.getMessage());
}
finally
{
   TC.close(dbc, stmt); System.out.println("Connection closed.");
}
}

===============
TSM.java
===============

import java.sql.*;
public class TSM extends TSMConnect
{
  public static void main(String args[])
{
   if (args.length != 0)
  {
    System.out.println("Usage: java TSM");
    System.exit(1);
  }
  String query = "SELECT * FROM ACTLOG";
  TSM tsmObj = new TSM();
  Connection dbc = null;
  Statement stmt = null;
  ResultSet resultSet = null;
  try
{
    dbc = tsmObj.connect();
    stmt = dbc.createStatement();
    resultSet = stmt.executeQuery(query);
    tsmObj.presentResultSet(resultSet);
}
catch (SQLException sqlex)
{
    System.out.println(sqlex.getMessage());
  }
finally
{
  tsmObj.close(dbc, stmt);
}
}
public void presentResultSet(ResultSet rs) throws SQLException
{
  if (!rs.next()) System.out.println("No records to display");
  else
  {
    do
    {
      System.out.println(rs.getString("DATE_TIME") + ": " +
rs.getString("MESSAGE"));
     } while (rs.next());
  }
}
}





>From: Andrew Raibeck <storman AT US.IBM DOT COM>
>Reply-To: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
>To: ADSM-L AT VM.MARIST DOT EDU
>Subject: Re: In TSM (Tivoli storage manager) 5.1 querying its databse
>thorugh         java code
>Date: Mon, 28 Oct 2002 15:53:50 -0600
>
>There is no JDBC driver for TSM. However, it is possible to use the JDBC
><--> ODBC bridge to access the TSM database via Java.
>
>If you go to http://search.adsm.org and do a search with criteria:
>
>    +jdbc +raibeck
>
>You will find some discussion on this subject.
>
>In particular, I posted some sample Java code that uses the JDBC <-->
ODBC
>bridge at:
>
>    http://msgs.adsm.org/cgi-bin/get/adsm0205/395.html.
>
>I also recommend getting the latest TSM ODBC driver, 5.1.5, from the IBM
>FTP site, as it contains the latest fixes.
>
>Regards,
>
>Andy
>
>Andy Raibeck
>IBM Software Group
>Tivoli Storage Manager Client Development
>Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
>Internet e-mail: storman AT us.eyebm DOT com (change eye to i to reply)
>
>The only dumb question is the one that goes unasked.
>The command line is your friend.
>"Good enough" is the enemy of excellence.
>
>
>
>
>murali ramaswamy <muralirama29 AT HOTMAIL DOT COM>
>Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
>10/28/2002 14:29
>Please respond to "ADSM: Dist Stor Manager"
>
>
>         To:     ADSM-L AT VM.MARIST DOT EDU
>         cc:
>         Subject:        In TSM (Tivoli storage manager) 5.1 querying its
>databse thorugh java
>code
>
>
>
>Hi,
>   I have TSM 5.1 software and it has odbc driver software that I
>installed.
>However there is no jdbc odbc driver found in that driver installed
>folder.
>It is needed to make queries to the databse of TSM to get the details
>through java program that I am trying to write.  Could someone please
tell
>me where and how to find the driver class and an example of making DB
>queries to get backup jobs information?  Please let me know if there is
>anyway I could query TSM databse through java to get backup information.
>Really I appreciate help.
>Thanks
>-murali
>
>
>
>
>_________________________________________________________________
>Get a speedy connection with MSN Broadband.  Join now!
>http://resourcecenter.msn.com/access/plans/freeactivation.asp


_________________________________________________________________
Broadband? Dial-up? Get reliable MSN Internet Access.
http://resourcecenter.msn.com/access/plans/default.asp