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:
The DSN is set up as a System DSN and it is able to connect (otherwise the commnad-line would have failed).[Microsoft][ODBC Driver Manager] Data source name not found and no def +ault driver specified (SQL-IM002)
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.
|
---|
Replies are listed 'Best First'. | |
---|---|
Re: Perl, DBI, IIS question
by roboticus (Chancellor) on Feb 05, 2013 at 22:41 UTC | |
by mje (Curate) on Feb 06, 2013 at 10:24 UTC | |
by zuma53 (Beadle) on Feb 05, 2013 at 23:01 UTC | |
by Anonymous Monk on Feb 06, 2013 at 04:31 UTC |
Back to
Seekers of Perl Wisdom