mod_perl/4529: Running NT as a service, vs. as a conosle app keeps Perl DBI:ODBC from running correctly

[Ken Weide <we...@iname.com>]

>Number:         4529
>Category:       mod_perl
>Synopsis:       Running NT as a service, vs. as a conosle app keeps Perl DBI:ODBC from running correctly
>Confidential:   no
>Severity:       non-critical
>Priority:       medium
>Responsible:    apache
>State:          open
>Class:          sw-bug
>Submitter-Id:   apache
>Arrival-Date:   Fri Jun  4 15:40:01 PDT 1999
>Last-Modified:
>Originator:     weide@iname.com
>Organization:
apache
>Release:        1.3.6
>Environment:
NT 4.0 SP3
>Description:

I am not getting the output from my Perl 5.04.02 DBI:ODBC statements with NT as a service, vs. as a conosle app

>How-To-Repeat:
I have a Perl 5.04.02 DBI:ODBC script which will run under console App, but not under NT as a service.  Here are the critical elements:

#(After setting up ODBC Service:)
use CGI;
use DBI::W32ODBC;
$qs="SELECT DISTINCT PartType FROM PARTS WHERE Classification='$FORM{'class'}';";

$dbHandle = (DBI->connect('PartsDB-I', '', '', { RaiseError => 1 }));
print $dbHandle->errstr . "\n";
$sth = $dbHandle->prepare("$qs");
$rc = $sth->execute;
$row_ary = $sth->fetch;
$rc = $sth->execute;
@row_ary = $sth->fetchrow;
print "@row_ary[0]";
>Fix:
WORKAROUND - You can start Apache Console app, even if it is already running as a service.  Maybe it could be put into the NT startup scripts.

(Could this have anything to do with different privs as a service?)
>Audit-Trail:
>Unformatted:
[In order for any reply to be added to the PR database, you need]
[to include <ap...@Apache.Org> in the Cc line and make sure the]
[subject line starts with the report component and number, with ]
[or without any 'Re:' prefixes (such as "general/1098:" or      ]
["Re: general/1098:").  If the subject doesn't match this       ]
[pattern, your message will be misfiled and ignored.  The       ]
["apbugs" address is not added to the Cc line of messages from  ]
[the database automatically because of the potential for mail   ]
[loops.  If you do not include this Cc, your reply may be ig-   ]
[nored unless you are responding to an explicit request from a  ]
[developer.  Reply only with text; DO NOT SEND ATTACHMENTS!     ]