From: Reinier Suurenbroek <reinier.suurenbroek@keygene.com>
To: pgsql-sql@postgresql.org <pgsql-sql@postgresql.org>
Subject: ODBC-link returns zero rows, allthough query should return 3 rows
Date: Fri, 28 May 2010 10:07:45 +0200
Message-ID: <E06D3E2DBB43CE43A4F267E4F5DC2DF669A51DCEFD@geryon.keygene.local> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: reinier.suurenbroek@keygene.com
Subject: Re: ODBC-link returns zero rows, allthough query should return 3 rows
In-Reply-To: <E06D3E2DBB43CE43A4F267E4F5DC2DF669A51DCEFD@geryon.keygene.local>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox