Re: first time odbc - Mailing list pgsql-odbc

<p><font color="#000000"><font size="2"><font face="arial,sans-serif"></font></font></font> <p><font
color="#000000"><fontsize="2"><font face="arial,sans-serif"><a
href="http://www.postgresql.org/docs/9.0/static/auth-pg-hba-conf.html">http://www.postgresql.org/docs/9.0/static/auth-pg-hba-conf.html</a></font></font></font><p><font
color="#000000"><fontsize="2"><font face="arial,sans-serif"> </font></font></font><p><br /><blockquote
style="BORDER-LEFT:#0000ff 2px solid; PADDING-LEFT: 5px; MARGIN-LEFT: 0px">-----Original Message----- <br />From: Marc
Fromm<br />Sent: Mar 29, 2011 3:01 PM <br />To: "jsilberberg@mindspring.com" <br />Cc: "pgsql-odbc@postgresql.org" <br
/>Subject:RE: [ODBC] first time odbc <br /><br /><style><ZZZ!-- 
/* Font Definitions */
@font-face{font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face{font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal,
div.MsoNormal{margin:0in;margin-bottom:.0001pt;font-size:11.0pt;font-family:"Calibri","sans-serif";}
a:ZZZlink, span.MsoHyperlink{mso-style-priority:99;color:blue;text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed{mso-style-priority:99;color:purple;text-decoration:underline;}
p{mso-style-priority:99;margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Times New Roman","serif";}
span.EmailStyle18{mso-style-type:personal;font-family:"Calibri","sans-serif";color:windowtext;}
span.EmailStyle19{mso-style-type:personal-reply;font-family:"Calibri","sans-serif";color:#1F497D;}
.MsoChpDefault{mso-style-type:export-only;font-size:10.0pt;}
@page WordSection1{size:8.5in 11.0in;margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1{page:WordSection1;}
--></style><div class="WordSection1"><p class="MsoNormal"><span style="COLOR: #1f497d">I updated the windows postgresql
odbcdrivers and now I get the message:</span><p class="MsoNormal"><span style="COLOR: #1f497d">No connection could be
madebecause the target machine actively refused it.</span><p class="MsoNormal"><span style="COLOR: #1f497d"> </span><p
class="MsoNormal"><spanstyle="COLOR: #1f497d">This sounds like something needs to be configured on the server to allow
theodbc connection.</span><p class="MsoNormal"><span style="COLOR: #1f497d"> </span><div><div style="BORDER-BOTTOM:
mediumnone; BORDER-LEFT: medium none; PADDING-BOTTOM: 0in; PADDING-LEFT: 0in; PADDING-RIGHT: 0in; BORDER-TOP: #b5c4df
1ptsolid; BORDER-RIGHT: medium none; PADDING-TOP: 3pt"><p class="MsoNormal"><b><span style="FONT-FAMILY:
'Tahoma','sans-serif';FONT-SIZE: 10pt">From:</span></b><span style="FONT-FAMILY: 'Tahoma','sans-serif'; FONT-SIZE:
10pt">jsilberberg@mindspring.com [mailto:jsilberberg@mindspring.com] <br /><b>Sent:</b> Tuesday, March 29, 2011 11:13
AM<br/><b>To:</b> Marc Fromm; pgsql-odbc@postgresql.org<br /><b>Subject:</b> Re: [ODBC] first time
odbc</span></div></div><pclass="MsoNormal"> <p><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: black; FONT-SIZE:
10pt"> </span><p><spanstyle="FONT-FAMILY: 'Arial','sans-serif'; COLOR: black; FONT-SIZE: 10pt">Why, </span><p><span
style="FONT-FAMILY:'Arial','sans-serif'; COLOR: black; FONT-SIZE: 10pt"> </span><p><span style="FONT-FAMILY:
'Arial','sans-serif';COLOR: black; FONT-SIZE: 10pt">    That's a vintage 02-Feb-2006 driver.</span><p><span
style="FONT-FAMILY:'Arial','sans-serif'; COLOR: black; FONT-SIZE: 10pt"> </span><p><span style="FONT-FAMILY:
'Arial','sans-serif';COLOR: black; FONT-SIZE: 10pt">     I use 8.04 from Dec-2009 and even that's getting a little
stale. Why not try the 9.n drivers.</span><p><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: black; FONT-SIZE:
10pt"> </span><p><spanstyle="FONT-FAMILY: 'Arial','sans-serif'; COLOR: black; FONT-SIZE: 10pt">     Could the port(s)
beblocked / restricted between you and the server and is PostgreSQL SSL support enabled -- </span><p><span
style="FONT-FAMILY:'Arial','sans-serif'; COLOR: black; FONT-SIZE: 10pt">        <a
href="http://www.postgresql.org/docs/9.0/static/ssl-tcp.html"
target="_blank">http://www.postgresql.org/docs/9.0/static/ssl-tcp.html</a></span><p><spanstyle="FONT-FAMILY:
'Arial','sans-serif';COLOR: black; FONT-SIZE: 10pt"> </span><p><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR:
black;FONT-SIZE: 10pt">     JMS</span><p><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: black; FONT-SIZE:
10pt"> </span><p><spanstyle="FONT-FAMILY: 'Arial','sans-serif'; COLOR: black; FONT-SIZE:
10pt">    -----------------------------------</span><p><spanstyle="FONT-FAMILY: 'Arial','sans-serif'; COLOR: black;
FONT-SIZE:10pt"> </span><blockquote style="BORDER-BOTTOM: medium none; BORDER-LEFT: blue 1.5pt solid; PADDING-BOTTOM:
0in;MARGIN-TOP: 5pt; PADDING-LEFT: 4pt; PADDING-RIGHT: 0in; MARGIN-BOTTOM: 5pt; MARGIN-LEFT: 0in; BORDER-TOP: medium
none;BORDER-RIGHT: medium none; PADDING-TOP: 0in"><p class="MsoNormal"><span style="FONT-FAMILY: 'Arial','sans-serif';
COLOR:black; FONT-SIZE: 10pt">-----Original Message----- <br />From: Marc Fromm <br />Sent: Mar 29, 2011 1:58 PM <br
/>To:"<a href="mailto:pgsql-odbc@postgresql.org" target="_blank">pgsql-odbc@postgresql.org</a>" <br />Subject: [ODBC]
firsttime odbc <br /><br /><br /></span><p class="MsoNormal"><span style="COLOR: black">Before learning there was an
odbclist, I sent this post to the admin list.</span><p class="MsoNormal"><span style="COLOR: black"> </span><p
class="MsoNormal"><spanstyle="COLOR: black">I am running postgres on a red hat linux server.</span><p
class="MsoNormal"><spanstyle="COLOR: black">postgresql-python-8.1.23-1.el5_6.1</span><p class="MsoNormal"><span
style="COLOR:black">postgresql-test-8.1.23-1.el5_6.1</span><p class="MsoNormal"><span style="COLOR:
black">postgresql-libs-8.1.23-1.el5_6.1</span><pclass="MsoNormal"><span style="COLOR:
black">postgresql-docs-8.1.23-1.el5_6.1</span><pclass="MsoNormal"><span style="COLOR:
black">postgresql-contrib-8.1.23-1.el5_6.1</span><pclass="MsoNormal"><span style="COLOR:
black">postgresql-8.1.23-1.el5_6.1</span><pclass="MsoNormal"><span style="COLOR:
black">postgresql-pl-8.1.23-1.el5_6.1</span><pclass="MsoNormal"><b><span style="COLOR:
black">postgresql-odbc-08.01.0200-3.1</span></b><spanstyle="COLOR: black"></span><p class="MsoNormal"><span
style="COLOR:black">postgresql-jdbc-8.1.407-1jpp.4</span><p class="MsoNormal"><span style="COLOR:
black">postgresql-server-8.1.23-1.el5_6.1</span><pclass="MsoNormal"><span style="COLOR:
black">postgresql-tcl-8.1.23-1.el5_6.1</span><pclass="MsoNormal"><span style="COLOR: black"> </span><p
class="MsoNormal"><spanstyle="COLOR: black">User on windows computers would like to odbc to the postgres
databases.</span><pclass="MsoNormal"><span style="COLOR: black">I downloaded the windows postgres odbc drivers from the
followingsite and installed version “psqlodbc-08_01_0200” on the windows computer.</span><p class="MsoNormal"><span
style="COLOR:black"><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></span><p
class="MsoNormal"><spanstyle="COLOR: black"> </span><p class="MsoNormal"><span style="COLOR: black">When I configure a
“FileData Source” connection in access, I cannot connect to the postgresql database. I get the message, “A connection
couldnot be made using the file data source parameters entered. Save non-verified file DSN?”</span><p
class="MsoNormal"><spanstyle="COLOR: black">The parameters entered are:</span><p class="MsoNormal"><span style="COLOR:
black">Database:database_name</span><p class="MsoNormal"><span style="COLOR: black">Server: I entered the IP address of
theserver</span><p class="MsoNormal"><span style="COLOR: black">User Name: I entered postgres</span><p
class="MsoNormal"><spanstyle="COLOR: black">Password:</span><p class="MsoNormal"><span style="COLOR: black">SSL Mode:
prefer</span><pclass="MsoNormal"><span style="COLOR: black">Port: 5432 (which is the port used by postgres)</span><p
class="MsoNormal"><spanstyle="COLOR: black"> </span><p class="MsoNormal"><span style="COLOR: black">Do I need to
configurethe /etc/odbc.ini file? It is currently just a blank file.</span><p class="MsoNormal"><span style="COLOR:
black"> </span><pclass="MsoNormal"><span style="COLOR: black">Thanks for any help.</span><p class="MsoNormal"><span
style="COLOR:black"> </span><p class="MsoNormal"><span style="FONT-FAMILY: 'Courier New'; COLOR: black; FONT-SIZE:
10pt">Marc</span><spanstyle="COLOR: black"></span></blockquote></div></blockquote>