Re: FW: how to use ODBC interface

-----Original Message-----
From: pgsql-interfaces-owner(at)postgresql(dot)org
[mailto:pgsql-interfaces-owner(at)postgresql(dot)org] On Behalf Of Alexaki
Sofia
Sent: Wednesday, November 14, 2001 4:02 PM
To: pgsql-interfaces(at)postgresql(dot)org
Subject: [INTERFACES] how to use ODBC interface

Hello,

I have installed Postgresql 7.1.3 on solaris 2.8.
I want to use ODBC interface of postgresql for applications that
will run mainly on SOLARIS.

1) Is there any example using ODBC interface e.g., using ODBC from a C/C++
application?

2)Is it more stable to use psqlODBC or OpenLink ODBC postgresql odbc
driver?
What are the advantage or disadvantages between these two drivers?

Thanks in advance,
Sofia Alexaki

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

Hi,

Firstly I am not sure if you have to components for the ODBC driver
for PostgresSQL on Solaris. If you don't please sent me an e-mail (
arautela(at)openlinksw(dot)co(dot)uk ) so that I can send the components to you.
What I understand from your statement is that you want to use the ODBC
interface of PostgresSQL to connect to applications on Solaris (is
this a seperate Solaris machine or the same one where PostgresSQL is
installed??) Please correct me in the e-mail if I am wrong.

To answer your questions:

1) There is a C++ Demo 32bit program that you can use to connect to
the PostgresSQL database and pull information from but this is only
part of Windows installation.

2) I am not really sure about this but what I would say is that the
OpenLink ODBC driver for PostgresSQL is a proven and industry standard
software. I don't want to comment on psqlODBC because that really
depends on what different developers are trying to achieve.

Hope this helps,

Regards,

Ashok Rautela

se(at)delftinstruments(dot)nl ("se") wrote in message news:<009501c16d26$6de98590$c91010ac(at)dfws00448(dot)df(dot)rwd(dot)dinet>...
> -----Original Message-----
> From: pgsql-interfaces-owner(at)postgresql(dot)org
> [mailto:pgsql-interfaces-owner(at)postgresql(dot)org] On Behalf Of Alexaki
> Sofia
> Sent: Wednesday, November 14, 2001 4:02 PM
> To: pgsql-interfaces(at)postgresql(dot)org
> Subject: [INTERFACES] how to use ODBC interface
>
>
>
> Hello,
>
> I have installed Postgresql 7.1.3 on solaris 2.8.
> I want to use ODBC interface of postgresql for applications that
> will run mainly on SOLARIS.
>
> 1) Is there any example using ODBC interface e.g., using ODBC from a C/C++
> application?
>
> 2)Is it more stable to use psqlODBC or OpenLink ODBC postgresql odbc
> driver?
> What are the advantage or disadvantages between these two drivers?
>
> Thanks in advance,
> Sofia Alexaki
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html