Strange problems with DBD::Sybase and a simple query
From: Logan Capaldo (logancapaldo_at_gmail.com)
Date: 10/19/04
- Next message: Ron Reidy: "RE: Slow connection to Oracle 9i"
- Previous message: Dan: "Can I use the perl DBI to connect to SQL Server???"
- Next in thread: Michael Peppler: "Re: Strange problems with DBD::Sybase and a simple query"
- Reply: Michael Peppler: "Re: Strange problems with DBD::Sybase and a simple query"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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?
- Next message: Ron Reidy: "RE: Slow connection to Oracle 9i"
- Previous message: Dan: "Can I use the perl DBI to connect to SQL Server???"
- Next in thread: Michael Peppler: "Re: Strange problems with DBD::Sybase and a simple query"
- Reply: Michael Peppler: "Re: Strange problems with DBD::Sybase and a simple query"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]