ODBC-link returns zero rows, allthough query should return 3 rows

From: Reinier Suurenbroek <reinier(dot)suurenbroek(at)keygene(dot)com>
To: "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Subject: ODBC-link returns zero rows, allthough query should return 3 rows
Date: 2010-05-28 08:07:45
Message-ID: E06D3E2DBB43CE43A4F267E4F5DC2DF669A51DCEFD@geryon.keygene.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,

We are trying to make use of module ODBC-link. We follow the
instructions as read in README.TXT, including the given examples.
Connecting to an external Oracle database and running a query using unixODBC is successful:
===========================================================================================
$ isql -v ONT_KIS sbm_beheer bioinf
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
SQL> select * from mytable;
+------------------+---------------------------------------------------+------------------+
| ID | T | D |
+------------------+---------------------------------------------------+------------------+
| 1 | FIRST TEXT | 1.3 |
| 2 | SECOND TEXT | 4 |
| 3 | THIRD TEXT | 4 |
+------------------+---------------------------------------------------+------------------+
SQLRowCount returns -1
3 rows fetched
===========================================================================================

Now trying the same, using ODBClink result in zero rows:
===========================================================================================
$ psql oratest psql (8.4.3)
Type "help" for help.

oratest=# select odbclink.connect('ONT_KIS', 'sbm_beheer', 'bioinf'); connect
---------
1
(1 row)

oratest=# select * FROM odbclink.query(1, 'SELECT id, t, d FROM mytable WHERE id=2') as result(id float, t text, d float);
id | t | d
----+---+---
(0 rows)
===========================================================================================

Unfortunately the developers of the ODBClink do not answer my mails, so I ask you if someone out there has any clue. It will also be appreciated if anyone can point me to a more appropriate mailing list.

We're running PostgreSQL 8.4.3, ODBC-link 1.0.

TIA,

Reinier Suurenbroek

Keygene N.V.
P.O. Box 216
6700 AE Wageningen
The Netherlands
Tel. (+31) 317 46 68 66
Fax. (+31) 317 42 49 39
Web: http://www.keygene.com/

The information contained in this message, and attachments if any, may be privileged and/or confidential and is intended to be received only by persons entitled to receive such information. Use of any part of this message and/or its attachments if any, in any other way than as explicitly stated by the sender is strictly prohibited. Should you receive this message unintentionally please notify the sender immediately, and delete it together with all attachments, if any. Thank you.
The transmission of messages and/or information via the Internet is not secured and may be intercepted by third parties. KeyGene assumes no liability for any damage caused by any unintentional disclosure and/or use of the content of this message and attachments if any.

Browse pgsql-sql by date

  From Date Subject
Next Message Jasen Betts 2010-05-28 10:31:03 Re: cast record type to array?
Previous Message Harrie Rodenbach 2010-05-28 07:32:40 Re: Do not understand "SETOF RECORD" - therefore can not use ODBC-link