Re: db2 odbc

2014-04-25 Thread Erwann Simon
/docview.wss?uid=swg27021413 On 24 avril 2014 13:12:50 CEST, Remco Post r.p...@plcs.nl wrote: Hi all, I'm working on a simple excel for billing purposes (as a first step). I've installed the DB2 Data server driver ODBC (and CLI) package. And have managed to configure both a user DSN and a file DSN

Re: db2 odbc

2014-04-25 Thread Remco Post
=swg27021413 On 24 avril 2014 13:12:50 CEST, Remco Post r.p...@plcs.nl wrote: Hi all, I'm working on a simple excel for billing purposes (as a first step). I've installed the DB2 Data server driver ODBC (and CLI) package. And have managed to configure both a user DSN and a file DSN

db2 odbc

2014-04-24 Thread Remco Post
Hi all, I'm working on a simple excel for billing purposes (as a first step). I've installed the DB2 Data server driver ODBC (and CLI) package. And have managed to configure both a user DSN and a file DSN, but not a system DSN, which is what I prefer, because other people will have to be able

Re: db2 odbc

2014-04-24 Thread Prather, Wanda
Remco, I don't know if this will help you, but I had a customer report to me that the old TSM V5 ODBC driver still works with V6. Can't say for sure as I haven't used it personally. (I know the book says it is not supported.) Wanda -Original Message- From: ADSM: Dist Stor Manager

Re: 64-bit / 6.x ODBC

2011-03-14 Thread Remco Post
Unfortunately, TSM ODBC is a dead horse. The way forward seems to be to conenct directly to your TSM 6.2 DB2 database On Mon, Mar 7, 2011 at 3:31 PM, Zoltan Forray/AC/VCU zfor...@vcu.eduwrote: Has anyone seen an update to the ODBC drivers, newer than 5.5.2.0 and or a 64-bit version? My

64-bit / 6.x ODBC

2011-03-07 Thread Zoltan Forray/AC/VCU
Has anyone seen an update to the ODBC drivers, newer than 5.5.2.0 and or a 64-bit version? My SQL guy says we are phasing out our last 32-bit server, RSN, and was looking for an update. Zoltan Forray TSM Software Hardware Administrator Virginia Commonwealth University UCC/Office of Technology

TSM 6.2 + ODBC + MS Access = problems ...

2011-01-05 Thread PAC Brion Arnaud
Hi list, Some weird problem here, while trying to build a basic Access-based TSM reporting tool : I managed to get an ODBC connection to my TSM server, and to get the DB2 tables linked into Access. I'm however totally unable to read the filespace_name field in any table where it should

64-bit ODBC

2010-11-19 Thread Zoltan Forray/AC/VCU
Does anyone know if there is going to be a 64-bit ODBC driver? My SQL guy is complaining that we are down to only 1-32bit SQL server but there aren't any 64bit ODBC drivers Zoltan Forray TSM Software Hardware Administrator Virginia Commonwealth University UCC/Office of Technology Services zfor

Where to find tsm odbc driver

2010-07-22 Thread Lee, Gary D.
Did a search on the ibm site, found all kinds of documents, but never where to download. Where do I find the tsm odbc driver for server v5.5.4, client 6.2.1. Thanks for the help. Gary Lee Senior System Programmer Ball State University phone: 765-285-1310

Re: Where to find tsm odbc driver

2010-07-22 Thread km
On 22/07, Lee, Gary D. wrote: Did a search on the ibm site, found all kinds of documents, but never where to download. Where do I find the tsm odbc driver for server v5.5.4, client 6.2.1. Thanks for the help. Gary Lee Senior System Programmer Ball State University phone: 765-285-1310

Re: Where to find tsm odbc driver

2010-07-22 Thread Lee, Gary D.
...@vm.marist.edu] On Behalf Of km Sent: Thursday, July 22, 2010 9:54 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Where to find tsm odbc driver On 22/07, Lee, Gary D. wrote: Did a search on the ibm site, found all kinds of documents, but never where to download. Where do I find the tsm odbc driver

Re: Where to find tsm odbc driver

2010-07-22 Thread Andrew Raibeck
There is no more TSM ODBC driver after 5.5 because starting with TSM 6.1, you can use DB2's native ODBC driver to interrogate the TSM server tables. However, the DB2 ODBC driver will not be compatible with the legacy TSM server SELECT interface, since it would access the DB2 tables. Best regards

Re: Where to find tsm odbc driver

2010-07-22 Thread Francisco Molero
Andy, to create new queries from ODBC driver , Could we get a DB schema or view ? regards, Fran - Mensaje original De: Andrew Raibeck stor...@us.ibm.com Para: ADSM-L@VM.MARIST.EDU Enviado: jue,22 julio, 2010 16:41 Asunto: Re: Where to find tsm odbc driver There is no more TSM ODBC

TSM 6.1 ODBC

2010-05-06 Thread Francisco Molero
Hi, in TSM 6.1 I have had to updated the ODBC from TSM to DB2 ODBC and what is my surprise the tables in DB2 are different than previous version, for example auditocc doesn't exist any more. I have created a lot of queries and I would like to know if IBM has provided the views or the db

Re: TSM 6.1 ODBC

2010-05-06 Thread Richard Sims
On May 6, 2010, at 5:12 PM, Francisco Molero wrote: Hi, in TSM 6.1 I have had to updated the ODBC from TSM to DB2 ODBC and what is my surprise the tables in DB2 are different than previous version, for example auditocc doesn't exist any more. I have created a lot of queries and I would like

ODBC with TSM 6.1 (DB2)

2009-07-09 Thread Nicholas Rodolfich
Hello All, Thanks for your help!! Prior to TSM 6.1 IBM supplied n ODBC driver that was quite useful using Excel as a front end. I am a UNIX guy but are found the Excel method very useful in TSM instance analysis. I need the same capabilities for TSM 6.1 but cannot seem to get it to work

Re: ODBC with TSM 6.1 (DB2)

2009-07-09 Thread Mikael Lindstrom
Hi, found this, hope it will help https://www.ibm.com/developerworks/wikis/display/tivolistoragemanager/TSM+V6.1+Mining+the+Database+Using+ODBC+or+Other+Connectors Intellectuals solve problems; geniuses prevent them - Albert Einstein Nicholas Rodolfich nrodolf...@cmaontheweb.com Sent

Installing / Configuring DB2 ODBC Driver for Windows (TSM 6.1)

2009-06-11 Thread Dennis, Melburn (IT Solutions US)
I have a TSM 6.1 server runing in a test environment. With 5.5 I would use the TSM ODBC drivers on my XP laptop to run SQL queries against the database. The ODBC drivers were available in a nice install package. I am not having any luck figuring out how to install DB2 ODBC drivers on my laptop

tsm odbc driver nust excel ??

2009-04-13 Thread Tim Brown
Using the TSM odbc drive I can use Microsoft excel to see TSM information, Have been doing this for awhile. A new person working for me asked if this can be accomplished using software like Oracle SQL developer. Is this possible or not. Tim Brown Systems Specialist - Project Leader Central

Re: tsm odbc driver nust excel ??

2009-04-13 Thread Alex Paschal
Hi, Tim. I've seen many things that use the TSM ODBC data source. The Admin Guide has this to say: IBM Tivoli Storage Manager provides an ODBC driver for Windows. The driver supports the ODBC Version 2.5 application programming interface (API). Because Tivoli Storage Manager supports only

Re: tsm odbc driver nust excel ??

2009-04-13 Thread Richard Sims
On Apr 13, 2009, at 4:23 PM, Tim Brown wrote: Using the TSM odbc drive I can use Microsoft excel to see TSM information, Have been doing this for awhile. A new person working for me asked if this can be accomplished using software like Oracle SQL developer. Is this possible or not. The TSM

Re: ODBC errors after upgrading to V5.3.5

2008-04-01 Thread Howard Coles
: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Bill Boyer Sent: Tuesday, April 01, 2008 9:10 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] ODBC errors after upgrading to V5.3.5 I have Autovault running on aa Windows2000 server with an old 5.1 client and ODBC drive. I upgraded

ODBC errors after upgrading to V5.3.5

2008-04-01 Thread Bill Boyer
I have Autovault running on aa Windows2000 server with an old 5.1 client and ODBC drive. I upgraded the ODBC to 5.3.5 and the thing just stopped working. I don't think it's an Autovault issue. Turning on the ODBC trace I see the error. Unfortunately this server doesn't have Excel loaded. Tue

Re: ODBC errors after upgrading to V5.3.5

2008-04-01 Thread Bill Boyer
Wireless BlackBerry -Original Message- From: Howard Coles [EMAIL PROTECTED] Date: Tue, 1 Apr 2008 09:24:18 To:ADSM-L@VM.MARIST.EDU Subject: Re: ODBC errors after upgrading to V5.3.5 You need to update the client to match if you haven't already, otherwise it will not work. Not only

Re: ODBC errors after upgrading to V5.3.5

2008-04-01 Thread Andrew Raibeck
Hi Bill, FYI, there is no dependency between ODBC driver and installed TSM client. The ODBC driver is a self-contained entity. So at least for the purposes of ODBC, changing client levels has no effect. I have seen this reported by several customers, but we are unable to recreate this in the lab

Re: ODBC errors after upgrading to V5.3.5

2008-04-01 Thread Bill Boyer
@VM.MARIST.EDU Subject: Re: ODBC errors after upgrading to V5.3.5 Hi Bill, FYI, there is no dependency between ODBC driver and installed TSM client. The ODBC driver is a self-contained entity. So at least for the purposes of ODBC, changing client levels has no effect. I have seen this reported

Connect to TSM using the JDBC/ODBC bridge

2006-11-06 Thread Joe Crnjanski
Hello, We are trying to connect to TSM by using JDBC/ODBC bridge. When we try, we get a general failure with no information in any logs. There is no problem to connect using only ODBC driver. I would appreciate any response from anybody who tried to establish connection to TSM using

Re: Connect to TSM using the JDBC/ODBC bridge

2006-11-06 Thread Andrew Raibeck
Well, I replied to your similar post (originially included Tomcat as part of the picture) a few weeks ago, as follows: The first thing would be to flesh out the problem description in a lot more detail. - what is running where - what operating systems are involved - what TSM server and ODBC

Re: Connect to TSM using the JDBC/ODBC bridge

2006-11-06 Thread Joe Crnjanski
Sent: Monday, November 06, 2006 2:15 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: Connect to TSM using the JDBC/ODBC bridge Well, I replied to your similar post (originially included Tomcat as part of the picture) a few weeks ago, as follows: The first thing would be to flesh out the problem

Re: Connect to TSM using the JDBC/ODBC bridge

2006-11-06 Thread Andrew Raibeck
: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Raibeck Sent: Monday, November 06, 2006 2:15 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: Connect to TSM using the JDBC/ODBC bridge Well, I replied to your similar post (originially included Tomcat as part of the picture) a few weeks

Re: TSM JDBC ODBC and Tomcat

2006-10-17 Thread Andrew Raibeck
The first thing would be to flesh out the problem description in a lot more detail. - what is running where - what operating systems are involved - what TSM server and ODBC versions are involved - what version of Tomcat is involved - *HOW* is Tomcat involved - is this an app running under Tomcat

Re: TSM JDBC ODBC and Tomcat

2006-10-17 Thread Kelly Lipp
: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Raibeck Sent: Tuesday, October 17, 2006 11:27 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] TSM JDBC ODBC and Tomcat The first thing would be to flesh out the problem description in a lot more detail. - what is running where

TSM JDBC ODBC and Tomcat

2006-10-16 Thread Joe Crnjanski
Hello, Trying to connect to TSM using the JDBC.ODBC bridge. When the connect is issued Tomcat shuts down with no error messages in the logs or anywhere. Any help or direction much appreciated. Thanks Joe Crnjanski Infinity Network Solutions Inc. Phone: 416-235-0931 x226 Fax: 416-235-0265

ODBC code for TSM

2005-12-13 Thread Joni Moyer
Hello Everyone! Would anyone happen to know where I can get the ODBC code for TSM? Thanks in advance! Joni Moyer Highmark Storage Systems, Systems Programmer NEW NUMBER: (717)302-9966 NEW FAX: (717) 302-9826 [EMAIL PROTECTED]

Re: ODBC code for TSM

2005-12-13 Thread David W Litten
@vm.marist.edu Dist Stor cc Manager [EMAIL PROTECTED] Subject .edu [ADSM-L] ODBC code for TSM 12/13/2005 07:57 AM

Re: ODBC code for TSM

2005-12-13 Thread Allen S. Rout
== On Tue, 13 Dec 2005 09:42:16 -0500, David W Litten [EMAIL PROTECTED] said: ftp://service.boulder.ibm.com/storage/tivoli-storage-management/maintenance/client/v5r3/Windows/x32/LATEST/ Has anyone hit the ODBC interface from non-windows clients? It'd be quite pleasant to have scripts hitting

ODBC Driver Connection

2005-08-11 Thread Debbie Bassler
I have downloaded the TSM ODBC driver. I tried using Access and extracting the table data, but that takes a long time. Does anyone else use the ODBC driver connection, and if so, how do you connect to it to easily select data from the tables? Thanks, Debbie

Re: ODBC Driver Connection

2005-08-11 Thread Lawrence Clark
Just like you do...using the driver and building queries. [EMAIL PROTECTED] 08/11/2005 2:15:57 PM I have downloaded the TSM ODBC driver. I tried using Access and extracting the table data, but that takes a long time. Does anyone else use the ODBC driver connection, and if so, how do you connect

Re: ODBC Driver Connection

2005-08-11 Thread Andrew Raibeck
Debbie, the ODBC driver isn't inherently faster than other methods for SELECTing data from the TSM database (it is really just a pass-through mehanism for sending SELECT statements to the server and returning results to the application). Increasing the fetch size in the data source configuration

Re: TSM 5.2/W2K3 ODBC and Snapshot error

2004-07-12 Thread Tao Jiang
But ODBC has no error on Window2000, same configuration. - Original Message - From: Henrik Wahlstedt [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, July 05, 2004 2:11 AM Subject: Re: TSM 5.2/W2K3 ODBC and Snapshot error Your error messages are self explaining, 'invalid password

Re: TSM 5.2/W2K3 ODBC and Snapshot error

2004-07-12 Thread Andrew Raibeck
The snapshot-related error messages should be self-explanatory, as has been pointed out. The password-related informatino is also self-explanatory; an incorrect password was entered. I don't see anything in the information you have provided that suggests there is an ODBC issue at all. Can you

Re: TSM 5.2/W2K3 ODBC and Snapshot error

2004-07-05 Thread Henrik Wahlstedt
likely fail. Even if you specify E:\ArchiveFolder\.. //Henrik Hi, TSM5.2.2.5/ Win2003 ODBC Get error, can not connect to TSM. 07/01/2004 17:15:04 cuGetAuthResult: Authorization failed. Result code: 2 07/01/2004 17:15:04 sessOpen: Error 137 from signon authentication. 07/01/2004 17:15:04 ANS1051E

TSM 5.2/W2K3 ODBC and Snapshot error

2004-07-02 Thread Tao Jiang
Hi, TSM5.2.2.5/ Win2003 ODBC Get error, can not connect to TSM. 07/01/2004 17:15:04 cuGetAuthResult: Authorization failed. Result code: 2 07/01/2004 17:15:04 sessOpen: Error 137 from signon authentication. 07/01/2004 17:15:04 ANS1051E Invalid password When Client 5.2.2.5 archives files

Re: DSN-Less Connection String for TSM ODBC

2004-04-30 Thread Andrew Raibeck
Yes, you can call SQLDriverConnect() with a valid connection string. The ODBC driver README file includes information on creating file DSNs. The parameters discussed therein apply to the SQLDriverConnect() string as well, and can be used to created DSN-less connection strings. Example of a string

Re: DSN-Less Connection String for TSM ODBC

2004-04-30 Thread Peter L. Buschman
Andrew: Thanks very much for the feedback. I had read the README and tried those but must have combined them incorrectly the first time. After some more experimentation, the following worked for me: DRIVER={TSM ODBC Driver};UID=admin;PWD=adminpassword;TCPADDR=myserver.company.com;TCPPORT

DSN-Less Connection String for TSM ODBC

2004-04-29 Thread Peter L. Buschman
Subject line says it all... anybody know how to properly format a connection string for use with the TSM ODBC driver so that you don't need to create a DSN beforehand? --PLB

Querying Drive Status from the CLI or ODBC

2004-04-22 Thread Peter L. Buschman
I'm trying to identify the best method for polling the following information from TSM using the CLI or ODBC interfaces. The results will serve as input into a script. What is the best way to query the following? 1.) Number of drives defined on a TSM server. 2.) Status of each drive (in-use

Re: Querying Drive Status from the CLI or ODBC

2004-04-22 Thread David E Ehresman
From the command line, 'select * from drives' [EMAIL PROTECTED] 4/22/2004 11:43:14 AM I'm trying to identify the best method for polling the following information from TSM using the CLI or ODBC interfaces. The results will serve as input into a script. What is the best way to query

ODBC select statement via Host Monitor software

2004-04-19 Thread Tony Morgan
Hi Fellow Tivolions... Has anyone used Host Monitor from KS-Soft to access the Tivoli Database via the ITSM ODBC Driver? What did you do to make it work I am getting unknown data type and Invalid cursor state messages from select statements that work fine from MS Query. Cheers Tony Morgan

Re: ODBC select statement via Host Monitor software

2004-04-19 Thread Andrew Raibeck
Hi Tony, I am unfamiliar with the Host Monitor product. Which ODBC driver version are you using? Is it current? If not, then my first recommendation would be to get on the latest greatest (5.2.2). If that doesn't help, then have a look at the problem determination guide at http

ODBC driver

2003-12-11 Thread Peter Schrijvers
Hello, I want to install an ODBC driver so I can prepare some reports. I want to use excel for it (W2K). Is there anybody who can tell me where I can find this driver? Many thanks, Peter Schrijvers BASF-IT-Services NV

Antwort: ODBC driver

2003-12-11 Thread Christian Demnitz
Hello, try to search for TSM ODBC Driver in the Internet! On ome University Servers you can download. Try to use google for your search. [EMAIL PROTECTED] Datum:11.12.2003 09:39 An: [EMAIL PROTECTED] Antwort an: ADSM: Dist Stor Manager [EMAIL PROTECTED

AW: ODBC driver

2003-12-11 Thread Thomas Carduck
Hi Peter You can find the ODBC Driver on the IBM FTP Server : ftp.ibm.com/storage/tivoli-storage-management/maintenance/client/v5r2/Window s/Win32/v520/ Tom -Ursprungliche Nachricht- Von: Peter Schrijvers [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 11. Dezember 2003 09:40

Re: ODBC driver

2003-12-11 Thread Pole, Stephen
Hi Peter, Try this. NOTE it is for V5R1 The installation package is available from the FTP server ftp.software.ibm.com. Directory: /storage/tivoli-storage-management/maintenance/client/v5r1/Windows/WinNT/v51 6 Files: IP22660_ODBC.EXE ODBC driver install

Re: ODBC driver

2003-12-11 Thread Richard Sims
I want to install an ODBC driver so I can prepare some reports. I want to use excel for it (W2K). Is there anybody who can tell me where I can find this driver? The TSM Technical Guide redbook is your full guide to ODBC and Select processing. Appendix A of each edition carries the info

Re: Strange query output, using ODBC interface with M$ Access ...

2003-07-22 Thread Andrew Raibeck
: Dist Stor Manager [EMAIL PROTECTED] cc: From: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Subject:Re: Strange query output, using ODBC interface with M$ Access ... Hello Arnaud, I am unable to reproduce your problem. Attached is a .jpg file (tmodbc.jpg) showing my

Strange query output, using ODBC interface with M$ Access ...

2003-07-21 Thread PAC Brion Arnaud
Hi list, I'm currently using TSM ODBC (V 5.1.6.0) interface with an Access 2002 database (V 10.4302.4219 sp-2), and built a query looking like : SELECT SUMMARY.START_TIME, SUMMARY.END_TIME, SUMMARY.ACTIVITY, SUMMARY.ENTITY, SUMMARY.BYTES, DateDiff(w,[START_TIME],Now()) AS timediff FROM

ODBC driver for Microsoft : the driver was unable to allocate memory required to support execution

2003-02-24 Thread PAC Brion Arnaud
Hi list, I would like to use the ODBC driver delivered with TSM Windows client, in conjunction with an Access 2002 database, but when I try to issue following query : SELECT SUMMARY.START_TIME, SUMMARY.END_TIME, SUMMARY.ACTIVITY, SUMMARY.ENTITY, SUMMARY.BYTES, [end_time]-[start_time

Re: ODBC driver for Microsoft : the driver was unable to allocate memory required to support execution

2003-02-24 Thread Andrew Raibeck
Hello Arnaud, I am the developer who works on the ODBC driver, and I am unfamiliar with this particular problem. Can you please open up a problem with support on this, as it may require an APAR? You can give the support people my name, tell them I said this should go to Level 2, and that they can

Re: V4.2.3 ODBC supported on Win98?

2002-10-15 Thread Andrew Raibeck
PROTECTED] cc: Subject:V4.2.3 ODBC supported on Win98? The IP22569 ODBC driver readme states The TSM ODBC driver is supported on the following Microsoft operating systems: - Windows 98 - Windows Me - Windows NT 4.0 (SP 4 or higher

V4.2.3 ODBC supported on Win98?

2002-10-14 Thread Wayne T Smith
The IP22569 ODBC driver readme states The TSM ODBC driver is supported on the following Microsoft operating systems: - Windows 98 - Windows Me - Windows NT 4.0 (SP 4 or higher) - Windows 2000 yet when I try to install it on my Win98SE system, the installer

Re: ODBC access to TSM from VBScript

2002-09-09 Thread Ung Yi
DB Provider for ODBC Drivers. In the Provider string text box, enter the following: DSN=yourdsn;UID=youradmin;PWD=yourpassword Where yourdsn is the name of your TSM ODBC driver DSN, youradmin is your TSM Admin ID, and yourpassword is your TSM Admin password. For example, if my DSN is amr_odbc

Re: ODBC access to TSM from VBScript

2002-09-06 Thread Andrew Raibeck
) 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

Re: ODBC access to TSM from VBScript

2002-09-06 Thread Andrew Raibeck
the Security tree. 3) Right-click on Linked Servers and select New Linked Server 4) In the Linked server text box, put TSM. Select the Other data source radio button, then from the Provider name drop-down list, select Microsoft OLE DB Provider for ODBC Drivers. In the Provider string text box, enter

Re: ODBC access to TSM from VBScript

2002-09-05 Thread Andrew Raibeck
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

Re: ODBC access to TSM from VBScript

2002-09-05 Thread Ung Yi
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

ODBC access to TSM from VBScript

2002-09-04 Thread Peter Bjoern
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

Re: ODBC access to TSM from VBScript

2002-09-04 Thread Jin Bae Chi
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

Re: ODBC access to TSM from VBScript

2002-09-04 Thread Andrew Raibeck
As an addendum to my prior post on this thread, I would recommend you use the 5.1.1.1 or 4.2.2.0 ODBC driver. 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

AW: ODBC-connection to TSM

2002-08-28 Thread Kolling, Paul
Hi Andy, my ODBC driver version is 4.2.2 and meanwhile I tried it with the immemorial msqry32.exe and this works fine but it's not the preferred tool. So do you think I should downgrade the build of perl to 632? Best regards, Paul -Ursprüngliche Nachricht- Von: Andy Raibeck [mailto

ODBC-connection to TSM

2002-08-27 Thread Kolling, Paul
First of all thanks very much Andy for your response regarding ODBC-Connection with MySQL! I gave it up with MySQL. Tried Perl instead. With perl I can connect the TSM Server DB successfully but when I try the script of G. Rentschler then the part within the while($db-FetchRow()) loop

Re: TSM Access ODBC - TSMMANAGER

2002-08-22 Thread Lambelet,Rene,VEVEY,GL-CSC
:[EMAIL PROTECTED]] Sent: Wednesday,21. August 2002 19:44 To: [EMAIL PROTECTED] Subject: Re: TSM Access ODBC I have been trying out a demo of TSM Manager. It uses a collector agent to gather info from the activity log on a periodic basis, similar to ServerGraph but for Windows. From that data

