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

Easysoft Data Access

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

Article:
00631
Last Reviewed:
2nd January 2024
Revision:
8

The make test for Perl DBD::ODBC attempts to create tables in the database, populate them and read the data back. If you use a DSN that points to a database that is read-only (or for which you do not have permission to create tables) the tests will fail. This will happen if you use the demo DSN which is supplied with Easysoft ODBC-ODBC Bridge as it points to an Easysoft-hosted database that is read-only for external users.

A typical failure when going to our demo data source looks like:

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)
Applies To

Knowledge Base Feedback

* Did this content help you?
* Please select one option based on your first choice:

(* Required Fields)