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">Why, </font></font></font><p><font color="#000000"><font
size="2"><fontface="arial,sans-serif"></font></font></font> <p><font color="#000000"><font size="2"><font
face="arial,sans-serif">   That's a vintage 02-Feb-2006 driver.</font></font></font><p><font color="#000000"><font
size="2"><fontface="arial,sans-serif"></font></font></font> <p><font color="#000000"><font size="2"><font
face="arial,sans-serif">    I use 8.04 from Dec-2009 and even that's getting a little stale.  Why not try the 9.n
drivers.</font></font></font><p><fontcolor="#000000"><font size="2"><font
face="arial,sans-serif"></font></font></font> <p><fontcolor="#000000"><font size="2"><font
face="arial,sans-serif">     Couldthe port(s) be blocked / restricted between you and the server and is PostgreSQL SSL
supportenabled -- </font></font></font><p><font color="#000000"><font size="2"><font face="arial,sans-serif">        <a
href="http://www.postgresql.org/docs/9.0/static/ssl-tcp.html">http://www.postgresql.org/docs/9.0/static/ssl-tcp.html</a></font></font></font><p> <p>     JMS<p><font
color="#000000"><fontsize="2"><font face="arial,sans-serif"></font></font></font> <p><font color="#000000"><font
size="2"><fontface="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 1:58 PM <br />To: "pgsql-odbc@postgresql.org" <br />Subject: [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;}
/* 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;}
span.EmailStyle17{mso-style-type:personal-compose;font-family:"Calibri","sans-serif";color:windowtext;}
.MsoChpDefault{mso-style-type:export-only;font-family:"Calibri","sans-serif";}
@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">Before learning there was an odbc list, I sent this post to
theadmin list.<p class="MsoNormal"> <p class="MsoNormal">I am running postgres on a red hat linux server.<p
class="MsoNormal">postgresql-python-8.1.23-1.el5_6.1<pclass="MsoNormal">postgresql-test-8.1.23-1.el5_6.1<p
class="MsoNormal">postgresql-libs-8.1.23-1.el5_6.1<pclass="MsoNormal">postgresql-docs-8.1.23-1.el5_6.1<p
class="MsoNormal">postgresql-contrib-8.1.23-1.el5_6.1<pclass="MsoNormal">postgresql-8.1.23-1.el5_6.1<p
class="MsoNormal">postgresql-pl-8.1.23-1.el5_6.1<pclass="MsoNormal"><b>postgresql-odbc-08.01.0200-3.1</b><p
class="MsoNormal">postgresql-jdbc-8.1.407-1jpp.4<pclass="MsoNormal">postgresql-server-8.1.23-1.el5_6.1<p
class="MsoNormal">postgresql-tcl-8.1.23-1.el5_6.1<pclass="MsoNormal"> <p class="MsoNormal">User on windows computers
wouldlike to odbc to the postgres databases.<p class="MsoNormal">I downloaded the windows postgres odbc drivers from
thefollowing site and installed version “psqlodbc-08_01_0200” on the windows computer.<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><pclass="MsoNormal"> <p
class="MsoNormal">WhenI 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-verifiedfile DSN?”<p class="MsoNormal">The parameters entered are:<p class="MsoNormal">Database: database_name<p
class="MsoNormal">Server:I entered the IP address of the server<p class="MsoNormal">User Name: I entered postgres<p
class="MsoNormal">Password:<pclass="MsoNormal">SSL Mode: prefer<p class="MsoNormal">Port: 5432 (which is the port used
bypostgres)<p class="MsoNormal"> <p class="MsoNormal">Do I need to configure the /etc/odbc.ini file? It is currently
justa blank file.<p class="MsoNormal"> <p class="MsoNormal">Thanks for any help.<p class="MsoNormal"> <p
class="MsoNormal"><spanstyle="FONT-FAMILY: 'Courier New'; FONT-SIZE: 10pt">Marc</span></div></blockquote>