ADSM-L

Re: ODBC access to TSM from VBScript

2002-09-05 21:31:00
Subject: Re: ODBC access to TSM from VBScript
From: Ung Yi <yi-1 AT MEDCTR.OSU DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 4 Sep 2002 16:58:16 -0400
Wow.

Can you create a linked server from SQL Server to TSM database(in a supported 
way)?

Thanks,
yi


>>> storman AT US.IBM DOT COM 09/04/02 10:03AM >>>
First, I recommend using the 5.1.1.1 or 4.2.2.0 ODBC driver.

A simple example of using Excel with the TSM ODBC driver:

0) Install the TSM ODBC driver and define a data source. If you are
unfamiliar with installing and configuring the ODBC driver, you should
review the README file that accompanies the ODBC driver, as it contains
information on installation and configuration. See the "Installing the
ODBC Driver" and "Defining Data Sources" sections.

1) Start Excel and create a new sheet.

2) Select the menu item "Data/Get External Data/New Database Query...".
This will bring up the "Choose Data Source" dialog.

3) From the "Choose Data Source" dialog, select the "Databases" tab
(should be the default selection) and then highlight the name of your TSM
ODBC driver data source (from step 0 above). Click "OK".

4) You should now see the "Connect to TSM Server" dialog. Enter your TSM
Admin ID (if it is not already there) and your password, then click
"Connect".

5) You should now see the "Query Wizard - Choose Columns" dialog. On the
left-hand side, select ADMINS, then click the " > " button. The columns in
the ADMINS table will now appear in the right-hand side of the dialog.
Click "Next".

6) The dialog title now reads "Query Wizard - Filter Data". You do not
need to do anything here. Just click "Next".

7) The dialog title now reads "Query Wizard - Sort Order". Again, you do
not need to do anything here. Just click "Next".

8) The dialog title now reads "Query Wizard - Finish". The "Return Data to
Microsoft Excel" radio button should be selected. Click "Finish".

9) You will now see the "Returning External Data to Microsoft Excel"
dialog. The "Existing worksheet" radio button should be selected, and the
text box should contain "=$A$1". Click "OK".

10) If all went well, then the work sheet should now contain the
information from the ADMINS table.

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: storman AT us.eyebm DOT com (change eye to i to reply)

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.




Jin Bae Chi <Jbaechi AT CSCC DOT EDU>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
09/04/2002 06:06
Please respond to "ADSM: Dist Stor Manager"


        To:     ADSM-L AT VM.MARIST DOT EDU
        cc:
        Subject:        Re: ODBC access to TSM from VBScript



Peter,
I just read your questions and it's very interesting for me, too. Can
you share with me how you configue ODBC to use with Excel? I'm kind of
new on ODBC. Thanks.



Jin Bae Chi (Gus)
System Admin/Tivoli
Data Center
614-287-2496/5922
614-287-5488 Fax
jbaechi AT cscc DOT edu


>>> pebjn AT WMDATASDC DOT DK 09/04/02 08:27AM >>>
Has anybody actually had any success in accessing the TSM database from
a
VBScript piece of code (running as asp in IIS) on a Win2K machine via
the
ODBC connection ?

I have installed the ODBC driver from the TSM 4.2 CD and configured an
ODBC
datasource with a  DSN pointing to the TSM server.

I know the ODBC DSN works because I can use Excel, MSQuery and Lotus
Approach to extract data
from the TSM database without any problems.

But what I will really like is to get it to work from VBScript.
So far I have not been successful in doing that.
All the examples I have found about how to access an ODBC datasource
from
VBScript
have ended in miscelaneous errors.

Has anybody done a similar thing from VBScript and how did you do it ?
A few lines of example code would of course be wonderful.

Regards

Peter