Thread: FW: how to use ODBC interface

FW: how to use ODBC interface

From
"se"
Date:

-----Original Message-----
From: pgsql-interfaces-owner@postgresql.org
[mailto:pgsql-interfaces-owner@postgresql.org] On Behalf Of Alexaki
Sofia
Sent: Wednesday, November 14, 2001 4:02 PM
To: pgsql-interfaces@postgresql.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@postgresql.org)



Re: FW: how to use ODBC interface

From
ashoksrautela@hotmail.com (Ashok Rautela)
Date:
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@openlinksw.co.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@delftinstruments.nl ("se") wrote in message news:<009501c16d26$6de98590$c91010ac@dfws00448.df.rwd.dinet>...
> -----Original Message-----
> From: pgsql-interfaces-owner@postgresql.org
> [mailto:pgsql-interfaces-owner@postgresql.org] On Behalf Of Alexaki
> Sofia
> Sent: Wednesday, November 14, 2001 4:02 PM
> To: pgsql-interfaces@postgresql.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@postgresql.org)
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
> 
> http://www.postgresql.org/users-lounge/docs/faq.html