Re: Prepare statement failure

From: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
To: Graeme Leeming <gleeming(at)refractions(dot)net>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Prepare statement failure
Date: 2001-05-29 05:31:04
Message-ID: 3B133418.542AAE0B@tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Graeme Leeming wrote:
>
> Hi,
>
> ODBC seems to be having a problem with the following prepared statement:
> "SELECT t3.* FROM JURISDICTION2 t3 WHERE jurisdiction_name = ?"
>
> I am trying to use a software tool called Feature Manipulation Engine
> (FME) made by Safe Software to perform ODBC queries and table relates on
> a Postgres database. So far I have been partially successful in using
> FME to send and retrieve data to my Postgres V7.1.1 database using the
> 7.01.00.04 ODBC driver. One type of query fails every time I run it;
> FME appears to form the query as a prepared SELECT statement/SQL
> cursor. I would like to know if the ODBC driver is the problem (and if
> it can be fixed) or if FME is just not communicating properly with the
> driver. Snippets from the comm log are as follows:
>

Please check 'Parse Statments' driver option.
Or use the latest driver(7.01.0005).

regards,
Hiroshi Inoue

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Hiroshi Inoue 2001-05-29 05:39:22 Re: [ODBC] large objects, visual basic, ADO
Previous Message radius 2001-05-29 03:00:00 Re: access question