I've used Access before without a problem except that it only pulls 50
records at a time. When doing a lookup on a large table such as CONTENTS
this generates a severe penalty to the TSM database as well as to Access. I
had hoped to import the tables I needed to MS-SQL on the theory that it
would be able to pull more rows at a time. However, I can't get the import
tool to work.
Seth Forgosh
-----Original Message-----
From: Gerhard Rentschler [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 07, 2001 8:02 AM
To: [EMAIL PROTECTED]
Subject: Re: ODBC to SQL server
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:[EMAIL PROTECTED]
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:[EMAIL PROTECTED]]On Behalf Of
> Forgosh, Seth
> Sent: Monday, May 07, 2001 1:38 PM
> To: [EMAIL PROTECTED]
> 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
> **********************************************************************
>
**********************************************************************
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
**********************************************************************
