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.
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
