RE: Iseries / IIS / Service Job / ODBC

Tim,

Who is the service running as? SYSTEM? Try (and this is a guess here)
changing the service to run as a user, log on to the machine as that user to
the HKCU registry hive gets created for that user, setup the DNS and use it
once interactively as that user and then try it as a service running as that
user. I'll guess that CAE's drivers requires the HKCU registry hive to run.

-Walden


------------
Walden H Leverich III
President
Tech Software
(516) 627-3800 x11
(208) 692-3308 eFax
WaldenL@TechSoftInc.com
http://www.TechSoftInc.com

Quiquid latine dictum sit altum viditur.
(Whatever is said in Latin seems profound.)



-----Original Message-----
From: Hatzenbeler, Tim [mailto:thatzenbeler@clinitech.net]
Sent: Thursday, May 30, 2002 19:16
To: 'midrange-l@midrange.com'
Subject: RE: Iseries / IIS / Service Job / ODBC


This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--
[ Picked text/plain from multipart/alternative ]
I think your right... I was reading the crystal support messages, and they
said the express version is too stripped down to handle ODBC requests as
services, and you have to go the route of db2 connect... So i followed the
links for db2 connect, and could not see a price, so I called IBM, and they
didn't have it in their computer, so I was transfered to technial services,
and the call was dropped... Oh well...


> -----Original Message-----
> From: Kirk Goins [SMTP:kirkg@pacinfosys.com]
> Sent: Thursday, May 30, 2002 2:22 PM
> To:   midrange-l@midrange.com
> Subject:      RE: Iseries / IIS / Service Job / ODBC
>
> I have a client with some Crystal Report to/from AS/400 issues. He's
> been told by IBM DB2 Connect will fix his issues. You might want to
> look into that Product.
>
> __________________________________________________
> Kirk Goins
> IBM Certified iSeries Technical Solutions Expert
> Pacific Information Systems - An IBM Premier Business Partner
> 503-674-2985           kirkg@pacinfosys.com
>
>
> -----Original Message-----
> From: Hatzenbeler, Tim [mailto:thatzenbeler@clinitech.net]
> Sent: Thursday, May 30, 2002 2:02 PM
> To: 'midrange-l@midrange.com'
> Subject: Iseries / IIS / Service Job / ODBC
>
>
> This message is in MIME format. Since your mail reader does not
> understand this format, some or all of this message may not be
> legible.
> --
> [ Picked text/plain from multipart/alternative ]
> I need some help, and i'm sure this scenario isn't stumbled across every
> day...
>
> I have an NT sever running IIS with and ODBC connection to the AS/400
> that generates Crystal Reports (via a service job)...  And this
> worked, when I had client access installed and I used an IBM tool
> called CWBCFG.
>
> But today, we created a similar configuration using Windows 2000
> server, but we installed Client Access Express...  According to the
> CWBCFG tool, it's not supported for Express.
>
> But:
> The ODBC connection happens in a server job, and without this tool, a
> connection can't be made to the 400.  Does anybody have a solution for
> this little problem?
>
> Thanks, tim
> This e-mail message, including any attachments, is for the sole use of
> the intended recipient(s) and may contain confidential or privileged
> information.  Any unauthorized review; use, disclosure or distribution
> is prohibited.  If you are not the intended recipient, please contact
> the sender by reply e-mail and destroy the message.
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list To post a message email: MIDRANGE-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
> or email: MIDRANGE-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list To post a message email: MIDRANGE-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
> or email: MIDRANGE-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
This e-mail message, including any attachments, is for the sole use of the
intended recipient(s) and may contain confidential or privileged
information.  Any unauthorized review; use, disclosure or distribution is
prohibited.  If you are not the intended recipient, please contact the
sender by reply e-mail and destroy the message.
_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@midrange.com To subscribe, unsubscribe,
or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.