[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-admin
Subject: Re: [ADMIN] odbc
From: David Bear <David.Bear () asu ! edu>
Date: 2011-03-30 16:18:24
Message-ID: AANLkTinA9m9t-fx5d9JXKbUMGOcgvxPqqRhgbbrbVvWi () mail ! gmail ! com
[Download RAW message or body]
On Tue, Mar 29, 2011 at 10:51 AM, Marc Fromm <Marc.Fromm@wwu.edu> wrote:
> I am running postgres on a red hat linux server.
>
> postgresql-python-8.1.23-1.el5_6.1
>
> postgresql-test-8.1.23-1.el5_6.1
>
> postgresql-libs-8.1.23-1.el5_6.1
>
> postgresql-docs-8.1.23-1.el5_6.1
>
> postgresql-contrib-8.1.23-1.el5_6.1
>
> postgresql-8.1.23-1.el5_6.1
>
> postgresql-pl-8.1.23-1.el5_6.1
>
> *postgresql-odbc-08.01.0200-3.1*
>
> postgresql-jdbc-8.1.407-1jpp.4
>
> postgresql-server-8.1.23-1.el5_6.1
>
> postgresql-tcl-8.1.23-1.el5_6.1
>
>
>
> User on windows computers would like to odbc to the postgres databases.
>
> I downloaded the windows postgres odbc drivers from the following site and
> installed version "psqlodbc-08_01_0200" on the windows computer.
>
> http://ftp9.us.postgresql.org/pub/mirrors/postgresql/odbc/versions/msi/
>
>
>
> When I configure a "File Data Source" connection in access, I cannot
> connect to the postgresql database. I get the message, "A connection could
> not be made using the file data source parameters entered. Save non-verified
> file DSN?"
>
> The parameters entered are:
>
> Database: database_name
>
> Server: I entered the IP address of the server
>
> User Name: I entered postgres
>
> Password:
>
> SSL Mode: prefer
>
> Port: 5432 (which is the port used by postgres)
>
>
>
> Do I need to configure the /etc/odbc.ini file? It is currently just a blank
> file.
>
>
>
> Thanks for any help.
>
>
You also need to make sure postgresql is listening on a public IP address
AND you don't have any intervening filewall -- hostbased or otherwise. Be
default, redhad does not allow connections to port 5432 via its standard
rule set. I would install something like pgadmin on the windows client and
see if that will allow you to connect first. If pgadmin connects, then its
likely and odbc config issue.
>
>
> Marc
>
--
David Bear
College of Public Programs at ASU
602-496-0424
[Attachment #3 (text/html)]
<div class="gmail_quote">On Tue, Mar 29, 2011 at 10:51 AM, Marc Fromm <span \
dir="ltr"><<a href="mailto:Marc.Fromm@wwu.edu">Marc.Fromm@wwu.edu</a>></span> \
wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px \
#ccc solid;padding-left:1ex;">
<div lang="EN-US" link="blue" vlink="purple">
<div>
<p class="MsoNormal">I am running postgres on a red hat linux server.</p>
<p class="MsoNormal">postgresql-python-8.1.23-1.el5_6.1</p>
<p class="MsoNormal">postgresql-test-8.1.23-1.el5_6.1</p>
<p class="MsoNormal">postgresql-libs-8.1.23-1.el5_6.1</p>
<p class="MsoNormal">postgresql-docs-8.1.23-1.el5_6.1</p>
<p class="MsoNormal">postgresql-contrib-8.1.23-1.el5_6.1</p>
<p class="MsoNormal">postgresql-8.1.23-1.el5_6.1</p>
<p class="MsoNormal">postgresql-pl-8.1.23-1.el5_6.1</p>
<p class="MsoNormal"><b>postgresql-odbc-08.01.0200-3.1</b></p>
<p class="MsoNormal">postgresql-jdbc-8.1.407-1jpp.4</p>
<p class="MsoNormal">postgresql-server-8.1.23-1.el5_6.1</p>
<p class="MsoNormal">postgresql-tcl-8.1.23-1.el5_6.1</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">User on windows computers would like to odbc to the postgres \
databases.</p> <p class="MsoNormal">I downloaded the windows postgres odbc drivers \
from the following site and installed version "psqlodbc-08_01_0200" on the windows \
computer.</p> <p class="MsoNormal"><a \
href="http://ftp9.us.postgresql.org/pub/mirrors/postgresql/odbc/versions/msi/" \
target="_blank">http://ftp9.us.postgresql.org/pub/mirrors/postgresql/odbc/versions/msi/</a></p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">When I configure a "File Data Source" connection in access, I \
cannot connect to the postgresql database. I get the message, "A connection could not \
be made using the file data source parameters entered. Save non-verified file \
DSN?"</p>
<p class="MsoNormal">The parameters entered are:</p>
<p class="MsoNormal">Database: database_name</p>
<p class="MsoNormal">Server: I entered the IP address of the server</p>
<p class="MsoNormal">User Name: I entered postgres</p>
<p class="MsoNormal">Password:</p>
<p class="MsoNormal">SSL Mode: prefer</p>
<p class="MsoNormal">Port: 5432 (which is the port used by postgres)</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Do I need to configure the /etc/odbc.ini file? It is currently \
just a blank file.</p> <p class="MsoNormal"> </p>
<p class="MsoNormal">Thanks for any help.</p>
<p class="MsoNormal"></p></div></div></blockquote><div><br></div><div>You also need \
to make sure postgresql is listening on a public IP address AND you don't have \
any intervening filewall -- hostbased or otherwise. Be default, redhad does not allow \
connections to port 5432 via its standard rule set. I would install something like \
pgadmin on the windows client and see if that will allow you to connect first. If \
pgadmin connects, then its likely and odbc config issue.</div> <div><br></div><div> \
</div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex;"><div lang="EN-US" link="blue" vlink="purple"><div><p \
class="MsoNormal"> </p><font color="#888888"> <p class="MsoNormal"><span \
style="font-size:10.0pt;font-family:"Courier New"">Marc </span></p>
</font></div>
</div>
</blockquote></div><br><br clear="all"><br>-- <br>David Bear<br>College of Public \
Programs at ASU<br>602-496-0424<br>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic