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 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 Warehouse Manager - JDBC-ODBC bridge - ActiveState Perl (version 5.005_03, build 522 + roth ODBC driver dated 12-21-1991 from www.roth.net) - Crystal Reports (known to work with earlier TSM ODBC driver versions) - Access XP (probably will be supported this year) - Excel XP (probably will be supported this year) - VBScript (known to work with earlier TSM ODBC driver versions) - Visual Basic 6.0 (using Microsoft ADO Data Control 6.0 SP4 and Microsoft DataGrid Control 6.0 SP5) 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] The only dumb question is the one that goes unasked. The command line is your friend. "Good enough" is the enemy of excellence. "Seay, Paul" <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 04/05/2002 08:53 Please respond to "ADSM: Dist Stor Manager" To: [EMAIL PROTECTED] cc: Subject: Re: TSM/ODBC connection not working... 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 connection works, but I cannot do the OK to open the database. -----Original Message----- From: Andrew Raibeck [mailto:[EMAIL 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 with Office XP yet, but in theory, should work there, too). You can confirm the version by starting the ODBC Data Source Administrator (odbcad32.exe), selecting the "Drivers" tab, then scrolling down and looking at the "TSM ODBC Driver" driver. You should then be able to see the driver's version number and build date. 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] The only dumb question is the one that goes unasked. The command line is your friend. "Good enough" is the enemy of excellence. "Seay, Paul" <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 04/04/2002 19:38 Please respond to "ADSM: Dist Stor Manager" To: [EMAIL PROTECTED] cc: Subject: Re: TSM/ODBC connection not working... When I installed it on W2K, I had to logoff and back on. Do not know why but that was the minimum restart to get it to work. I worked on it for hours. I have never been successful at using EXCEL but I have been very successful with ACCESS. What application are you trying to use to access the database. -----Original Message----- From: Coats, Jack [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 04, 2002 1:42 PM To: [EMAIL PROTECTED] Subject: Re: TSM/ODBC connection not working... 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 good to him. ... Bummer. > -----Original Message----- > From: Tab Trepagnier [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, April 04, 2002 12:26 PM > To: [EMAIL PROTECTED] > Subject: Re: TSM/ODBC connection not working... > > 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 a > chance to do much about it yet. I will probably call Tivoli if > nothing useful surfaces on the forum. > > Tab Trepagnier > TSM Administrator > Laitram Corporation > > > > > Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> > Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > cc: > Subject: TSM/ODBC connection not working... > > > I have ODBC installed on my client. Do I need to enable something on > our TSM server to get it to work?
