Whoooops, I think I suffered a serious "brain-check"... I Didn't mean to
sound like I wasn't concerned with this issue! I meant to say I wasn't
concerned with the rest of the stuff that the diagnostics section asks
for. Sorry about that!

This should have read:

Please follow the instructions in the "Troubleshooting/Diagnostics"
section of the README.ODBC.TXT file to obtain traces of the problem, then
open a problem with IBM support and provide them with the trace
documentation. (I'm not so concerned with the other items that the README
asks for.) Crystal Reports is not formally supported (i.e. we don't test
it), so support is on a "best effort" basis. However, we are interested in
understanding problems like this with the ODBC driver and fixing them when
possible, so you shouldn't be flat-out refused (it even says so in the
README file!).

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: storman AT us.ibm DOT com

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.




Andrew Raibeck/Tucson/IBM@IBMUS
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
11/20/2001 11:46
Please respond to "ADSM: Dist Stor Manager"


        To:     ADSM-L AT VM.MARIST DOT EDU
        cc:
        Subject:        Re: ODBC and TSM timestamp data type (Crystal Reports)



Bill and Ken,

Please follow the instructions in the "Troubleshooting/Diagnostics"
section of the README.ODBC.TXT file to obtain traces of the problem, then
open a problem with IBM support and provide them with the trace
documentation (I'm not so concerned. Crystal Reports is not formally
supported (i.e. we don't test it), so support is on a "best effort" basis.
However, we are interested in understanding problems like this with the
ODBC driver and fixing them when possible, so you shouldn't be flat-out
refused (it even says so in the README file!).

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: storman AT us.ibm DOT com

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.




William Boyer <bill.boyer AT verizon DOT net>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
11/20/2001 11:16
Please respond to bill.boyer


        To:     ADSM-L AT VM.MARIST DOT EDU
        cc:
        Subject:        Re: ODBC and TSM timestamp data type (Crystal
Reports)



I have the same problems. If I use Access or Excel to get the data via the
same ODBC connection, the date/times are correct. Also, if you use a
utility
that Seagate distributes on the CD called SQLCON32.EXE with the same
select
statement I cut and pasted from my report, it displays correctly. I went
through this with the email tech support and finally had to call in and
open
a problem. They sent me the latest patches for CR8.5, but they didn't have
any effect. I just haven't had the time to call back in and break the new
to
them.

If you come up with a solution, PLEASE post it!!!!?????!?!

Bill Boyer
DSS, Inc.