Paul, I did manage to figure this out! It's very kludgy, however.
As I said before, no combination of ODBC/JDBC would work. Yet
Access 2000 had no problems with the TSM ODBC driver.

So, I just made an Access 2000 database that has nothing but
links to the desired TSM tables. Then made a datasource to your
Access DB. In your servlet, point to the Access datasource -
voila! So there's an extra hop to get to the stuff, but in my
case its just for testing.

I am hoping to build trends of certain behaviors. So any data I
get and want to keep will get stored in new tables on the Access
side.

Doug


> -----Original Message-----
> From: ADSM: Dist Stor Manager
> [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
> Paul Zarnowski
> Sent: Wednesday, December 06, 2000 4:36 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: JDBC and TSM ODBC
>
>
> I have no answer for you, but I'm fascinated by your
> question.  I'm curious
> about what you are attempting to develop.  We will be
> trying to develop
> support web pages based on Java, servlets, jdbc,
> Informix, et al.  I have
> been wondering if there is a way to include JDBC
> access to a TSM server
> using a JDBC-ODBC bridge, which it sounds like you are
> attempting to
> do.  I'd be very interested in any progress you make
> on getting this to work.
>
> Good luck!
>
> ..Paul
>
> At 04:18 PM 12/6/2000 -0500, Doug Baker wrote:
> >Hello all. Has anyone successfully used Java & the
> JDBC to query
> >a TSM database? Our TSM is 3.7, on AIX. I've tried
> various ODBC
> >drivers, from ADSM 3.6 to TSM 3.7 to TSM 4.1 - all
> work fine when
> >getting data with MS Access 2000.
> >
> >Unfortunately when trying to get at the DB in Java, I get an
> >SQLException with the message "TSM: There is no
> information about
> >this table." This is from doing a simple "select *
> from volumes"
> >query.
> >
> >I'm definitely authenticating properly to the DB,
> because putting
> >fake username gets a "General Error."
> >
> >I'm doing this under Borland JBuilder Foundation 4.0. But note
> >that when I try to use the JDBC explorer under
> Borland JBuilder
> >3.0 Pro, I get the same problem.
> >
> >I've also tested this on NT 4.0 - so I suspect it's
> something to
> >do with JDBC, snce the same ODBC datasource is fine
> with Access.
> >Any advice would be great..
> >
> >Doug Baker
>