Quick Links

Re: first time odbc

From:	"jsilberberg(at)mindspring(dot)com" <jsilberberg(at)mindspring(dot)com>
To:	Marc Fromm <Marc(dot)Fromm(at)wwu(dot)edu>
Cc:	"pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org>
Subject:	Re: first time odbc
Date:	2011-03-29 19:27:36
Message-ID:	12181302.1301426856719.JavaMail.root@mswamui-bichon.atl.sa.earthlink.net
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-odbc

<HEAD>
<STYLE>body{font-size:10pt;font-family:arial,sans-serif;background-color:#ffffff;color:black;}p{margin:0px;}</STYLE>

<META name=GENERATOR content="MSHTML 8.00.7600.16722"></HEAD>
<BODY>
 
<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>
 
 
<BLOCKQUOTE style="BORDER-LEFT: #0000ff 2px solid; PADDING-LEFT: 5px; MARGIN-LEFT: 0px">-----Original Message----- From: Marc Fromm <MARC(dot)FROMM(at)WWU(dot)EDU> Sent: Mar 29, 2011 3:01 PM To: "jsilberberg(at)mindspring(dot)com" <JSILBERBERG(at)MINDSPRING(dot)COM> Cc: "pgsql-odbc(at)postgresql(dot)org" <PGSQL-ODBC(at)POSTGRESQL(dot)ORG> Subject: RE: [ODBC] first time odbc <?XML:NAMESPACE PREFIX = [default] http://www.w3.org/TR/REC-html40 NS = "http://www.w3.org/TR/REC-html40" /><ZZZhtml xmlns="http://www.w3.org/TR/REC-html40" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:v="urn:schemas-microsoft-com:vml"><ZZZhead><ZZZmeta content="text/html; charset=utf-8" http-equiv="Content-Type"><ZZZmeta content="Microsoft Word 14 (filtered medium)" name="Generator">
<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>
<ZZZ!--[if 9] mso gte><xml><?xml:namespace prefix = o /><o:shapedefaults spidmax="1026" v:ext="edit"></o:shapedefaults></xml><ZZZ![endif]--><ZZZ!--[if 9] mso gte><xml><o:shapelayout v:ext="edit"><o:idmap v:ext="edit" data="1"></o:idmap></o:shapelayout></xml><ZZZ![endif]--></ZZZhead><ZZZbody lang=EN-US vlink="purple" link="blue" bgcolor="white">
<DIV class=WordSection1>
I updated the windows postgresql odbc drivers and now I get the message:<o:p></o:p>
No connection could be made because the target machine actively refused it.<o:p></o:p>
<o:p> </o:p>
This sounds like something needs to be configured on the server to allow the odbc connection.<o:p></o:p>
<o:p> </o:p>
<DIV>
<DIV style="BORDER-BOTTOM: medium none; BORDER-LEFT: medium none; PADDING-BOTTOM: 0in; PADDING-LEFT: 0in; PADDING-RIGHT: 0in; BORDER-TOP: #b5c4df 1pt solid; BORDER-RIGHT: medium none; PADDING-TOP: 3pt">
From: jsilberberg(at)mindspring(dot)com [mailto:jsilberberg(at)mindspring(dot)com] Sent: Tuesday, March 29, 2011 11:13 AM To: Marc Fromm; pgsql-odbc(at)postgresql(dot)org Subject: Re: [ODBC] first time odbc<o:p></o:p></DIV></DIV>
<o:p> </o:p>
 <o:p></o:p>
Why, <o:p></o:p>
 <o:p></o:p>
    That's a vintage 02-Feb-2006 driver.<o:p></o:p>
 <o:p></o:p>
     I use 8.04 from Dec-2009 and even that's getting a little stale.  Why not try the 9.n drivers.<o:p></o:p>
 <o:p></o:p>
     Could the port(s) be blocked / restricted between you and the server and is PostgreSQL SSL support enabled -- <o:p></o:p>
        <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><o:p></o:p>
 <o:p></o:p>
     JMS<o:p></o:p>
 <o:p></o:p>
    -----------------------------------<o:p></o:p>
<o:p> </o:p>
<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">
-----Original Message----- From: Marc Fromm Sent: Mar 29, 2011 1:58 PM To: "<A href="mailto:pgsql-odbc(at)postgresql(dot)org" target=_blank>pgsql-odbc(at)postgresql(dot)org</A>" Subject: [ODBC] first time odbc <o:p></o:p>
Before learning there was an odbc list, I sent this post to the admin list.<o:p></o:p>
 <o:p></o:p>
I am running postgres on a red hat linux server.<o:p></o:p>
postgresql-python-8.1.23-1.el5_6.1<o:p></o:p>
postgresql-test-8.1.23-1.el5_6.1<o:p></o:p>
postgresql-libs-8.1.23-1.el5_6.1<o:p></o:p>
postgresql-docs-8.1.23-1.el5_6.1<o:p></o:p>
postgresql-contrib-8.1.23-1.el5_6.1<o:p></o:p>
postgresql-8.1.23-1.el5_6.1<o:p></o:p>
postgresql-pl-8.1.23-1.el5_6.1<o:p></o:p>
postgresql-odbc-08.01.0200-3.1<o:p></o:p>
postgresql-jdbc-8.1.407-1jpp.4<o:p></o:p>
postgresql-server-8.1.23-1.el5_6.1<o:p></o:p>
postgresql-tcl-8.1.23-1.el5_6.1<o:p></o:p>
 <o:p></o:p>
User on windows computers would like to odbc to the postgres databases.<o:p></o:p>
I downloaded the windows postgres odbc drivers from the following site and installed version “psqlodbc-08_01_0200” on the windows computer.<o:p></o:p>
<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><o:p></o:p>
 <o:p></o:p>
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?”<o:p></o:p>
The parameters entered are:<o:p></o:p>
Database: database_name<o:p></o:p>
Server: I entered the IP address of the server<o:p></o:p>
User Name: I entered postgres<o:p></o:p>
Password:<o:p></o:p>
SSL Mode: prefer<o:p></o:p>
Port: 5432 (which is the port used by postgres)<o:p></o:p>
 <o:p></o:p>
Do I need to configure the /etc/odbc.ini file? It is currently just a blank file.<o:p></o:p>
 <o:p></o:p>
Thanks for any help.<o:p></o:p>
 <o:p></o:p>
Marc<o:p></o:p></BLOCKQUOTE></DIV></ZZZbody></ZZZhtml></BLOCKQUOTE></ZZZ![endif]--></ZZZ!--[if></ZZZ![endif]--></ZZZ!--[if></ZZZmeta></ZZZmeta></BODY>

Attachment	Content-Type	Size
unknown_filename	text/html	10.6 KB

Responses

Re: first time odbc at 2011-03-29 20:09:34 from Raymond O'Donnell
Re: first time odbc at 2011-03-29 20:16:17 from Jan-Peter Seifert

Browse pgsql-odbc by date

	From	Date	Subject
Next Message	Raymond O'Donnell	2011-03-29 20:09:34	Re: first time odbc
Previous Message	Marc Fromm	2011-03-29 19:01:55	Re: first time odbc