TSM Access ODBC

2002-08-21 Thread Pétur Eyþórsson
Has anyone made a report, in MS Access ? Like a daly report on the last nights backup schedule? Kvedja/Regards Petur Eythorsson Taeknimadur/Technician IBM Certified Specialist - AIX Tivoli Storage Manager Certified Professional Microsoft Certified System Engineer [EMAIL PROTECTED] Nyherji Hf

Re: TSM Access ODBC

2002-08-21 Thread Greg Redell
I have been trying out a demo of TSM Manager. It uses a collector agent to gather info from the activity log on a periodic basis, similar to ServerGraph but for Windows. From that data it generates all sorts of reports. Is anyone else using this product? http://www.tsmmanager.com Greg Redell

odbc ?

2002-07-09 Thread Burak Demircan
Hi, What is the purpose of ODBC files like (IP22519_ODBC.EXE) in the same folder with clients like (IP22519..EXE)? Does not the client installation set include everything we need? (i mean why is it seperate?) Regards, Burak

Antwort: odbc ?

2002-07-09 Thread TSM
Merhaba Burak An ODBC driver allows you to use a relational database product such as SQL to query the database and display the results. Client installation does not set include everything we need. You have to install API and ODBC separately. selamlar...

Re: Antwort: odbc ?

2002-07-09 Thread Burak Demircan
                To:        [EMAIL PROTECTED]         cc:                 Subject:        Antwort: odbc ? Merhaba Burak An ODBC driver allows you to use a relational database product such as SQL to query the database and display the results

