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)
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")
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.