I'm not really using Access, I just did it to test the ODBC
connection. The goal is to have a Java servlet.
Is the TSM DB propietary? Or is there some other JDBC driver I
could use to directly talk with the DB, and not go through the
Sun JDBC-ODBC bridge?
Doug
> -----Original Message-----
> From: ADSM: Dist Stor Manager
> [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
> Lawrence Clark
> Sent: Thursday, December 07, 2000 8:38 AM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: JDBC and TSM ODBC
>
>
> If you are already using Access, you may want to try
> asp & odbc to create dynamic content.
>
> >>> vkm AT CORNELLC.CIT.CORNELL DOT EDU 12/06/00 04:35PM >>>
> 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
>
|