Re: Antwort: odbc ?

2002-07-09 Thread Andy Raibeck
The ODBC driver is a completely separate entity from the rest of the backup-archive client. It has no dependencies on the b-a client, and the b-a client has no dependencies on the ODBC driver. Therefore, in order to help reduce the already substantial size of the client package, the ODBC

Antwort: Re: Antwort: odbc ?

2002-07-09 Thread TSM
Merhaba ODBC driver is available only on Windows platforms, not on UNIX platforms. You have to install ODBC Driver seperately on windows. Typical setup on windows gives you the Backup-Archive-Client, the API files, and the web client Regards, Enver Genc

Re: Antwort: odbc ?

2002-07-09 Thread Kai Hintze
The API is an entry into the application (ie, write custom backup clients, or use TDP). ODBC is view of TSM database. - Kai. Live in such a way that you would not be ashamed to sell your parrot to the town gossip. -- Will Rogers -Original Message- From: Burak Demircan [mailto:[EMAIL

ODBC and MS SQL 2000

2002-07-02 Thread Leijnse, Finn F SITI-ITDSES31
Hi fellow TSM-ers, We are trying to make a nice missed and failed backup list available on our website and have encountered problems with running a SELECT statement of the events table from the MS SQL server to the TSM server. We have got it working in EXCEL. EXCEL will run the select on the TSM

Re: ODBC and MS SQL 2000

2002-07-02 Thread Joe Pendergast
-ITDSES31 [EMAIL PROTECTED] on 07/02/2002 02:24:42 AM Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc:(bcc: Joseph Pendergast/Corona/Watson) Subject: ODBC and MS SQL 2000 Hi fellow TSM-ers, We are trying to make a nice missed and failed backup list

Re: JDBC-ODBC Bridge and TSM ODBC driver

2002-05-11 Thread Andrew Raibeck
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. Date:Fri, 10 May 2002 13:33:20 -0700 From:Gerald Wichmann [EMAIL PROTECTED] Subject: Re: JDBC-ODBC Bridge and TSM ODBC driver With IBM's pro-java stance

JDBC-ODBC Bridge and TSM ODBC driver

2002-05-10 Thread Warren, Matthew James
He TSM'ers, Has anyone any success connecting to the TSM database using the JDBC-ODBC bridge and the TSM ODBC drivers? I have set bot system and user datasources using the TSM ODBC driver, and I am then attmepting to access this from Java using the JDBC-ODBC bridge. Currently I am using

Re: JDBC-ODBC Bridge and TSM ODBC driver

2002-05-10 Thread Warren, Matthew James
Hi Ppl, I'm getting somehwere, but the DB access through jdbc:odbc: - Access databse - TSMdatabase is incredibly slow. I have been told that it may help to use a native JDBC inteface; I don't think there is one for JDBC TSM, but maybe someone knows differently?

Re: JDBC-ODBC Bridge and TSM ODBC driver

2002-05-10 Thread Bill Boyer
Here's a post from Andy Raibeck about the TSM5.1 ODBC driver...http://msgs.adsm.org/cgi-bin/get/adsm0204/714.html. Bill Boyer DSS Inc. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Warren, Matthew James Sent: Friday, May 10, 2002 10:44 AM

Re: JDBC-ODBC Bridge and TSM ODBC driver

2002-05-10 Thread Andrew Raibeck
You need to use the JDBC -- ODBC bridge. There is no JDBC driver for TSM, nor do we plan on implementing one at this time. Which version of the ODBC driver are you using? The only ones that I know of that work (to at least some minimal degree) are 5.1.0.1 and now 4.2.2.0. Any future versions

Re: JDBC-ODBC Bridge and TSM ODBC driver

2002-05-10 Thread Gerald Wichmann
, May 10, 2002 12:40 PM To: [EMAIL PROTECTED] Subject: Re: JDBC-ODBC Bridge and TSM ODBC driver You need to use the JDBC -- ODBC bridge. There is no JDBC driver for TSM, nor do we plan on implementing one at this time. Which version of the ODBC driver are you using? The only ones that I know

Re: TSM/ODBC connection not working...

2002-04-18 Thread Seay, Paul
I will give this a try when I get brave enough to trust it will no kill my system. Thanks. -Original Message- From: Andrew Raibeck [mailto:[EMAIL PROTECTED]] Sent: Monday, April 15, 2002 10:36 AM To: [EMAIL PROTECTED] Subject: Re: TSM/ODBC connection not working... Hi Paul, Try

Re: TSM/ODBC connection not working...

2002-04-18 Thread Andrew Raibeck
Paul, is that just general precaution you exercise with any new software, or has the ODBC driver actually taken down your system before? I have never heard of such a problem (I've seen the application crash as you described earlier, but not an entire system; and I am not aware of any crash

Re: TSM/ODBC connection not working...

2002-04-18 Thread Seay, Paul
When it comes to Windows, you make sure you can recover before you install anything. -Original Message- From: Andrew Raibeck [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 11:26 PM To: [EMAIL PROTECTED] Subject: Re: TSM/ODBC connection not working... Paul, is that just

Re: TSM/ODBC connection not working...

2002-04-15 Thread Andrew Raibeck
Hi Paul, Try the 5.1.0.1 ODBC driver. From Excel XP, I am able to use the Import feature as well as the DB query feature (via MSQRY32) to get data into an Excel spreadsheet. By the way, even they are not supported, with this version of the driver, I have had success in connecting via: - DB2

Re: TSM/ODBC connection not working...

2002-04-08 Thread Andrew Raibeck
the database. I'm not sure why you had to log off/log on W2K to get the ODBC driver to work, but I won't argue with success! :-) Actually Andy, I cannot remember what I was trying to do with EXCEL XP. But, when I tried it again I get an application error trying to read location 0x0. A test

Re: TSM/ODBC connection not working...

2002-04-05 Thread Andrew Raibeck
What version of the ODBC driver are you using, which version of Excel, and what symptoms are you seeing? The latest ODBC driver should work okay with Excel 97 and 2000 (haven't tested with Office XP yet, but in theory, should work there, too). You can confirm the version by starting the ODBC Data

Re: TSM/ODBC connection not working...

2002-04-05 Thread Tab Trepagnier
Paul, For the last six months or so I've used Excel 97 with the ODBC link as a read-only GUI. Excel allows sorting and filtering - tools that are missing from the web client. To work with Excel you must have MS Query installed as part of MS Office. In my case, somewhere along the line

Re: TSM/ODBC connection not working...

2002-04-05 Thread Seay, Paul
PROTECTED]] Sent: Friday, April 05, 2002 10:06 AM To: [EMAIL PROTECTED] Subject: Re: TSM/ODBC connection not working... What version of the ODBC driver are you using, which version of Excel, and what symptoms are you seeing? The latest ODBC driver should work okay with Excel 97 and 2000 (haven't tested

Re: TSM/ODBC connection not working...

2002-04-04 Thread Tab Trepagnier
Jack, What client OS are you running? I just installed the TSM Windows client onto Windows XP, and my previously-working ODBC link no longer works. Upgrading the TSM client from 4.1.3 to the latest 4.2.x did not solve the problem. I'm only into this problem less than an hour, so I haven't had

TSM/ODBC connection not working...

2002-04-04 Thread Coats, Jack
I have ODBC installed on my client. Do I need to enable something on our TSM server to get it to work?

Re: TSM/ODBC connection not working...

2002-04-04 Thread Andrew Raibeck
No. I would help if you could provide more detailed information about your problem TSM/ODBC connection not working isn't much to go on For starters, the version of the ODBC driver you are using (should be 4.2.1), the application you are having difficulty with, and what the difficulty

Re: TSM/ODBC connection not working...

2002-04-04 Thread Coats, Jack
I am using Windows 98se as my desktop client machine -- this is my first time doing anything with ODBC, but I now others have been using it for quite a while here on this list. I had our local 'expert' who uses ODBC for other applications here come and check out my setup, and everything looks

  1   2   >