Re: DB2/400 ODBC access on NT Server

Brad --

Please see the following Support Line Technical Document:

http://as400service.rochester.ibm.com/s_dir/slkbase.NSF/ac9b6aea255b80ac062565c6007a96bb/22a1da7a1a0b8d64862565db00659465?OpenDocument

(This should all be one URL).

The title of this article is "Using ODBC as an NT System Service".  I
think this will answer your questions.

HTH
-- 
Gary L Peskin
The Firstech Corporation
+1.323.658.1146
http://www.simdate.com


Brad Hudson wrote:
> 
> Has anyone successfully used the Client Access ODBC driver on NT Server
> without a user logged in?
> 
> The situation:
> I have several reports designed in Crystal Reports 7, that access data from
> an AS/400 via the Client Access ODBC drivers.  The reports are on an NT
> Server 4 box running IIS4.  I have the Crystal Reports automation server
> (cpeaut32.dll) running in a package in Microsoft Transaction Server.  Under
> MTS, if I set the identity of the package to the "Interactive User" option,
> and I log in to the NT Server box, I can access my reports over the Web with
> no problems.
> 
> The problem:
> If I change the Identity for the Crystal package to any local or domain
> user, report access via the Web does not work.
> 
> More info:
> I have one report that does not use the Client Access ODBC drivers (it uses
> a SQL Server database on another NT box).  I can access this report over the
> web with the MTS Identity set to a user account on the NT Server box, with
> nobody logged in.  So it appears the problem is specific to the Client
> Access ODBC driver.
> 
> My setup:
> NT Server 4 SP4 128-bit
> IIS 4
> Microsoft Transaction Server
> Crystal Reports 7
> Client Access V3R1M3 - SF45363
> 
> Any help would be greatly appreciated.
> 
> Brad Hudson
> Medical Distribution, Inc.
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator: david@midrange.com
> +---
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---