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

Easysoft ODBC-ODBC Bridge

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

Article :	00631
Last Reviewed :	19th July 2005
Revision :	1

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 which points to a database which 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 OOB as it points to our database which is read-only as far as external users are concerned. A typical failure when going to our demo datasource 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

Products
- Easysoft ODBC-ODBC Bridge
Databases
- Microsoft SQL Server
Languages
- Perl

*	Did this content help you? Yes No Maybe

*	Please select one option based on your first choice: I'm very satisfied I think it will help, but I haven't tried it yet It is helpful, but I need more information It is helpful, but hard to understand Seemed relevant in search results, but didn't help me The information is incorrect The page contains one or more broken links

	Suggest new content or let us know how we can improve this content:

	(* Required Fields)

Easysoft ODBC-ODBC Bridge

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

Applies To

Knowledge Base Feedback