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> >> > ------=_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 supercomputerDo 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 > />