Strange problems with DBD::Sybase and a simple query

From: Logan Capaldo (logancapaldo_at_gmail.com)
Date: 10/19/04


Date: Tue, 19 Oct 2004 09:38:33 -0400
To: dbi-users@perl.org

Hello, I am having some very irritating problems with DBI and
DBD::Sybase. I have tried Googling to no avail. What it breaks down to
is that a query issued with WinSQL for example, will work fine, but
the identical query issued through the DBI interface will give me an
error of the following form:

script.pl (Error): DBD::Sybase::st execute failed: Server message
number=208 severity=16 state=1 line=1 server=namechanged
text=dbo.table_name_changed not found. Specify owner.objectname or use
sp_help to check whether the object exists (sp_help may produce lots
of output).

Now I've tried not qualifying the owner with dbo. I've tried
qualifying it with dbo, neither seems to work, although both work when
I do them by hand. This is not a compilcated query. its a very simple
select. Does anyone have a solution to this problem? What am I doing
wrong?