Thread: ...

...

From
"kapil c. tilwani"
Date:
Hi,

Could u just tell me if it is possible to have a Windows Client and the Server running on Linux and having Postgres and
thetwo communicate thru something like the ODBC. 

Does Postgres have anything for the advanced features like OleDB instead of ODBC.

Thirdly, are Postgres ODBC alrady installed alongwith the Postgres installation or any specific fine-tuning is
required.

if the answer to the first one is Yes, then the fourth question is - how do i do that?

Thanx in advance
Kapil

_____________________________________________________
Chat with your friends as soon as they come online. Get Rediff Bol at
http://bol.rediff.com





Re:

From
"Gregory Wood"
Date:
> Could u just tell me if it is possible to have a Windows Client and the
Server running on Linux and having Postgres and the two communicate thru
something like the ODBC.

Yes, although it's preferable to use a native library.

> Does Postgres have anything for the advanced features like OleDB instead
of ODBC.

No OleDB, but there is a JDBC driver.

> Thirdly, are Postgres ODBC alrady installed alongwith the Postgres
installation or any specific fine-tuning is required.

I'm not sure exactly what you're asking here, but the ODBC driver is a
separate download which requires a few configuration variables (like where
the server is) to find and work with your server. It's not plug and play
(but then again, neither is *any* ODBC driver).

> if the answer to the first one is Yes, then the fourth question is - how
do i do that?

You set up the server on your Linux box. Make sure you run it to accept TCP
connections (using the -i switch) and that your Windows box has permissions
to access the database (via the pg_hba.conf file). You might want to test it
with some Windows tool to make sure everything is working at this stage.
Then install the ODBC driver and point it to your PostgreSQL server. At that
point you should be able to access it like any other ODBC data source.

Greg


Re: Re:

From
"Thalis A. Kalfigopoulos"
Date:
On Mon, 14 May 2001, Gregory Wood wrote:

> > Could u just tell me if it is possible to have a Windows Client and the
> Server running on Linux and having Postgres and the two communicate thru
> something like the ODBC.
>
> Yes, although it's preferable to use a native library.

Is ODBC that bad? Which is better in terms of speed and robustness, ODBC or JDBC? I'd be interested in any comments as
I'mthinking of deploying Pg on my linux machine and have windows machines talk to it. 

TIA,
thalis