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
.

Relevant Pages

  • Re: Sybase Source. What "data flow source" to use?
    ... "Allan Mitchell" wrote: ... when I right-click over a SQL 2005 database and select Import ... datasources defined in ODBC Datasources on my computer, ...
    (microsoft.public.sqlserver.dts)
  • Re: SQL using C
    ... I am almost a new C programmer and now I need to use SQL within my C ... The people who are telling you to use a C API are out of their mind. ... is not less complicated than ODBC and ties the user to a single ...
    (comp.lang.c)
  • Re: Quick primer on Unidata-to-SQL Server Connectivity?
    ... but creating a view and then running an SQL query with more than one ... but somewhat extensive experience with UniData SQL. ... until some things improved in UniData ODBC. ...
    (comp.databases.pick)
  • Re: Sybase Source. What "data flow source" to use?
    ... when I right-click over a SQL 2005 ... database and select Import Data, the list of providers does not include ... either A) the list of datasources defined in ODBC Datasources on my computer, ... I've been so excited about SSIS and telling my co-workers how ...
    (microsoft.public.sqlserver.dts)
  • Re: Access SQL DAYOFWEEK() problem
    ... not a SQL function ... "Duane Hookom" wrote: ... >> Could anyone tell me what is the correct syntax for the scalar functions? ... >> ODBC Scalar Functions ...
    (microsoft.public.access.modulesdaovba)