Re: LISTEN / NOTIFY Feature - Mailing list pgsql-odbc

From Adnan DURSUN
Subject Re: LISTEN / NOTIFY Feature
Date
Msg-id BAY106-DAV7F34D2271EB92DA9CCFEAFA2C0@phx.gbl
Whole thread Raw
In response to Proposal for new pgsqlODBC feature - hiding tables inaccessible to the current user  (Mark Cave-Ayland <mark.cave-ayland@ilande.co.uk>)
List pgsql-odbc
----- Original Message -----
From: "Hiroshi Inoue" <inoue@tpf.co.jp>
To: "Adnan DURSUN" <a_dursun@hotmail.com>
Cc: <pgsql-odbc@postgresql.org>
Sent: Thursday, May 31, 2007 5:48 PM
Subject: Re: [ODBC] LISTEN / NOTIFY Feture


> Adnan DURSUN wrote:
>>
>>        Hi all,
>>
>>    I am using VB6 for frontend. Does pgsqlODBC support PostgreSQL LISTEN
>> / NOTIFY feature ?
>
> Currently not.
> How do you expect to handle LISTEN/NOTIFY using ODBC ?
>

        I dont know how. I think another problem to handle this is ADO !...
ADO doesnt have any event that will be raised when a notifications arrived
to client.
    I consider, maybe another way is to listen the port that ODBC
communicates with database on client machine. But, windows doesnt allow to
listen that port.
    It says "port is buys" when i try to listen that port.

        Maybe it is possibble to make a second conneciton to database beyond
ODBC in the same app using winsock. But, libpg.dll coulnd not be used with
inVB6.
    When i tried this i got "Bad DLL calling convention" message !

        So, i didnt find any way to do this !!

    Best regards

    Adnan DURSUN
    ASRIN Bilişim Ltd.


pgsql-odbc by date:

Previous
From: Hiroshi Inoue
Date:
Subject: Re: LISTEN / NOTIFY Feture
Next
From: Rainer Bauer
Date:
Subject: [psqlODBC 08.02.0401] Typo