Re: How would you catch this error?

Why are you using an external program? Perl's DBI module has an ODBC driver, which should do what you want. You mentioned Excel, so I should also point you to Spreadsheet::WriteExcel, Spreadsheet::ParseExcel, and DBD::Excel.

----
I wanted to explore how Perl's closures can be manipulated, and ended up creating an object system by accident.
-- Schemer

Note: All code is untested, unless otherwise stated

Comment on Re: How would you catch this error?

Replies are listed 'Best First'.
Re: Re: How would you catch this error? by LanceDeeply (Chaplain) on May 09, 2003 at 14:57 UTC
Usually, I do use DBI. I use this for when I have to run sql scripts that I have no control over. The scripts can get a little involved, for instance creating temp tables to build the result sets and declaring variables. Basically- stuff that should be done in a stored proc, but isn't.	[reply]