Re: ODBC access to TSM from VBScript

Yes, I've been able to get this to work with MS SQL 7.0 Desktop Edition
(should work with Enterprise Edition as well, I just haven't tried it).

Here are the steps I followed:

1) Start the SQL Server Enterprise Manager.

2) Navigate from "Microsoft SQL Servers" --> "SQL Server Group" -->
"STORMAN (Windows NT)" --> "Databases". Note: STORMAN is my Windows
machine name.

3) Right click on "Databases" and select "New Database..." from the pop-up
menu. This brings up the "Database Properties" dialog.

4) Select the "General" tab (should be the default). In the "Name" text
box, I put "TestTSM". Then click "OK".

5) Right click on the "TestTSM" database, and select "All Tasks/Import
Data..." from the pop-up menu. This brings up the "DTS Import Wizard"
dialog. Click "Next" to continue.

6) In the "Source" drop-down list, select "TSM ODBC Driver". Select the
"User/System DSN" radio button (normally the default), then select your
TSM ODBC driver DSN from the drop-down list. Enter your TSM Admin ID in
the "Username" text box, and your TSM Admin password in the "Password"
text box. Click "Next".

7) In the "Destination" drop-down list, select "Microsoft OLE DB Provider
for SQL Server". This is probably already selected for you by default. In
the "Server" drop-down list, select your SQL server (mine shows STORMAN).
Select the "Use Windows NT authentication" radio button. In the "Database"
drop-down list, select "TestTSM" (should already be selected). Click
"Next".

8) Select the "Copy table(s) from the source database" radio button, then
click "Next".

9) You should now see a list of the tables from the TSM server. Check the
tables you wish to copy (I picked the ADSM.ADMINS table), then click
"Next".

10) You should now be in the "Save, Schedule and Replicate Package"
dialog. Check "Run immediately" (should be the default) and leave
everything else unchecked. Click "Next".

11) Click "Finish". The table(s) you selected will be copied. Click "Done"
when the copy is complete.

12) Now in the Enterprise Manager, navigate to the "TestTSM" database, and
click on the "+" sign to open the tree. Click on "Tables".

13) The right-hand pane of the the Enterprise Manager should show a list
of tables in the TestTSM database. Among those tables will be the ones you
chose to copy from the TSM server (in my example, I see the ADMINS table).
Right-click on the table, then select "Open Table/Return all rows" from
the pop-up menu. The rows from the ADMINS table should appear.

And that's it!

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.




Ung Yi <yi-1 AT MEDCTR.OSU DOT EDU>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
09/04/2002 13:58
Please respond to "ADSM: Dist Stor Manager"


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



Wow.

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

Thanks,
yi