Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id A1F506340DC for ; Fri, 28 May 2010 05:08:14 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 84445-02 for ; Fri, 28 May 2010 08:08:07 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from smtp.bit.nl (smtp.lb.network.bit.nl [213.136.12.226]) by mail.postgresql.org (Postfix) with ESMTP id C46DC632538 for ; Fri, 28 May 2010 05:08:06 -0300 (ADT) Received: from [213.136.28.34] (port=12024 helo=geryon.keygene.local) by smtp4.smtp.dmz.bit.nl with esmtps (TLS-1.0:RSA_AES_128_CBC_SHA1:16) (Exim 4.69) (envelope-from ) id 1OHubs-0000By-ME for pgsql-sql@postgresql.org; Fri, 28 May 2010 10:08:04 +0200 Received: from geryon.keygene.local ([fe80::5c39:e4e0:fadd:4d0c]) by geryon.keygene.local ([fe80::5c39:e4e0:fadd:4d0c%12]) with mapi; Fri, 28 May 2010 10:07:46 +0200 From: Reinier Suurenbroek To: "pgsql-sql@postgresql.org" Content-Class: urn:content-classes:message Date: Fri, 28 May 2010 10:07:45 +0200 Subject: ODBC-link returns zero rows, allthough query should return 3 rows Thread-Topic: ODBC-link returns zero rows, allthough query should return 3 rows Thread-Index: Acr+PNogk6+Zjo5pSs+IEtEiFYrDng== Message-ID: Accept-Language: nl-NL Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: acceptlanguage: nl-NL Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.1 tagged_above=-5 required=5 tests=BAYES_50=0.8, RCVD_IN_DNSWL_LOW=-0.7 X-Spam-Level: X-Archive-Number: 201006/7 X-Sequence-Number: 34198 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 unixODB= C is successful: =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D $ 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 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D Now trying the same, using ODBClink result in zero rows: =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D $ psql oratest psql (8.4.3) Type "help" for help. oratest=3D# select odbclink.connect('ONT_KIS', 'sbm_beheer', 'bioinf'); = connect --------- 1 (1 row) oratest=3D# select * FROM odbclink.query(1, 'SELECT id, t, d FROM mytable W= HERE id=3D2') as result(id float, t text, d float); id | t | d ----+---+--- (0 rows) =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D Unfortunately the developers of the ODBClink do not answer my mails, so I a= sk you if someone out there has any clue. It will also be appreciated if an= yone 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 p= rivileged and/or confidential and is intended to be received only by person= s 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 t= he sender is strictly prohibited. Should you receive this message unintenti= onally please notify the sender immediately, and delete it together with al= l attachments, if any. Thank you. The transmission of messages and/or information via the Internet is not sec= ured and may be intercepted by third parties. KeyGene assumes no liability = for any damage caused by any unintentional disclosure and/or use of the con= tent of this message and attachments if any.