ADSM-L

Re: API calls in Visual Basic

2000-11-06 10:53:44
Subject: Re: API calls in Visual Basic
From: Lawrence Clark <Larry_Clark AT THRUWAY.STATE.NY DOT US>
Date: Mon, 6 Nov 2000 10:43:39 -0500
Hi:
TSM comes with a ODBC driver to connect a front end app that support ODBC 
connections like  ACCESS to the TSM database. Basicaly:
1). Install the TSM provided ODBC driver
2). Define a user DSN on your PC using the driver
3). Create a new /empty ACCESS database
4). Select File /Get External data/ Linked files
5). Enter your TSM Admin userid/password
6) Select the tables you want to link to
7). Use the ACCESS select builder to build queries

I find it very useful for:
monitoring the number of scratch tapes remaining in the library
the number of cartridges that will be reclaimed on the next expire inventory
to create a report of cartridges that need to be returned from offsite
several other reasons.

>>> aantonh AT GIPUZKOA DOT NET 11/06/00 10:28AM >>>
How is it possible to do with ACCESS? Is there any manual where it is explained?

Angel Antón
IZFE. S.A.
Plaza de Pinares, 1-3
Donostia 20001

Tlf.: +34 943.482.869/811 , Fax: +34 943.321.023
E-Mail : aantonh AT gipuzkoa DOT net 


<Prev in Thread] Current Thread [Next in Thread>