Perl, DBI, IIS question

zuma53 has asked for the wisdom of the Perl Monks concerning the following question:

Hi--

I have a simple Perl script that logs in to a MSSQL database and creates an HTML page from a simple query.

When I run the script from the command line, the resulting output is OK. I am able to have the webserver open a static file with the results.

However, when I have the webserver run the script, I get the following error:

[Microsoft][ODBC Driver Manager] Data source name not found and no def
+ault driver specified (SQL-IM002)
[download]

The DSN is set up as a System DSN and it is able to connect (otherwise the commnad-line would have failed).

my $dbh = DBI->connect("dbi:ODBC:DSN=XXX-ZZZZREP02")
[download]

Might this be a permissions issue? IIS is running under the local system acount and I am connecting to the DB via WinAuth.

Thanks in advance.

Back to Seekers of Perl Wisdom