in reply to fail: Linux Perl-DBI to SQL Server
It seems that you have two problems here, the program can not find neither the database nor the driver...
1 - I could be wrong (I'm not familiar with the MicrosoftSQL DB) but I think that DBI use dbname=$mydatabase instead to database=$mydatabase, please check this.
2 - I find also strange the structure of the driver part. What is the purpose of the "{}"?. (UPDATED, you want to say: q{}?)
Check the name of your driver with something like:
perl -MDBI -e 'my @drivers = DBI->available_drivers; print join(", ", @drivers), "\n";'(UPDATED: mmmh, the name is "Microsoft ODBC Driver 11 for SQL Server" or "ODBC Driver 11 for SQL Server"?)
In Section
Seekers of Perl Wisdom