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.
>>> [EMAIL PROTECTED] 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 : [EMAIL PROTECTED]
-----Mensaje original-----
De: Lawrence Clark [SMTP:[EMAIL PROTECTED]]
Enviado el: lunes 6 de noviembre de 2000 16:01
Para: [EMAIL PROTECTED]
Asunto: Re: API calls in Visual Basic
I would think you could use ACCESS and it's vb language and build a user interface.
If you want to use vb, you would still be using it's included ACCESS and the TSM
provided ODBC driver.
Using VB I would:
- install the TSM ODBC driver and create an ACCESS DB
- built my queries in ACCESS
- use VB to execute the queries and populate a VB form
But I think you could do much the same thing with just ACCESS.
>>> [EMAIL PROTECTED] 11/06/00 09:12AM >>>
Can anyone help me? I am struggling with all the calls possible to get
information and to get logged on to the TSM server. I want to execute some
queries and retrieve the results in a visual basic program to be able to create
a user interface with limited possibilities. I am a novice in programming with
VB but I want and I have to learn it. Executing the query via a dsmadmc command
in a shell instruction is I think not possible because I have to retrieve not
only the results but also the return codes to be able to interact with the
queries.
I scanned the archive but did not find any usefull information. Am I reinventing
the wheel or is it so simple that I am overlooking the solution? Reading the
manual "Using the Application Program Interface" speaks about C-programs and
headers but I am not a C-programmer.
Thank you for any minor program or any advise or hint,
Michel Engels
