Prepared statement not a cursor specification

------_=_NextPart_001_01C663E9.775BF8C4
Content-Type: text/plain;
charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable

Hi All,
=20
Has anyone seen this error before and if so would you know the solution
to fixing it?
=20
DBD::ODBC::st execute failed: [unixODBC]Prepared statement not a cursor
specification (SQL-07005)(DBD: describe/SQLDescribeCol err=3D-1)
=20
I am trying to loop through the returned values of a select statement
and doing the updates accordingly.
=20
Thanks.
=20
Peter


This E-mail message is for the sole use of the intended recipient(s) and =
may contain confidential and privileged information. Any unauthorized =
review, use, disclosure or distribution is prohibited. If you are not =
the intended recipient, please contact the sender by reply E-mail, and =
destroy all copies of the original message.

------_=_NextPart_001_01C663E9.775BF8C4--

RE: [dbi] Prepared statement not a cursor specification

Peter,

Sorry for seeing this late. It would appear SQLDescribeCol
(an ODBC API) failed when calling your driver. Your ODBC
driver needs to support SQLDescribeCol at least. It is almost
impossible to say why this failed without knowing the SQL you
were executing and the ODBC you are using.

However, 07005 says:

The statement associated with the StatementHandle did not return a result set.
There were no columns to describe.

so that would suggest you SQL is no a result-set generating statement
i.e. not a select statement.

Martin
--
Martin J. Evans
Easysoft Ltd, UK
http://www.easysoft.com


On 19-Apr-2006 Loo, Peter # PHX wrote:
> Hi All,
>
> Has anyone seen this error before and if so would you know the solution
> to fixing it?
>
> DBD::ODBC::st execute failed: [unixODBC]Prepared statement not a cursor
> specification (SQL-07005)(DBD: describe/SQLDescribeCol err=-1)
>
> I am trying to loop through the returned values of a select statement
> and doing the updates accordingly.
>
> Thanks.
>
> Peter