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