setting up ODBC

Поиск
Список
Период
Сортировка
Искать

setting up ODBC

От:
Jodi Kanter <jkanter@virginia.edu>
Дата:
I am trying to connect to postgres via ODBC so that I can use Visio. I have installed psqlODBC on my windows 2000 workstation and am trying to get to our postgres database located on a Linux machine.
Do I need to enable ODBC on the Linux side? or just configure the driver on my workstation?
I have read something about postgres automatically rejecting IP connections.
Can anyone advise?
Thanks
Jodi

_______________________________
Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
(804) 924-2846
jkanter@virginia.edu

Re: setting up ODBC

От:
Derek Neighbors <derek@gnue.org>
Дата:
> I am trying to connect to postgres via ODBC so that I can use Visio. I have installed psqlODBC on my windows 2000 workstation and am trying to get to our postgres database located on a Linux machine.
> Do I need to enable ODBC on the Linux side? or just configure the driver on my workstation?

You need to configure ODBC only on the windows machine.

> I have read something about postgres automatically rejecting IP connections.
> Can anyone advise? 

You will need to make sure that your postgres server is setup to accept 
TCP/IP connections.

-Derek

Re: setting up ODBC

От:
"Nick Fankhauser" <nickf@ontko.com>
Дата:
Jodi-

Take a look at the section titled "Configuring Postgresql for JDBC" on this
page:

http://www.fankhausers.com/postgresql/jdbc/#driver_install

Although the instructions are intended for JDBC, I believe the IP connection
part is the same.

-Nick


-----Original Message-----
From: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org]On Behalf Of Jodi Kanter
Sent: Tuesday, December 04, 2001 11:58 AM
To: Postgres Admin List
Subject: [ADMIN] setting up ODBC


I am trying to connect to postgres via ODBC so that I can use Visio. I have
installed psqlODBC on my windows 2000 workstation and am trying to get to
our postgres database located on a Linux machine.
Do I need to enable ODBC on the Linux side? or just configure the driver on
my workstation?
I have read something about postgres automatically rejecting IP connections.
Can anyone advise?
Thanks
Jodi
_______________________________
Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
(804) 924-2846
jkanter@virginia.edu

Re: setting up ODBC

От:
"A. L. Meyers" <nospam.look@replyto.because.this.is.invalid>
Дата:
jkanter@virginia.edu (Jodi Kanter) writes:

> This is a multi-part message in MIME format.
> 
> ------=_NextPart_000_00D1_01C17CBA.DEDC5EF0
> Content-Type: text/plain; charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
> 
> I am trying to connect to postgres via ODBC so that I can use Visio. I have=
>  installed psqlODBC on my windows 2000 workstation and am trying to get to =
> our postgres database located on a Linux machine.
> Do I need to enable ODBC on the Linux side? or just configure the driver on=
>  my workstation?
> I have read something about postgres automatically rejecting IP connections.
> Can anyone advise?=20
> Thanks=20
> Jodi=20
> _______________________________
> Jodi L Kanter
> BioInformatics Database Administrator
> University of Virginia
> (804) 924-2846
> jkanter@virginia.edu
> 
> ------=_NextPart_000_00D1_01C17CBA.DEDC5EF0
> Content-Type: text/html; charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
> 
> 
> 
> 
> 
> 
> 
> 
> 
I am trying to connect to postgres via ODB= > C so that=20 > I can use Visio. I have installed psqlODBC on my windows 2000 workstation a= > nd am=20 > trying to get to our postgres database located on a Linux machine. DIV> >
Do I need to enable ODBC on the Linux side= > ? or just=20 > configure the driver on my workstation?
>
I have read something about postgres autom= > atically=20 > rejecting IP connections.
>
Can anyone advise?
>
Thanks
>
Jodi
>
>
>

style=3D"FONT-FAMILY: Arial; FONT-SIZE: 9pt; mso-bidi-font-size: 12.0pt; ms= > o-fareast-font-family: 'MS Mincho'">_______________________________
Jodi= > =20 > L Kanter
BioInformatics Database Administrator
University of=20 > Virginia
(804) 924-2846
href=3D"mailto:jkanter@virginia.edu">jkanter@virginia.edu style=3D"mso-special-character: line-break"> style=3D"mso-special-character: line-break"> =3D=20 > "urn:schemas-microsoft-com:office:office"=20 > />

> > ------=_NextPart_000_00D1_01C17CBA.DEDC5EF0-- Jodi, you may not have been aware of this to date, but newsgroups much appreciate receiving messages in plain text format. Regards, Lucien -- If you receive this by error, please delete it and inform the sender. http://www.consult-meyers.com recommends e-mail encryption using pgp. To Big Brother Echelon from "spook": security jihad plutonium CIA Albanian Rule Psix supercomputer
FAQ