Hi, Tim.
I've seen many things that use the TSM ODBC data source. The Admin Guide
has this to say:
IBM Tivoli Storage Manager provides an ODBC driver for Windows. The
driver
supports the ODBC Version 2.5 application programming interface (API).
Because
Tivoli Storage Manager supports only the SQL SELECT statement (query),
the
driver does not conform to any ODBC API or SQL grammar conformance
level.
After you install this driver, you can use a spreadsheet or database
application that
complies with ODBC to access the database for information.
So, it's really up to your specific application to determine whether it
can operate with only "SELECT" capability. Good luck!
________________________________
Alex Paschal
Storage Solutions Engineer
MSI Systems Integrators
(503) 943-6919 - Office
________________________________
Your Business. Better.
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Tim Brown
Sent: Monday, April 13, 2009 1:23 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] tsm odbc driver nust excel ??
Using the TSM odbc drive I can use Microsoft excel
to see TSM information, Have been doing this for awhile.
A new person working for me asked if this can be accomplished
using software like Oracle SQL developer. Is this possible
or not.
Tim Brown
Systems Specialist - Project Leader
Central Hudson Gas & Electric
284 South Ave
Poughkeepsie, NY 12601
Email: tbrown AT cenhud DOT com <mailto:tbrown AT cenhud DOT com>
Phone: 845-486-5643
Fax: 845-486-5921
Cell: 845-235-4255
This message contains confidential information and is only for the
intended recipient. If the reader of this message is not the intended
recipient, or an employee or agent responsible for delivering this
message to the intended recipient, please notify the sender immediately
by replying to this note and deleting all copies and attachments. Thank
you.
This message (including any attachments) is intended only for
the use of the individual or entity to which it is addressed and
may contain information that is non-public, proprietary,
privileged, confidential, and exempt from disclosure under
applicable law or may constitute as attorney work product.
If you are not the intended recipient, you are hereby notified
that any use, dissemination, distribution, or copying of this
communication is strictly prohibited. If you have received this
communication in error, notify us immediately by telephone and
(i) destroy this message if a facsimile or (ii) delete this message
immediately if this is an electronic communication.
Thank you.
|
