Download ODBC Drivers for Oracle, SQL Server, Salesforce, MongoDB, Access, Derby, InterBase & DB2.

Why does make test for Perl DBD::ODBC fail with "invalid object name" errors?

The Perl DBD::ODBC test suite attempts to create tables, insert data, and fetch data back. If your database is read-only or you don't have permission to create tables, the tests fail. For example:

t/02simple..........DBD::ODBC::db do failed:
[unixODBC][Microsoft][ODBC SQL Server Driver][SQL Server]
CREATE TABLE permission denied, database 'pubs', owner 'dbo'.
(SQL-37000)(DBD: st_execute/SQLExecute err=-1) at t/ODBCTEST.pm line 80.
DBD::ODBC::db prepare failed:
[unixODBC][Microsoft][ODBC SQL Server Driver][SQL Server]
Invalid object name 'PERL_DBD_TEST'. (SQL-S0002)