Обсуждение: 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
> I am trying to connect to postgres via ODBC so that I can use Visio. I have installed psqlODBC on my windows 2000 workstationand 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
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
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 > > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> > <HTML><HEAD> > <META content=3D"text/html; charset=3Diso-8859-1" http-equiv=3DContent-Type> > <META content=3D"MSHTML 5.00.3315.2870" name=3DGENERATOR> > <STYLE></STYLE> > </HEAD> > <BODY bgColor=3D#ffffdd> > <DIV><FONT face=3DArial size=3D2>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.</FONT></= > DIV> > <DIV><FONT face=3DArial size=3D2>Do I need to enable ODBC on the Linux side= > ? or just=20 > configure the driver on my workstation?</FONT></DIV> > <DIV><FONT face=3DArial size=3D2>I have read something about postgres autom= > atically=20 > rejecting IP connections.</FONT></DIV> > <DIV><FONT face=3DArial size=3D2>Can anyone advise? </FONT></DIV> > <DIV><FONT face=3DArial size=3D2>Thanks </FONT></DIV> > <DIV><FONT face=3DArial size=3D2>Jodi </FONT></DIV> > <DIV> > <DIV class=3DSection1> > <P class=3DMsoNormal><I><SPAN=20 > style=3D"FONT-FAMILY: Arial; FONT-SIZE: 9pt; mso-bidi-font-size: 12.0pt; ms= > o-fareast-font-family: 'MS Mincho'">_______________________________<BR>Jodi= > =20 > L Kanter<BR>BioInformatics Database Administrator<BR>University of=20 > Virginia<BR>(804) 924-2846<BR><A=20 > href=3D"mailto:jkanter@virginia.edu">jkanter@virginia.edu</A><BR=20 > style=3D"mso-special-character: line-break"><BR=20 > style=3D"mso-special-character: line-break"><?xml:namespace prefix =3D o ns= > =3D=20 > "urn:schemas-microsoft-com:office:office"=20 > /><o:p></o:p></SPAN></I></P></DIV></DIV></BODY></HTML> > > ------=_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