Postgres Pro
Downloads
Home   >   mailing lists

Thread: Linking Postgresql OBDC via C

Linking Postgresql OBDC via C

From
Jim Jennis
Date:
Hi Postgres colleagues,

Sorry if this is a re-post, but it did not show up on the list (at least in
my mailbox) so I am posting it again.....

I am running a 3rd party development tool on Linux (Verastream from WRQ)
that has an open C API for multi-database connectivity. It transparently
supports many databases (Oracle, DB-2, etc) on Linux via a C interface to
the RDBMS and has an open C api. I'd like to link Verastream's middleware
engine to access Postgresql via ODBC using their C API.

Now my question...what Postgres libraries are required to access Postgres
via C programming using ODBC?

Thanks for any advice/help.

Regards,

Jim
 ,-,-.     ,-,-.     ,-,-.     ,-,-.     ,-
/ / \ \   / / \ \   / / \ \   / / \ \   / /
     \ \ / /   \ \ / /   \ \ / /   \ \ / /
      `-'-'     `-'-'     `-'-'     `-'-'
--------------------------------------------------------
FSC - Building Better Information Technology Solutions-
      From the Production Floor to the Customer's Door.
--------------------------------------------------------

Jim Jennis, Technical Director, Commercial Systems
Fuentez Systems Concepts, Inc.
1 Discovery Place, Suite 2
Martinsburg, WV. 25401 USA.

Phone: +001 (304) 263-0163 ext 235
FAX:   +001 (304) 263-0702

Email: jjennis@fuentez.com
       jhjennis@shentel.net
Web:   http://www.discovery.fuentez.com/
---------------------------------------------------

Re: Linking Postgresql OBDC via C

From
Jan Wieck
Date:
Jim Jennis wrote:
> Hi Postgres colleagues,
>
> Sorry if this is a re-post, but it did not show up on the list (at least in
> my mailbox) so I am posting it again.....
>
> I am running a 3rd party development tool on Linux (Verastream from WRQ)
> that has an open C API for multi-database connectivity. It transparently
> supports many databases (Oracle, DB-2, etc) on Linux via a C interface to
> the RDBMS and has an open C api. I'd like to link Verastream's middleware
> engine to access Postgresql via ODBC using their C API.
>
> Now my question...what Postgres libraries are required to access Postgres
> via C programming using ODBC?

    If  you  are  already  on the C level on Linux, why don't you
    want to use the native libpq interface? It'd  give  you  alot
    more performance and flexibility.


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #