ADSM-L

Re: ODBC to SQL server

2001-05-07 08:03:45
Subject: Re: ODBC to SQL server
From: Gerhard Rentschler <g.rentschler AT RUS.UNI-STUTTGART DOT DE>
Date: Mon, 7 May 2001 14:01:43 +0200
I used it MS Access. It seems to work.
However, with large tables it may be slow. I don't know what happens to the
performance of the whole DB system if you try to access a TSM table through
it. Results may be unpredictable. It may be better to extract the data from
TSM offline via dsmadmc select. You can use the ODBC driver from Excel as
well. This may even be better for your decision support application.
Best regards
Gerhard

---
Gerhard Rentschler            email:g.rentschler AT rus.uni-stuttgart DOT de
Gerhard Rentschler            email:g.rentschler AT rus.uni-stuttgart DOT de
Regional Computing Center     tel.   ++49/711/685 5806
University of Stuttgart       fax:   ++49/711/682357
Allmandring 30a
D 70550
Stuttgart
Germany



> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
> Forgosh, Seth
> Sent: Monday, May 07, 2001 1:38 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: ODBC to SQL server
>
>
> Has anyone had success linking the TSM ODBC driver to a SQL
> server database?
> I'd like to do this to get a poor mans version of Decision Support until I
> can get the real thing setup. Please let me know. Thanks.
>
> Seth Forgosh
>
>
> **********************************************************************
> This message, including any attachments, contains confidential
> information intended for a specific individual and purpose, and
> is protected by law.  If you are not the intended recipient,
> please contact sender immediately by reply e-mail and destroy all
> copies.  You are hereby notified that any disclosure, copying, or
> distribution of this message, or the taking of any action based
> on it, is strictly prohibited.
> TIAA-CREF
> **********************************************************************
>
<Prev in Thread] Current Thread [Next in Thread>