• Please help support our sponsors by considering their products and services.
    Our sponsors enable us to serve you with this high-speed Internet connection and fast webservers you are currently using at ADSM.ORG.
    They support this free flow of information and knowledge exchange service at no cost to you.

    Please welcome our latest sponsor Tectrade . We can show our appreciation by learning more about Tectrade Solutions
  • Community Tip: Please Give Thanks to Those Sharing Their Knowledge.

    If you receive helpful answer on this forum, please show thanks to the poster by clicking "LIKE" link for the answer that you found helpful.

  • Community Tip: Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING)

    Click the link above to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This notice will disappear after you have made at least 3 posts.

TSM ODBC driver and ASP...

sherrma

ADSM.ORG Member
#2
The package you find on the web will just uncompress in the define directory.

It will not install it.

So uncompress it in your C:\temp and run it from there.

Then you will have it in your ODBC driver

After that you just have to define your servers one at a time.



Good luck
 

latas

ADSM.ORG Member
#3
I know, and it works fine from other applications.

I would like to see a sample ASP code from someone, can't get the ASP engine to contact the server.



BR Lasse
 

mlafage

ADSM.ORG Member
#4
I don't know ASP, so please forgive me if I did not understand your problem.



We did a reporting tool for TSM on ODBC in VC++.

And we were very disappointed to discover

that the TSM ODBC source does not work with ADO.



So, I was wondering if you were trying to use ADO instead of ODBC

in your ASP app.
 

latas

ADSM.ORG Member
#5
I have found out how to do it with ASP. I am using an ADODB connection to the driver, this works fine for me. It is just putting a lot of crap in the TSM actlog. I can't figure out how to get rid of these lines....
 

mlafage

ADSM.ORG Member
#6
You managed to get an ADODB connection with TSM ODBC ?



congrats !



By the way, how did you achieve this ?

( I've been using ODBC source 3.07.02.00 at least on TSM 3.7, as well as a few tests with TSM 4.xx, with no success in ADO.)



Same problem also for me with the TSM actlog.

(And indeed a big problem, because a frequent polling to detect changes on the status of ~100 tapes really makes the actlog "explode".)
 
#8
Hi,



I have setup an NT Server on which I've got IIS (for ASP) and in the background SQL Server 2K running to provide detailed information regarding the status of backups, tapes, drmedia, billing, etc. What the SQL-part does is interrogate our 12 TSM-servers spread over Europe on a regular bases. It stores the data in it's database and IIS interrogates the SQL database when the end-user (both TSM-admins and TSM-clients) requires the information.



In this way you don't blow up your ACTLog more then necessary and you've got all the information on 12 TSM Servers in 1 place.



It was a lot of work to set it up but It works very stable. I even get to compare the different TSM servers performance on a day to day bases and keep the data as long as necessary. My database is currently (only) 85 Mb and is pretty stable with all the data I need for reporting of the past 3 months.



:grin:
 

latas

ADSM.ORG Member
#9
This seams to be a good idea.

I don't know mutch about sql servers, i fact i know anything about them....

can you point out some clues for me, then it might not be nessesary to read 20 manuals, 10 redbooks and so on.... maybe 1 or 2 books could do the job. :cool:
 

Advertise at ADSM.ORG

If you are reading this, so are your potential customer. Advertise at ADSM.ORG right now.

UpCloud high performance VPS at $5/month

Get started with $25 in credits on Cloud Servers. You must use link below to receive the credit. Use the promo to get upto 5 month of FREE Linux VPS.

The Spectrum Protect TLA (Three-Letter Acronym): ISP or something else?

  • Every product needs a TLA, Let's call it ISP (IBM Spectrum Protect).

    Votes: 15 18.1%
  • Keep using TSM for Spectrum Protect.

    Votes: 52 62.7%
  • Let's be formal and just say Spectrum Protect

    Votes: 9 10.8%
  • Other (please comement)

    Votes: 7 8.4%

Forum statistics

Threads
31,403
Messages
133,763
Members
21,511
Latest member
rcoelho
Top