Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-odbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group