VictorMV has asked for the wisdom of the Perl Monks concerning the following question:
When using DBI (ver 1.46) to execute a stored procedure on SQLServer via DBD-ODBC (ver 1.13) I get the following error:
Microsoft ODBC SQL Server Driver Function sequence error (SQL-HY010)(DBD: st_fetch/SQLFetch err=-1)
When I explicitly run the stored procedure from within an SQL Client (DBArtisan) I get a more descriptive error message and I would like to get that same message passed to perl via DBI. When I try to access errstr to get the error text, I get the above mentioned 'Function sequence error' - is there a workaround, or some other way to get the error? Is this a problem with DBI ver 1.46?
Thanks a lot!