Wow. Can you create a linked server from SQL Server to TSM database(in a supported way)?
Thanks, yi >>> [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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 <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 09/04/2002 06:06 Please respond to "ADSM: Dist Stor Manager" To: [EMAIL PROTECTED] 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 [EMAIL PROTECTED] >>> [EMAIL PROTECTED] 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