first time odbc

first time odbc

am 29.03.2011 19:58:59 von Marc Fromm

--_000_93361C67E4EE844A80935863A4FF4B6C04E60C32Exch2010MB2un iv_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Before learning there was an odbc list, I sent this post to the admin list.

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/ve rsions/msi/

When I configure a "File Data Source" connection in access, I cannot connec=
t 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.

Marc

--_000_93361C67E4EE844A80935863A4FF4B6C04E60C32Exch2010MB2un iv_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" xmlns=3D"http:=
//www.w3.org/TR/REC-html40">

>





Before learning there was an odbc list, I sent this =
post to the admin list.


 


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.


/postgresql/odbc/versions/msi/">http://ftp9.us.postgresql.or g/pub/mirrors/p=
ostgresql/odbc/versions/msi/


 


When I configure a “File Data Source” co=
nnection in access, I cannot connect to the postgresql database. I get the =
message, “A connection could not be made using the file data source p=
arameters entered. Save non-verified file DSN?”


The parameters entered are:


Database: database_name


Server: I entered the IP address of the server<=
/o:p>


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.


 


urier New"">Marc






--_000_93361C67E4EE844A80935863A4FF4B6C04E60C32Exch2010MB2un iv_--

Re: first time odbc

am 29.03.2011 20:58:22 von Rob Richardson

This is a multi-part message in MIME format.

------_=_NextPart_001_01CBEE43.46A0F025
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

First step: Upgrade your Postgres ODBC driver. Get at least 8.04.
We've got a customer using 8.01, and we've run into significant
problems.

=20

Second step: Try a User DSN or System DSN. =20

=20

Good luck!

=20

RobR


------_=_NextPart_001_01CBEE43.46A0F025
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns=3D"http://www.w3.org/TR/REC-html40"
xmlns:ns0=3D"http://schemas.microsoft.com/office/2004/12/omm l">


charset=3Dus-ascii">









style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>First step:  Upgrade your =
Postgres ODBC
driver.  Get at least 8.04.  We’ve got a customer using =
8.01, and we’ve
run into significant problems.



style=3D'font-size:
10.0pt;font-family:Arial;color:navy'> 



style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>Second step:  Try a User DSN =
or System
DSN. 



style=3D'font-size:
10.0pt;font-family:Arial;color:navy'> 



style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>Good =
luck!



style=3D'font-size:
10.0pt;font-family:Arial;color:navy'> 



style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>RobR









------_=_NextPart_001_01CBEE43.46A0F025--

Re: first time odbc

am 29.03.2011 21:01:55 von Marc Fromm

--_000_93361C67E4EE844A80935863A4FF4B6C04E60CC8Exch2010MB2un iv_
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: base64

SSB1cGRhdGVkIHRoZSB3aW5kb3dzIHBvc3RncmVzcWwgb2RiYyBkcml2ZXJz IGFuZCBub3cgSSBn
ZXQgdGhlIG1lc3NhZ2U6DQpObyBjb25uZWN0aW9uIGNvdWxkIGJlIG1hZGUg YmVjYXVzZSB0aGUg
dGFyZ2V0IG1hY2hpbmUgYWN0aXZlbHkgcmVmdXNlZCBpdC4NCg0KVGhpcyBz b3VuZHMgbGlrZSBz
b21ldGhpbmcgbmVlZHMgdG8gYmUgY29uZmlndXJlZCBvbiB0aGUgc2VydmVy IHRvIGFsbG93IHRo
ZSBvZGJjIGNvbm5lY3Rpb24uDQoNCkZyb206IGpzaWxiZXJiZXJnQG1pbmRz cHJpbmcuY29tIFtt
YWlsdG86anNpbGJlcmJlcmdAbWluZHNwcmluZy5jb21dDQpTZW50OiBUdWVz ZGF5LCBNYXJjaCAy
OSwgMjAxMSAxMToxMyBBTQ0KVG86IE1hcmMgRnJvbW07IHBnc3FsLW9kYmNA cG9zdGdyZXNxbC5v
cmcNClN1YmplY3Q6IFJlOiBbT0RCQ10gZmlyc3QgdGltZSBvZGJjDQoNCg0K DQoNCldoeSwNCg0K
DQoNCiAgICBUaGF0J3MgYSB2aW50YWdlIDAyLUZlYi0yMDA2IGRyaXZlci4N Cg0KDQoNCiAgICAg
SSB1c2UgOC4wNCBmcm9tIERlYy0yMDA5IGFuZCBldmVuIHRoYXQncyBnZXR0 aW5nIGEgbGl0dGxl
IHN0YWxlLiAgV2h5IG5vdCB0cnkgdGhlIDkubiBkcml2ZXJzLg0KDQoNCg0K ICAgICBDb3VsZCB0
aGUgcG9ydChzKSBiZSBibG9ja2VkIC8gcmVzdHJpY3RlZCBiZXR3ZWVuIHlv dSBhbmQgdGhlIHNl
cnZlciBhbmQgaXMgUG9zdGdyZVNRTCBTU0wgc3VwcG9ydCBlbmFibGVkIC0t DQoNCiAgICAgICAg
aHR0cDovL3d3dy5wb3N0Z3Jlc3FsLm9yZy9kb2NzLzkuMC9zdGF0aWMvc3Ns LXRjcC5odG1sDQoN
Cg0KDQogICAgIEpNUw0KDQoNCg0KICAgIC0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0t
LS0tDQoNCg0KLS0tLS1PcmlnaW5hbCBNZXNzYWdlLS0tLS0NCkZyb206IE1h cmMgRnJvbW0NClNl
bnQ6IE1hciAyOSwgMjAxMSAxOjU4IFBNDQpUbzogInBnc3FsLW9kYmNAcG9z dGdyZXNxbC5vcmc8
bWFpbHRvOnBnc3FsLW9kYmNAcG9zdGdyZXNxbC5vcmc+Ig0KU3ViamVjdDog W09EQkNdIGZpcnN0
IHRpbWUgb2RiYw0KDQoNCkJlZm9yZSBsZWFybmluZyB0aGVyZSB3YXMgYW4g b2RiYyBsaXN0LCBJ
IHNlbnQgdGhpcyBwb3N0IHRvIHRoZSBhZG1pbiBsaXN0Lg0KDQpJIGFtIHJ1 bm5pbmcgcG9zdGdy
ZXMgb24gYSByZWQgaGF0IGxpbnV4IHNlcnZlci4NCnBvc3RncmVzcWwtcHl0 aG9uLTguMS4yMy0x
LmVsNV82LjENCnBvc3RncmVzcWwtdGVzdC04LjEuMjMtMS5lbDVfNi4xDQpw b3N0Z3Jlc3FsLWxp
YnMtOC4xLjIzLTEuZWw1XzYuMQ0KcG9zdGdyZXNxbC1kb2NzLTguMS4yMy0x LmVsNV82LjENCnBv
c3RncmVzcWwtY29udHJpYi04LjEuMjMtMS5lbDVfNi4xDQpwb3N0Z3Jlc3Fs LTguMS4yMy0xLmVs
NV82LjENCnBvc3RncmVzcWwtcGwtOC4xLjIzLTEuZWw1XzYuMQ0KcG9zdGdy ZXNxbC1vZGJjLTA4
LjAxLjAyMDAtMy4xDQpwb3N0Z3Jlc3FsLWpkYmMtOC4xLjQwNy0xanBwLjQN CnBvc3RncmVzcWwt
c2VydmVyLTguMS4yMy0xLmVsNV82LjENCnBvc3RncmVzcWwtdGNsLTguMS4y My0xLmVsNV82LjEN
Cg0KVXNlciBvbiB3aW5kb3dzIGNvbXB1dGVycyB3b3VsZCBsaWtlIHRvIG9k YmMgdG8gdGhlIHBv
c3RncmVzIGRhdGFiYXNlcy4NCkkgZG93bmxvYWRlZCB0aGUgd2luZG93cyBw b3N0Z3JlcyBvZGJj
IGRyaXZlcnMgZnJvbSB0aGUgZm9sbG93aW5nIHNpdGUgYW5kIGluc3RhbGxl ZCB2ZXJzaW9uIOKA
nHBzcWxvZGJjLTA4XzAxXzAyMDDigJ0gb24gdGhlIHdpbmRvd3MgY29tcHV0 ZXIuDQpodHRwOi8v
ZnRwOS51cy5wb3N0Z3Jlc3FsLm9yZy9wdWIvbWlycm9ycy9wb3N0Z3Jlc3Fs L29kYmMvdmVyc2lv
bnMvbXNpLw0KDQpXaGVuIEkgY29uZmlndXJlIGEg4oCcRmlsZSBEYXRhIFNv dXJjZeKAnSBjb25u
ZWN0aW9uIGluIGFjY2VzcywgSSBjYW5ub3QgY29ubmVjdCB0byB0aGUgcG9z dGdyZXNxbCBkYXRh
YmFzZS4gSSBnZXQgdGhlIG1lc3NhZ2UsIOKAnEEgY29ubmVjdGlvbiBjb3Vs ZCBub3QgYmUgbWFk
ZSB1c2luZyB0aGUgZmlsZSBkYXRhIHNvdXJjZSBwYXJhbWV0ZXJzIGVudGVy ZWQuIFNhdmUgbm9u
LXZlcmlmaWVkIGZpbGUgRFNOP+KAnQ0KVGhlIHBhcmFtZXRlcnMgZW50ZXJl ZCBhcmU6DQpEYXRh
YmFzZTogZGF0YWJhc2VfbmFtZQ0KU2VydmVyOiBJIGVudGVyZWQgdGhlIElQ IGFkZHJlc3Mgb2Yg
dGhlIHNlcnZlcg0KVXNlciBOYW1lOiBJIGVudGVyZWQgcG9zdGdyZXMNClBh c3N3b3JkOg0KU1NM
IE1vZGU6IHByZWZlcg0KUG9ydDogNTQzMiAod2hpY2ggaXMgdGhlIHBvcnQg dXNlZCBieSBwb3N0
Z3JlcykNCg0KRG8gSSBuZWVkIHRvIGNvbmZpZ3VyZSB0aGUgL2V0Yy9vZGJj LmluaSBmaWxlPyBJ
dCBpcyBjdXJyZW50bHkganVzdCBhIGJsYW5rIGZpbGUuDQoNClRoYW5rcyBm b3IgYW55IGhlbHAu
DQoNCk1hcmMNCg==

--_000_93361C67E4EE844A80935863A4FF4B6C04E60CC8Exch2010MB2un iv_
Content-Type: text/html; charset="utf-8"
Content-Transfer-Encoding: base64

PGh0bWwgeG1sbnM6dj0idXJuOnNjaGVtYXMtbWljcm9zb2Z0LWNvbTp2bWwi IHhtbG5zOm89InVy
bjpzY2hlbWFzLW1pY3Jvc29mdC1jb206b2ZmaWNlOm9mZmljZSIgeG1sbnM6 dz0idXJuOnNjaGVt
YXMtbWljcm9zb2Z0LWNvbTpvZmZpY2U6d29yZCIgeG1sbnM6bT0iaHR0cDov L3NjaGVtYXMubWlj
cm9zb2Z0LmNvbS9vZmZpY2UvMjAwNC8xMi9vbW1sIiB4bWxucz0iaHR0cDov L3d3dy53My5vcmcv
VFIvUkVDLWh0bWw0MCI+DQo8aGVhZD4NCjxtZXRhIGh0dHAtZXF1aXY9IkNv bnRlbnQtVHlwZSIg
Y29udGVudD0idGV4dC9odG1sOyBjaGFyc2V0PXV0Zi04Ij4NCjxtZXRhIG5h bWU9IkdlbmVyYXRv
ciIgY29udGVudD0iTWljcm9zb2Z0IFdvcmQgMTQgKGZpbHRlcmVkIG1lZGl1 bSkiPg0KPHN0eWxl
PjwhLS0NCi8qIEZvbnQgRGVmaW5pdGlvbnMgKi8NCkBmb250LWZhY2UNCgl7 Zm9udC1mYW1pbHk6
Q2FsaWJyaTsNCglwYW5vc2UtMToyIDE1IDUgMiAyIDIgNCAzIDIgNDt9DQpA Zm9udC1mYWNlDQoJ
e2ZvbnQtZmFtaWx5OlRhaG9tYTsNCglwYW5vc2UtMToyIDExIDYgNCAzIDUg NCA0IDIgNDt9DQov
KiBTdHlsZSBEZWZpbml0aW9ucyAqLw0KcC5Nc29Ob3JtYWwsIGxpLk1zb05v cm1hbCwgZGl2Lk1z
b05vcm1hbA0KCXttYXJnaW46MGluOw0KCW1hcmdpbi1ib3R0b206LjAwMDFw dDsNCglmb250LXNp
emU6MTEuMHB0Ow0KCWZvbnQtZmFtaWx5OiJDYWxpYnJpIiwic2Fucy1zZXJp ZiI7fQ0KYTpsaW5r
LCBzcGFuLk1zb0h5cGVybGluaw0KCXttc28tc3R5bGUtcHJpb3JpdHk6OTk7 DQoJY29sb3I6Ymx1
ZTsNCgl0ZXh0LWRlY29yYXRpb246dW5kZXJsaW5lO30NCmE6dmlzaXRlZCwg c3Bhbi5Nc29IeXBl
cmxpbmtGb2xsb3dlZA0KCXttc28tc3R5bGUtcHJpb3JpdHk6OTk7DQoJY29s b3I6cHVycGxlOw0K
CXRleHQtZGVjb3JhdGlvbjp1bmRlcmxpbmU7fQ0KcA0KCXttc28tc3R5bGUt cHJpb3JpdHk6OTk7
DQoJbWFyZ2luOjBpbjsNCgltYXJnaW4tYm90dG9tOi4wMDAxcHQ7DQoJZm9u dC1zaXplOjEyLjBw
dDsNCglmb250LWZhbWlseToiVGltZXMgTmV3IFJvbWFuIiwic2VyaWYiO30N CnNwYW4uRW1haWxT
dHlsZTE4DQoJe21zby1zdHlsZS10eXBlOnBlcnNvbmFsOw0KCWZvbnQtZmFt aWx5OiJDYWxpYnJp
Iiwic2Fucy1zZXJpZiI7DQoJY29sb3I6d2luZG93dGV4dDt9DQpzcGFuLkVt YWlsU3R5bGUxOQ0K
CXttc28tc3R5bGUtdHlwZTpwZXJzb25hbC1yZXBseTsNCglmb250LWZhbWls eToiQ2FsaWJyaSIs
InNhbnMtc2VyaWYiOw0KCWNvbG9yOiMxRjQ5N0Q7fQ0KLk1zb0NocERlZmF1 bHQNCgl7bXNvLXN0
eWxlLXR5cGU6ZXhwb3J0LW9ubHk7DQoJZm9udC1zaXplOjEwLjBwdDt9DQpA cGFnZSBXb3JkU2Vj
dGlvbjENCgl7c2l6ZTo4LjVpbiAxMS4waW47DQoJbWFyZ2luOjEuMGluIDEu MGluIDEuMGluIDEu
MGluO30NCmRpdi5Xb3JkU2VjdGlvbjENCgl7cGFnZTpXb3JkU2VjdGlvbjE7 fQ0KLS0+PC9zdHls
ZT48IS0tW2lmIGd0ZSBtc28gOV0+PHhtbD4NCjxvOnNoYXBlZGVmYXVsdHMg djpleHQ9ImVkaXQi
IHNwaWRtYXg9IjEwMjYiIC8+DQo8L3htbD48IVtlbmRpZl0tLT48IS0tW2lm IGd0ZSBtc28gOV0+
PHhtbD4NCjxvOnNoYXBlbGF5b3V0IHY6ZXh0PSJlZGl0Ij4NCjxvOmlkbWFw IHY6ZXh0PSJlZGl0
IiBkYXRhPSIxIiAvPg0KPC9vOnNoYXBlbGF5b3V0PjwveG1sPjwhW2VuZGlm XS0tPg0KPC9oZWFk
Pg0KPGJvZHkgYmdjb2xvcj0id2hpdGUiIGxhbmc9IkVOLVVTIiBsaW5rPSJi bHVlIiB2bGluaz0i
cHVycGxlIj4NCjxkaXYgY2xhc3M9IldvcmRTZWN0aW9uMSI+DQo8cCBjbGFz cz0iTXNvTm9ybWFs
Ij48c3BhbiBzdHlsZT0iY29sb3I6IzFGNDk3RCI+SSB1cGRhdGVkIHRoZSB3 aW5kb3dzIHBvc3Rn
cmVzcWwgb2RiYyBkcml2ZXJzIGFuZCBub3cgSSBnZXQgdGhlIG1lc3NhZ2U6 PG86cD48L286cD48
L3NwYW4+PC9wPg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PHNwYW4gc3R5bGU9 ImNvbG9yOiMxRjQ5
N0QiPk5vIGNvbm5lY3Rpb24gY291bGQgYmUgbWFkZSBiZWNhdXNlIHRoZSB0 YXJnZXQgbWFjaGlu
ZSBhY3RpdmVseSByZWZ1c2VkIGl0LjxvOnA+PC9vOnA+PC9zcGFuPjwvcD4N CjxwIGNsYXNzPSJN
c29Ob3JtYWwiPjxzcGFuIHN0eWxlPSJjb2xvcjojMUY0OTdEIj48bzpwPiZu YnNwOzwvbzpwPjwv
c3Bhbj48L3A+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj48c3BhbiBzdHlsZT0i Y29sb3I6IzFGNDk3
RCI+VGhpcyBzb3VuZHMgbGlrZSBzb21ldGhpbmcgbmVlZHMgdG8gYmUgY29u ZmlndXJlZCBvbiB0
aGUgc2VydmVyIHRvIGFsbG93IHRoZSBvZGJjIGNvbm5lY3Rpb24uPG86cD48 L286cD48L3NwYW4+
PC9wPg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PHNwYW4gc3R5bGU9ImNvbG9y OiMxRjQ5N0QiPjxv
OnA+Jm5ic3A7PC9vOnA+PC9zcGFuPjwvcD4NCjxkaXY+DQo8ZGl2IHN0eWxl PSJib3JkZXI6bm9u
ZTtib3JkZXItdG9wOnNvbGlkICNCNUM0REYgMS4wcHQ7cGFkZGluZzozLjBw dCAwaW4gMGluIDBp
biI+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj48Yj48c3BhbiBzdHlsZT0iZm9u dC1zaXplOjEwLjBw
dDtmb250LWZhbWlseTomcXVvdDtUYWhvbWEmcXVvdDssJnF1b3Q7c2Fucy1z ZXJpZiZxdW90OyI+
RnJvbTo8L3NwYW4+PC9iPjxzcGFuIHN0eWxlPSJmb250LXNpemU6MTAuMHB0 O2ZvbnQtZmFtaWx5
OiZxdW90O1RhaG9tYSZxdW90OywmcXVvdDtzYW5zLXNlcmlmJnF1b3Q7Ij4g anNpbGJlcmJlcmdA
bWluZHNwcmluZy5jb20gW21haWx0bzpqc2lsYmVyYmVyZ0BtaW5kc3ByaW5n LmNvbV0NCjxicj4N
CjxiPlNlbnQ6PC9iPiBUdWVzZGF5LCBNYXJjaCAyOSwgMjAxMSAxMToxMyBB TTxicj4NCjxiPlRv
OjwvYj4gTWFyYyBGcm9tbTsgcGdzcWwtb2RiY0Bwb3N0Z3Jlc3FsLm9yZzxi cj4NCjxiPlN1Ympl
Y3Q6PC9iPiBSZTogW09EQkNdIGZpcnN0IHRpbWUgb2RiYzxvOnA+PC9vOnA+ PC9zcGFuPjwvcD4N
CjwvZGl2Pg0KPC9kaXY+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj48bzpwPiZu YnNwOzwvbzpwPjwv
cD4NCjxwPjxzcGFuIHN0eWxlPSJmb250LXNpemU6MTAuMHB0O2ZvbnQtZmFt aWx5OiZxdW90O0Fy
aWFsJnF1b3Q7LCZxdW90O3NhbnMtc2VyaWYmcXVvdDs7Y29sb3I6YmxhY2si PiZuYnNwOzxvOnA+
PC9vOnA+PC9zcGFuPjwvcD4NCjxwPjxzcGFuIHN0eWxlPSJmb250LXNpemU6 MTAuMHB0O2ZvbnQt
ZmFtaWx5OiZxdW90O0FyaWFsJnF1b3Q7LCZxdW90O3NhbnMtc2VyaWYmcXVv dDs7Y29sb3I6Ymxh
Y2siPldoeSwNCjxvOnA+PC9vOnA+PC9zcGFuPjwvcD4NCjxwPjxzcGFuIHN0 eWxlPSJmb250LXNp
emU6MTAuMHB0O2ZvbnQtZmFtaWx5OiZxdW90O0FyaWFsJnF1b3Q7LCZxdW90 O3NhbnMtc2VyaWYm
cXVvdDs7Y29sb3I6YmxhY2siPiZuYnNwOzxvOnA+PC9vOnA+PC9zcGFuPjwv cD4NCjxwPjxzcGFu
IHN0eWxlPSJmb250LXNpemU6MTAuMHB0O2ZvbnQtZmFtaWx5OiZxdW90O0Fy aWFsJnF1b3Q7LCZx
dW90O3NhbnMtc2VyaWYmcXVvdDs7Y29sb3I6YmxhY2siPiZuYnNwOyZuYnNw OyZuYnNwOyBUaGF0
J3MgYSB2aW50YWdlIDAyLUZlYi0yMDA2IGRyaXZlci48bzpwPjwvbzpwPjwv c3Bhbj48L3A+DQo8
cD48c3BhbiBzdHlsZT0iZm9udC1zaXplOjEwLjBwdDtmb250LWZhbWlseTom cXVvdDtBcmlhbCZx
dW90OywmcXVvdDtzYW5zLXNlcmlmJnF1b3Q7O2NvbG9yOmJsYWNrIj4mbmJz cDs8bzpwPjwvbzpw
Pjwvc3Bhbj48L3A+DQo8cD48c3BhbiBzdHlsZT0iZm9udC1zaXplOjEwLjBw dDtmb250LWZhbWls
eTomcXVvdDtBcmlhbCZxdW90OywmcXVvdDtzYW5zLXNlcmlmJnF1b3Q7O2Nv bG9yOmJsYWNrIj4m
bmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsgSSB1c2UgOC4wNCBmcm9tIERlYy0y MDA5IGFuZCBldmVu
IHRoYXQncyBnZXR0aW5nIGEgbGl0dGxlIHN0YWxlLiZuYnNwOyBXaHkgbm90 IHRyeSB0aGUgOS5u
IGRyaXZlcnMuPG86cD48L286cD48L3NwYW4+PC9wPg0KPHA+PHNwYW4gc3R5 bGU9ImZvbnQtc2l6
ZToxMC4wcHQ7Zm9udC1mYW1pbHk6JnF1b3Q7QXJpYWwmcXVvdDssJnF1b3Q7 c2Fucy1zZXJpZiZx
dW90Oztjb2xvcjpibGFjayI+Jm5ic3A7PG86cD48L286cD48L3NwYW4+PC9w Pg0KPHA+PHNwYW4g
c3R5bGU9ImZvbnQtc2l6ZToxMC4wcHQ7Zm9udC1mYW1pbHk6JnF1b3Q7QXJp YWwmcXVvdDssJnF1
b3Q7c2Fucy1zZXJpZiZxdW90Oztjb2xvcjpibGFjayI+Jm5ic3A7Jm5ic3A7 Jm5ic3A7Jm5ic3A7
Jm5ic3A7Q291bGQgdGhlIHBvcnQocykgYmUgYmxvY2tlZCAvIHJlc3RyaWN0 ZWQgYmV0d2VlbiB5
b3UgYW5kIHRoZSBzZXJ2ZXIgYW5kIGlzIFBvc3RncmVTUUwgU1NMIHN1cHBv cnQgZW5hYmxlZCAt
LQ0KPG86cD48L286cD48L3NwYW4+PC9wPg0KPHA+PHNwYW4gc3R5bGU9ImZv bnQtc2l6ZToxMC4w
cHQ7Zm9udC1mYW1pbHk6JnF1b3Q7QXJpYWwmcXVvdDssJnF1b3Q7c2Fucy1z ZXJpZiZxdW90Oztj
b2xvcjpibGFjayI+Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5i c3A7Jm5ic3A7DQo8
YSBocmVmPSJodHRwOi8vd3d3LnBvc3RncmVzcWwub3JnL2RvY3MvOS4wL3N0 YXRpYy9zc2wtdGNw
Lmh0bWwiPmh0dHA6Ly93d3cucG9zdGdyZXNxbC5vcmcvZG9jcy85LjAvc3Rh dGljL3NzbC10Y3Au
aHRtbDwvYT48bzpwPjwvbzpwPjwvc3Bhbj48L3A+DQo8cD48c3BhbiBzdHls ZT0iZm9udC1zaXpl
OjEwLjBwdDtmb250LWZhbWlseTomcXVvdDtBcmlhbCZxdW90OywmcXVvdDtz YW5zLXNlcmlmJnF1
b3Q7O2NvbG9yOmJsYWNrIj4mbmJzcDs8bzpwPjwvbzpwPjwvc3Bhbj48L3A+ DQo8cD48c3BhbiBz
dHlsZT0iZm9udC1zaXplOjEwLjBwdDtmb250LWZhbWlseTomcXVvdDtBcmlh bCZxdW90OywmcXVv
dDtzYW5zLXNlcmlmJnF1b3Q7O2NvbG9yOmJsYWNrIj4mbmJzcDsmbmJzcDsm bmJzcDsmbmJzcDsm
bmJzcDtKTVM8bzpwPjwvbzpwPjwvc3Bhbj48L3A+DQo8cD48c3BhbiBzdHls ZT0iZm9udC1zaXpl
OjEwLjBwdDtmb250LWZhbWlseTomcXVvdDtBcmlhbCZxdW90OywmcXVvdDtz YW5zLXNlcmlmJnF1
b3Q7O2NvbG9yOmJsYWNrIj4mbmJzcDs8bzpwPjwvbzpwPjwvc3Bhbj48L3A+ DQo8cD48c3BhbiBz
dHlsZT0iZm9udC1zaXplOjEwLjBwdDtmb250LWZhbWlseTomcXVvdDtBcmlh bCZxdW90OywmcXVv
dDtzYW5zLXNlcmlmJnF1b3Q7O2NvbG9yOmJsYWNrIj4mbmJzcDsmbmJzcDsm bmJzcDsmbmJzcDst
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLTxvOnA+PC9vOnA+ PC9zcGFuPjwvcD4N
CjxwPjxzcGFuIHN0eWxlPSJmb250LXNpemU6MTAuMHB0O2ZvbnQtZmFtaWx5 OiZxdW90O0FyaWFs
JnF1b3Q7LCZxdW90O3NhbnMtc2VyaWYmcXVvdDs7Y29sb3I6YmxhY2siPjxv OnA+Jm5ic3A7PC9v
OnA+PC9zcGFuPjwvcD4NCjxibG9ja3F1b3RlIHN0eWxlPSJib3JkZXI6bm9u ZTtib3JkZXItbGVm
dDpzb2xpZCBibHVlIDEuNXB0O3BhZGRpbmc6MGluIDBpbiAwaW4gNC4wcHQ7 bWFyZ2luLWxlZnQ6
MGluO21hcmdpbi10b3A6NS4wcHQ7bWFyZ2luLWJvdHRvbTo1LjBwdCI+DQo8 cCBjbGFzcz0iTXNv
Tm9ybWFsIj48c3BhbiBzdHlsZT0iZm9udC1zaXplOjEwLjBwdDtmb250LWZh bWlseTomcXVvdDtB
cmlhbCZxdW90OywmcXVvdDtzYW5zLXNlcmlmJnF1b3Q7O2NvbG9yOmJsYWNr Ij4tLS0tLU9yaWdp
bmFsIE1lc3NhZ2UtLS0tLQ0KPGJyPg0KRnJvbTogTWFyYyBGcm9tbSA8YnI+ DQpTZW50OiBNYXIg
MjksIDIwMTEgMTo1OCBQTSA8YnI+DQpUbzogJnF1b3Q7PGEgaHJlZj0ibWFp bHRvOnBnc3FsLW9k
YmNAcG9zdGdyZXNxbC5vcmciPnBnc3FsLW9kYmNAcG9zdGdyZXNxbC5vcmc8 L2E+JnF1b3Q7IDxi
cj4NClN1YmplY3Q6IFtPREJDXSBmaXJzdCB0aW1lIG9kYmMgPGJyPg0KPGJy Pg0KPGJyPg0KPG86
cD48L286cD48L3NwYW4+PC9wPg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PHNw YW4gc3R5bGU9ImNv
bG9yOmJsYWNrIj5CZWZvcmUgbGVhcm5pbmcgdGhlcmUgd2FzIGFuIG9kYmMg bGlzdCwgSSBzZW50
IHRoaXMgcG9zdCB0byB0aGUgYWRtaW4gbGlzdC48bzpwPjwvbzpwPjwvc3Bh bj48L3A+DQo8cCBj
bGFzcz0iTXNvTm9ybWFsIj48c3BhbiBzdHlsZT0iY29sb3I6YmxhY2siPiZu YnNwOzxvOnA+PC9v
OnA+PC9zcGFuPjwvcD4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiPjxzcGFuIHN0 eWxlPSJjb2xvcjpi
bGFjayI+SSBhbSBydW5uaW5nIHBvc3RncmVzIG9uIGEgcmVkIGhhdCBsaW51 eCBzZXJ2ZXIuPG86
cD48L286cD48L3NwYW4+PC9wPg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PHNw YW4gc3R5bGU9ImNv
bG9yOmJsYWNrIj5wb3N0Z3Jlc3FsLXB5dGhvbi04LjEuMjMtMS5lbDVfNi4x PG86cD48L286cD48
L3NwYW4+PC9wPg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PHNwYW4gc3R5bGU9 ImNvbG9yOmJsYWNr
Ij5wb3N0Z3Jlc3FsLXRlc3QtOC4xLjIzLTEuZWw1XzYuMTxvOnA+PC9vOnA+ PC9zcGFuPjwvcD4N
CjxwIGNsYXNzPSJNc29Ob3JtYWwiPjxzcGFuIHN0eWxlPSJjb2xvcjpibGFj ayI+cG9zdGdyZXNx
bC1saWJzLTguMS4yMy0xLmVsNV82LjE8bzpwPjwvbzpwPjwvc3Bhbj48L3A+ DQo8cCBjbGFzcz0i
TXNvTm9ybWFsIj48c3BhbiBzdHlsZT0iY29sb3I6YmxhY2siPnBvc3RncmVz cWwtZG9jcy04LjEu
MjMtMS5lbDVfNi4xPG86cD48L286cD48L3NwYW4+PC9wPg0KPHAgY2xhc3M9 Ik1zb05vcm1hbCI+
PHNwYW4gc3R5bGU9ImNvbG9yOmJsYWNrIj5wb3N0Z3Jlc3FsLWNvbnRyaWIt OC4xLjIzLTEuZWw1
XzYuMTxvOnA+PC9vOnA+PC9zcGFuPjwvcD4NCjxwIGNsYXNzPSJNc29Ob3Jt YWwiPjxzcGFuIHN0
eWxlPSJjb2xvcjpibGFjayI+cG9zdGdyZXNxbC04LjEuMjMtMS5lbDVfNi4x PG86cD48L286cD48
L3NwYW4+PC9wPg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PHNwYW4gc3R5bGU9 ImNvbG9yOmJsYWNr
Ij5wb3N0Z3Jlc3FsLXBsLTguMS4yMy0xLmVsNV82LjE8bzpwPjwvbzpwPjwv c3Bhbj48L3A+DQo8
cCBjbGFzcz0iTXNvTm9ybWFsIj48Yj48c3BhbiBzdHlsZT0iY29sb3I6Ymxh Y2siPnBvc3RncmVz
cWwtb2RiYy0wOC4wMS4wMjAwLTMuMTwvc3Bhbj48L2I+PHNwYW4gc3R5bGU9 ImNvbG9yOmJsYWNr
Ij48bzpwPjwvbzpwPjwvc3Bhbj48L3A+DQo8cCBjbGFzcz0iTXNvTm9ybWFs Ij48c3BhbiBzdHls
ZT0iY29sb3I6YmxhY2siPnBvc3RncmVzcWwtamRiYy04LjEuNDA3LTFqcHAu NDxvOnA+PC9vOnA+
PC9zcGFuPjwvcD4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiPjxzcGFuIHN0eWxl PSJjb2xvcjpibGFj
ayI+cG9zdGdyZXNxbC1zZXJ2ZXItOC4xLjIzLTEuZWw1XzYuMTxvOnA+PC9v OnA+PC9zcGFuPjwv
cD4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiPjxzcGFuIHN0eWxlPSJjb2xvcjpi bGFjayI+cG9zdGdy
ZXNxbC10Y2wtOC4xLjIzLTEuZWw1XzYuMTxvOnA+PC9vOnA+PC9zcGFuPjwv cD4NCjxwIGNsYXNz
PSJNc29Ob3JtYWwiPjxzcGFuIHN0eWxlPSJjb2xvcjpibGFjayI+Jm5ic3A7 PG86cD48L286cD48
L3NwYW4+PC9wPg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PHNwYW4gc3R5bGU9 ImNvbG9yOmJsYWNr
Ij5Vc2VyIG9uIHdpbmRvd3MgY29tcHV0ZXJzIHdvdWxkIGxpa2UgdG8gb2Ri YyB0byB0aGUgcG9z
dGdyZXMgZGF0YWJhc2VzLjxvOnA+PC9vOnA+PC9zcGFuPjwvcD4NCjxwIGNs YXNzPSJNc29Ob3Jt
YWwiPjxzcGFuIHN0eWxlPSJjb2xvcjpibGFjayI+SSBkb3dubG9hZGVkIHRo ZSB3aW5kb3dzIHBv
c3RncmVzIG9kYmMgZHJpdmVycyBmcm9tIHRoZSBmb2xsb3dpbmcgc2l0ZSBh bmQgaW5zdGFsbGVk
IHZlcnNpb24g4oCccHNxbG9kYmMtMDhfMDFfMDIwMOKAnSBvbiB0aGUgd2lu ZG93cyBjb21wdXRl
ci48bzpwPjwvbzpwPjwvc3Bhbj48L3A+DQo8cCBjbGFzcz0iTXNvTm9ybWFs Ij48c3BhbiBzdHls
ZT0iY29sb3I6YmxhY2siPjxhIGhyZWY9Imh0dHA6Ly9mdHA5LnVzLnBvc3Rn cmVzcWwub3JnL3B1
Yi9taXJyb3JzL3Bvc3RncmVzcWwvb2RiYy92ZXJzaW9ucy9tc2kvIiB0YXJn ZXQ9Il9ibGFuayI+
aHR0cDovL2Z0cDkudXMucG9zdGdyZXNxbC5vcmcvcHViL21pcnJvcnMvcG9z dGdyZXNxbC9vZGJj
L3ZlcnNpb25zL21zaS88L2E+PG86cD48L286cD48L3NwYW4+PC9wPg0KPHAg Y2xhc3M9Ik1zb05v
cm1hbCI+PHNwYW4gc3R5bGU9ImNvbG9yOmJsYWNrIj4mbmJzcDs8bzpwPjwv bzpwPjwvc3Bhbj48
L3A+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj48c3BhbiBzdHlsZT0iY29sb3I6 YmxhY2siPldoZW4g
SSBjb25maWd1cmUgYSDigJxGaWxlIERhdGEgU291cmNl4oCdIGNvbm5lY3Rp b24gaW4gYWNjZXNz
LCBJIGNhbm5vdCBjb25uZWN0IHRvIHRoZSBwb3N0Z3Jlc3FsIGRhdGFiYXNl LiBJIGdldCB0aGUg
bWVzc2FnZSwg4oCcQSBjb25uZWN0aW9uIGNvdWxkIG5vdCBiZSBtYWRlIHVz aW5nIHRoZSBmaWxl
IGRhdGEgc291cmNlIHBhcmFtZXRlcnMgZW50ZXJlZC4gU2F2ZSBub24tdmVy aWZpZWQNCiBmaWxl
IERTTj/igJ08bzpwPjwvbzpwPjwvc3Bhbj48L3A+DQo8cCBjbGFzcz0iTXNv Tm9ybWFsIj48c3Bh
biBzdHlsZT0iY29sb3I6YmxhY2siPlRoZSBwYXJhbWV0ZXJzIGVudGVyZWQg YXJlOjxvOnA+PC9v
OnA+PC9zcGFuPjwvcD4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiPjxzcGFuIHN0 eWxlPSJjb2xvcjpi
bGFjayI+RGF0YWJhc2U6IGRhdGFiYXNlX25hbWU8bzpwPjwvbzpwPjwvc3Bh bj48L3A+DQo8cCBj
bGFzcz0iTXNvTm9ybWFsIj48c3BhbiBzdHlsZT0iY29sb3I6YmxhY2siPlNl cnZlcjogSSBlbnRl
cmVkIHRoZSBJUCBhZGRyZXNzIG9mIHRoZSBzZXJ2ZXI8bzpwPjwvbzpwPjwv c3Bhbj48L3A+DQo8
cCBjbGFzcz0iTXNvTm9ybWFsIj48c3BhbiBzdHlsZT0iY29sb3I6YmxhY2si PlVzZXIgTmFtZTog
SSBlbnRlcmVkIHBvc3RncmVzPG86cD48L286cD48L3NwYW4+PC9wPg0KPHAg Y2xhc3M9Ik1zb05v
cm1hbCI+PHNwYW4gc3R5bGU9ImNvbG9yOmJsYWNrIj5QYXNzd29yZDo8bzpw PjwvbzpwPjwvc3Bh
bj48L3A+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj48c3BhbiBzdHlsZT0iY29s b3I6YmxhY2siPlNT
TCBNb2RlOiBwcmVmZXI8bzpwPjwvbzpwPjwvc3Bhbj48L3A+DQo8cCBjbGFz cz0iTXNvTm9ybWFs
Ij48c3BhbiBzdHlsZT0iY29sb3I6YmxhY2siPlBvcnQ6IDU0MzIgKHdoaWNo IGlzIHRoZSBwb3J0
IHVzZWQgYnkgcG9zdGdyZXMpPG86cD48L286cD48L3NwYW4+PC9wPg0KPHAg Y2xhc3M9Ik1zb05v
cm1hbCI+PHNwYW4gc3R5bGU9ImNvbG9yOmJsYWNrIj4mbmJzcDs8bzpwPjwv bzpwPjwvc3Bhbj48
L3A+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj48c3BhbiBzdHlsZT0iY29sb3I6 YmxhY2siPkRvIEkg
bmVlZCB0byBjb25maWd1cmUgdGhlIC9ldGMvb2RiYy5pbmkgZmlsZT8gSXQg aXMgY3VycmVudGx5
IGp1c3QgYSBibGFuayBmaWxlLjxvOnA+PC9vOnA+PC9zcGFuPjwvcD4NCjxw IGNsYXNzPSJNc29O
b3JtYWwiPjxzcGFuIHN0eWxlPSJjb2xvcjpibGFjayI+Jm5ic3A7PG86cD48 L286cD48L3NwYW4+
PC9wPg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PHNwYW4gc3R5bGU9ImNvbG9y OmJsYWNrIj5UaGFu
a3MgZm9yIGFueSBoZWxwLjxvOnA+PC9vOnA+PC9zcGFuPjwvcD4NCjxwIGNs YXNzPSJNc29Ob3Jt
YWwiPjxzcGFuIHN0eWxlPSJjb2xvcjpibGFjayI+Jm5ic3A7PG86cD48L286 cD48L3NwYW4+PC9w
Pg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PHNwYW4gc3R5bGU9ImZvbnQtc2l6 ZToxMC4wcHQ7Zm9u
dC1mYW1pbHk6JnF1b3Q7Q291cmllciBOZXcmcXVvdDs7Y29sb3I6YmxhY2si Pk1hcmM8L3NwYW4+
PHNwYW4gc3R5bGU9ImNvbG9yOmJsYWNrIj48bzpwPjwvbzpwPjwvc3Bhbj48 L3A+DQo8L2Jsb2Nr
cXVvdGU+DQo8L2Rpdj4NCjwvYm9keT4NCjwvaHRtbD4NCg==

--_000_93361C67E4EE844A80935863A4FF4B6C04E60CC8Exch2010MB2un iv_--

Re: first time odbc

am 29.03.2011 22:09:34 von Rod

On 29/03/2011 20:27, jsilberberg@mindspring.com wrote:
> http://www.postgresql.org/docs/9.0/static/auth-pg-hba-conf.h tml
>

I think you get a different message if the problem is in pg_hba.conf -
IIRC there's a specific reference to that file in the message. This
sounds to me more like a firewall problem.

Ray.



--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie

--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Re: first time odbc

am 29.03.2011 22:16:17 von Jan-Peter.Seifert

Hello,

most likely you'll have to set listen_addresses in postgresql.conf
correctly as well ( see link ). Don't forget to remove the # ;)

Good luck,

Peter

Am 29.03.2011 21:27, schrieb jsilberberg@mindspring.com:
> =20
>=20
> http://www.postgresql.org/docs/9.0/static/auth-pg-hba-conf.h tml
>=20
> =20
>=20
>=20
> -----Original Message-----
> From: Marc Fromm
> Sent: Mar 29, 2011 3:01 PM
> To: "jsilberberg@mindspring.com"
> Cc: "pgsql-odbc@postgresql.org"
> Subject: RE: [ODBC] first time odbc
>=20
> I updated the windows postgresql odbc drivers and now I get the mes=
sage:
>=20
> No connection could be made because the target machine actively
> refused it.
>=20
> =20
>=20
> This sounds like something needs to be configured on the server to
> allow the odbc connection.
>=20
> =20
>=20
> *From:* jsilberberg@mindspring.com [mailto:jsilberberg@mindspring.c=
om]
> *Sent:* Tuesday, March 29, 2011 11:13 AM
> *To:* Marc Fromm; pgsql-odbc@postgresql.org
> *Subject:* Re: [ODBC] first time odbc
>=20
> =20
>=20
> =20
>=20
> Why,
>=20
> =20
>=20
> That's a vintage 02-Feb-2006 driver.
>=20
> =20
>=20
> I use 8.04 from Dec-2009 and even that's getting a little
> stale. Why not try the 9.n drivers.
>=20
> =20
>=20
> Could the port(s) be blocked / restricted between you and the
> server and is PostgreSQL SSL support enabled --
>=20
> http://www.postgresql.org/docs/9.0/static/ssl-tcp.html
>=20
> =20
>=20
> JMS
>=20
> =20
>=20
> -----------------------------------
>=20
> =20
>=20
> -----Original Message-----
> From: Marc Fromm
> Sent: Mar 29, 2011 1:58 PM
> To: "pgsql-odbc@postgresql.org g>"
> Subject: [ODBC] first time odbc
>=20
>=20
> Before learning there was an odbc list, I sent this post to the
> admin list.
>=20
> =20
>=20
> I am running postgres on a red hat linux server.
>=20
> postgresql-python-8.1.23-1.el5_6.1
>=20
> postgresql-test-8.1.23-1.el5_6.1
>=20
> postgresql-libs-8.1.23-1.el5_6.1
>=20
> postgresql-docs-8.1.23-1.el5_6.1
>=20
> postgresql-contrib-8.1.23-1.el5_6.1
>=20
> postgresql-8.1.23-1.el5_6.1
>=20
> postgresql-pl-8.1.23-1.el5_6.1
>=20
> *postgresql-odbc-08.01.0200-3.1*
>=20
> postgresql-jdbc-8.1.407-1jpp.4
>=20
> postgresql-server-8.1.23-1.el5_6.1
>=20
> postgresql-tcl-8.1.23-1.el5_6.1
>=20
> =20
>=20
> User on windows computers would like to odbc to the postgres
> databases.
>=20
> I downloaded the windows postgres odbc drivers from the
> following site and installed version â€=9Cpsqlodbc-08_01_02=
00â€=9D on
> the windows computer.
>=20
> http://ftp9.us.postgresql.org/pub/mirrors/postgresql/odbc/ve rsi=
ons/msi/
>=20
> =20
>=20
> When I configure a â€=9CFile Data Sourceâ€=9D connectio=
n in access, I
> cannot connect to the postgresql database. I get the message, =E2=
€œA
> connection could not be made using the file data source
> parameters entered. Save non-verified file DSN?â€=9D
>=20
> The parameters entered are:
>=20
> Database: database_name
>=20
> Server: I entered the IP address of the server
>=20
> User Name: I entered postgres
>=20
> Password:
>=20
> SSL Mode: prefer
>=20
> Port: 5432 (which is the port used by postgres)
>=20
> =20
>=20
> Do I need to configure the /etc/odbc.ini file? It is currently
> just a blank file.
>=20
> =20
>=20
> Thanks for any help.
>=20
> =20
>=20
> Marc
>=20

--=20
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Re: first time odbc

am 29.03.2011 22:21:44 von Marc Fromm

--_000_93361C67E4EE844A80935863A4FF4B6C04E60D02Exch2010MB2un iv_
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: base64

QnkgZWRpdGluZyBwb3N0Z3Jlc3FsLmNvbmYgYW5kIGNoYW5naW5nIGxpc3Rl bl9hZGRyZXNzID0g
4oCYKuKAmSBhbmQgZWRpdGluZyBwZ19oYmEuY29uZiBhbmQgYWRkaW5nIGhv c3QgYWxsIGFsbCBt
eS5pcC5hZGRyZXNzIGFsbG93ZWQgbWUgdG8gY29ubmVjdCB0byB0aGUgcG9z dGdyZXNxbCBkYXRh
IGJhc2Ugd2l0aCBNaWNyb3NvZnQgYWNjZXNzLg0KDQpJbiBhY2Nlc3MgSSBj YW4gc2VlIHRoZSB0
YWJsZSBhbmQgaXQgZmllbGRzLCBidXQgaWYgSSB0cnkgdG8gdXNlIHRoZSB0 YWJsZSBpbiBhIHF1
ZXJyeSBvciB2aWV3IHRoZSB0YWJsZSBJIGdldCBhbiBlcnJvcjogcGVybWlz c2lvbiBkZW5pZWQg
Zm9yIHJlbGF0aW9uIHN1bW1lcl9maW5haWQ7IGVycm9yIHdoaWxlIGV4ZWN1 dGluZyB0aGUgcXVl
cnkgKCM3KQ0KDQpBbnkgaWRlYXM/DQoNCkFsc28gaW4gdGhlIHBvc3RncmVz cWwgaW5zdGVhZCBv
ZiBsaXN0ZW5fYWRkcmVzcz3igJkq4oCZIEkgdHJpZWQgbGlzdGVuX2FkZHJl c3M94oCZbG9jYWxo
b3N0LCBteS5pcC5hZGRyZXNz4oCZIGJ1dCB0aGF0IGZhaWxlZCB0byB3b3Jr Lg0KSG93IGNhbiBJ
IGtlZXAgbG9jYWwgaG9zdCBhbmQgb25seSBhbGxvdyBzcGVjaWZpYyBhZGRy ZXNzPyBJIGRvbuKA
mXQgd2FudCB0byBvcGVuIGl0IHVwIHRvIGFsbCB3aXRoIOKAmCrigJkNCg0K VGhhbmtzDQoNCg0K
RnJvbToganNpbGJlcmJlcmdAbWluZHNwcmluZy5jb20gW21haWx0bzpqc2ls YmVyYmVyZ0BtaW5k
c3ByaW5nLmNvbV0NClNlbnQ6IFR1ZXNkYXksIE1hcmNoIDI5LCAyMDExIDEx OjEzIEFNDQpUbzog
TWFyYyBGcm9tbTsgcGdzcWwtb2RiY0Bwb3N0Z3Jlc3FsLm9yZw0KU3ViamVj dDogUmU6IFtPREJD
XSBmaXJzdCB0aW1lIG9kYmMNCg0KDQoNCg0KV2h5LA0KDQoNCg0KICAgIFRo YXQncyBhIHZpbnRh
Z2UgMDItRmViLTIwMDYgZHJpdmVyLg0KDQoNCg0KICAgICBJIHVzZSA4LjA0 IGZyb20gRGVjLTIw
MDkgYW5kIGV2ZW4gdGhhdCdzIGdldHRpbmcgYSBsaXR0bGUgc3RhbGUuICBX aHkgbm90IHRyeSB0
aGUgOS5uIGRyaXZlcnMuDQoNCg0KDQogICAgIENvdWxkIHRoZSBwb3J0KHMp IGJlIGJsb2NrZWQg
LyByZXN0cmljdGVkIGJldHdlZW4geW91IGFuZCB0aGUgc2VydmVyIGFuZCBp cyBQb3N0Z3JlU1FM
IFNTTCBzdXBwb3J0IGVuYWJsZWQgLS0NCg0KICAgICAgICBodHRwOi8vd3d3 LnBvc3RncmVzcWwu
b3JnL2RvY3MvOS4wL3N0YXRpYy9zc2wtdGNwLmh0bWwNCg0KDQoNCiAgICAg Sk1TDQoNCg0KDQog
ICAgLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCg0KDQot LS0tLU9yaWdpbmFs
IE1lc3NhZ2UtLS0tLQ0KRnJvbTogTWFyYyBGcm9tbQ0KU2VudDogTWFyIDI5 LCAyMDExIDE6NTgg
UE0NClRvOiAicGdzcWwtb2RiY0Bwb3N0Z3Jlc3FsLm9yZzxtYWlsdG86cGdz cWwtb2RiY0Bwb3N0
Z3Jlc3FsLm9yZz4iDQpTdWJqZWN0OiBbT0RCQ10gZmlyc3QgdGltZSBvZGJj DQoNCg0KQmVmb3Jl
IGxlYXJuaW5nIHRoZXJlIHdhcyBhbiBvZGJjIGxpc3QsIEkgc2VudCB0aGlz IHBvc3QgdG8gdGhl
IGFkbWluIGxpc3QuDQoNCkkgYW0gcnVubmluZyBwb3N0Z3JlcyBvbiBhIHJl ZCBoYXQgbGludXgg
c2VydmVyLg0KcG9zdGdyZXNxbC1weXRob24tOC4xLjIzLTEuZWw1XzYuMQ0K cG9zdGdyZXNxbC10
ZXN0LTguMS4yMy0xLmVsNV82LjENCnBvc3RncmVzcWwtbGlicy04LjEuMjMt MS5lbDVfNi4xDQpw
b3N0Z3Jlc3FsLWRvY3MtOC4xLjIzLTEuZWw1XzYuMQ0KcG9zdGdyZXNxbC1j b250cmliLTguMS4y
My0xLmVsNV82LjENCnBvc3RncmVzcWwtOC4xLjIzLTEuZWw1XzYuMQ0KcG9z dGdyZXNxbC1wbC04
LjEuMjMtMS5lbDVfNi4xDQpwb3N0Z3Jlc3FsLW9kYmMtMDguMDEuMDIwMC0z LjENCnBvc3RncmVz
cWwtamRiYy04LjEuNDA3LTFqcHAuNA0KcG9zdGdyZXNxbC1zZXJ2ZXItOC4x LjIzLTEuZWw1XzYu
MQ0KcG9zdGdyZXNxbC10Y2wtOC4xLjIzLTEuZWw1XzYuMQ0KDQpVc2VyIG9u IHdpbmRvd3MgY29t
cHV0ZXJzIHdvdWxkIGxpa2UgdG8gb2RiYyB0byB0aGUgcG9zdGdyZXMgZGF0 YWJhc2VzLg0KSSBk
b3dubG9hZGVkIHRoZSB3aW5kb3dzIHBvc3RncmVzIG9kYmMgZHJpdmVycyBm cm9tIHRoZSBmb2xs
b3dpbmcgc2l0ZSBhbmQgaW5zdGFsbGVkIHZlcnNpb24g4oCccHNxbG9kYmMt MDhfMDFfMDIwMOKA
nSBvbiB0aGUgd2luZG93cyBjb21wdXRlci4NCmh0dHA6Ly9mdHA5LnVzLnBv c3RncmVzcWwub3Jn
L3B1Yi9taXJyb3JzL3Bvc3RncmVzcWwvb2RiYy92ZXJzaW9ucy9tc2kvDQoN CldoZW4gSSBjb25m
aWd1cmUgYSDigJxGaWxlIERhdGEgU291cmNl4oCdIGNvbm5lY3Rpb24gaW4g YWNjZXNzLCBJIGNh
bm5vdCBjb25uZWN0IHRvIHRoZSBwb3N0Z3Jlc3FsIGRhdGFiYXNlLiBJIGdl dCB0aGUgbWVzc2Fn
ZSwg4oCcQSBjb25uZWN0aW9uIGNvdWxkIG5vdCBiZSBtYWRlIHVzaW5nIHRo ZSBmaWxlIGRhdGEg
c291cmNlIHBhcmFtZXRlcnMgZW50ZXJlZC4gU2F2ZSBub24tdmVyaWZpZWQg ZmlsZSBEU04/4oCd
DQpUaGUgcGFyYW1ldGVycyBlbnRlcmVkIGFyZToNCkRhdGFiYXNlOiBkYXRh YmFzZV9uYW1lDQpT
ZXJ2ZXI6IEkgZW50ZXJlZCB0aGUgSVAgYWRkcmVzcyBvZiB0aGUgc2VydmVy DQpVc2VyIE5hbWU6
IEkgZW50ZXJlZCBwb3N0Z3Jlcw0KUGFzc3dvcmQ6DQpTU0wgTW9kZTogcHJl ZmVyDQpQb3J0OiA1
NDMyICh3aGljaCBpcyB0aGUgcG9ydCB1c2VkIGJ5IHBvc3RncmVzKQ0KDQpE byBJIG5lZWQgdG8g
Y29uZmlndXJlIHRoZSAvZXRjL29kYmMuaW5pIGZpbGU/IEl0IGlzIGN1cnJl bnRseSBqdXN0IGEg
YmxhbmsgZmlsZS4NCg0KVGhhbmtzIGZvciBhbnkgaGVscC4NCg0KTWFyYw0K

--_000_93361C67E4EE844A80935863A4FF4B6C04E60D02Exch2010MB2un iv_
Content-Type: text/html; charset="utf-8"
Content-Transfer-Encoding: base64

PGh0bWwgeG1sbnM6dj0idXJuOnNjaGVtYXMtbWljcm9zb2Z0LWNvbTp2bWwi IHhtbG5zOm89InVy
bjpzY2hlbWFzLW1pY3Jvc29mdC1jb206b2ZmaWNlOm9mZmljZSIgeG1sbnM6 dz0idXJuOnNjaGVt
YXMtbWljcm9zb2Z0LWNvbTpvZmZpY2U6d29yZCIgeG1sbnM6bT0iaHR0cDov L3NjaGVtYXMubWlj
cm9zb2Z0LmNvbS9vZmZpY2UvMjAwNC8xMi9vbW1sIiB4bWxucz0iaHR0cDov L3d3dy53My5vcmcv
VFIvUkVDLWh0bWw0MCI+DQo8aGVhZD4NCjxtZXRhIGh0dHAtZXF1aXY9IkNv bnRlbnQtVHlwZSIg
Y29udGVudD0idGV4dC9odG1sOyBjaGFyc2V0PXV0Zi04Ij4NCjxtZXRhIG5h bWU9IkdlbmVyYXRv
ciIgY29udGVudD0iTWljcm9zb2Z0IFdvcmQgMTQgKGZpbHRlcmVkIG1lZGl1 bSkiPg0KPHN0eWxl
PjwhLS0NCi8qIEZvbnQgRGVmaW5pdGlvbnMgKi8NCkBmb250LWZhY2UNCgl7 Zm9udC1mYW1pbHk6
Q2FsaWJyaTsNCglwYW5vc2UtMToyIDE1IDUgMiAyIDIgNCAzIDIgNDt9DQpA Zm9udC1mYWNlDQoJ
e2ZvbnQtZmFtaWx5OlRhaG9tYTsNCglwYW5vc2UtMToyIDExIDYgNCAzIDUg NCA0IDIgNDt9DQov
KiBTdHlsZSBEZWZpbml0aW9ucyAqLw0KcC5Nc29Ob3JtYWwsIGxpLk1zb05v cm1hbCwgZGl2Lk1z
b05vcm1hbA0KCXttYXJnaW46MGluOw0KCW1hcmdpbi1ib3R0b206LjAwMDFw dDsNCglmb250LXNp
emU6MTEuMHB0Ow0KCWZvbnQtZmFtaWx5OiJDYWxpYnJpIiwic2Fucy1zZXJp ZiI7fQ0KYTpsaW5r
LCBzcGFuLk1zb0h5cGVybGluaw0KCXttc28tc3R5bGUtcHJpb3JpdHk6OTk7 DQoJY29sb3I6Ymx1
ZTsNCgl0ZXh0LWRlY29yYXRpb246dW5kZXJsaW5lO30NCmE6dmlzaXRlZCwg c3Bhbi5Nc29IeXBl
cmxpbmtGb2xsb3dlZA0KCXttc28tc3R5bGUtcHJpb3JpdHk6OTk7DQoJY29s b3I6cHVycGxlOw0K
CXRleHQtZGVjb3JhdGlvbjp1bmRlcmxpbmU7fQ0KcA0KCXttc28tc3R5bGUt cHJpb3JpdHk6OTk7
DQoJbWFyZ2luOjBpbjsNCgltYXJnaW4tYm90dG9tOi4wMDAxcHQ7DQoJZm9u dC1zaXplOjEyLjBw
dDsNCglmb250LWZhbWlseToiVGltZXMgTmV3IFJvbWFuIiwic2VyaWYiO30N CnNwYW4uRW1haWxT
dHlsZTE4DQoJe21zby1zdHlsZS10eXBlOnBlcnNvbmFsOw0KCWZvbnQtZmFt aWx5OiJDYWxpYnJp
Iiwic2Fucy1zZXJpZiI7DQoJY29sb3I6d2luZG93dGV4dDt9DQpzcGFuLkVt YWlsU3R5bGUxOQ0K
CXttc28tc3R5bGUtdHlwZTpwZXJzb25hbC1yZXBseTsNCglmb250LWZhbWls eToiQ2FsaWJyaSIs
InNhbnMtc2VyaWYiOw0KCWNvbG9yOiMxRjQ5N0Q7fQ0KLk1zb0NocERlZmF1 bHQNCgl7bXNvLXN0
eWxlLXR5cGU6ZXhwb3J0LW9ubHk7DQoJZm9udC1zaXplOjEwLjBwdDt9DQpA cGFnZSBXb3JkU2Vj
dGlvbjENCgl7c2l6ZTo4LjVpbiAxMS4waW47DQoJbWFyZ2luOjEuMGluIDEu MGluIDEuMGluIDEu
MGluO30NCmRpdi5Xb3JkU2VjdGlvbjENCgl7cGFnZTpXb3JkU2VjdGlvbjE7 fQ0KLS0+PC9zdHls
ZT48IS0tW2lmIGd0ZSBtc28gOV0+PHhtbD4NCjxvOnNoYXBlZGVmYXVsdHMg djpleHQ9ImVkaXQi
IHNwaWRtYXg9IjEwMjYiIC8+DQo8L3htbD48IVtlbmRpZl0tLT48IS0tW2lm IGd0ZSBtc28gOV0+
PHhtbD4NCjxvOnNoYXBlbGF5b3V0IHY6ZXh0PSJlZGl0Ij4NCjxvOmlkbWFw IHY6ZXh0PSJlZGl0
IiBkYXRhPSIxIiAvPg0KPC9vOnNoYXBlbGF5b3V0PjwveG1sPjwhW2VuZGlm XS0tPg0KPC9oZWFk
Pg0KPGJvZHkgYmdjb2xvcj0id2hpdGUiIGxhbmc9IkVOLVVTIiBsaW5rPSJi bHVlIiB2bGluaz0i
cHVycGxlIj4NCjxkaXYgY2xhc3M9IldvcmRTZWN0aW9uMSI+DQo8cCBjbGFz cz0iTXNvTm9ybWFs
Ij48c3BhbiBzdHlsZT0iY29sb3I6IzFGNDk3RCI+QnkgZWRpdGluZyBwb3N0 Z3Jlc3FsLmNvbmYg
YW5kIGNoYW5naW5nIGxpc3Rlbl9hZGRyZXNzID0g4oCYKuKAmSBhbmQgZWRp dGluZyBwZ19oYmEu
Y29uZiBhbmQgYWRkaW5nIGhvc3QgYWxsIGFsbCBteS5pcC5hZGRyZXNzIGFs bG93ZWQgbWUgdG8g
Y29ubmVjdCB0byB0aGUgcG9zdGdyZXNxbCBkYXRhIGJhc2Ugd2l0aCBNaWNy b3NvZnQgYWNjZXNz
Lg0KPG86cD48L286cD48L3NwYW4+PC9wPg0KPHAgY2xhc3M9Ik1zb05vcm1h bCI+PHNwYW4gc3R5
bGU9ImNvbG9yOiMxRjQ5N0QiPjxvOnA+Jm5ic3A7PC9vOnA+PC9zcGFuPjwv cD4NCjxwIGNsYXNz
PSJNc29Ob3JtYWwiPjxzcGFuIHN0eWxlPSJjb2xvcjojMUY0OTdEIj5JbiBh Y2Nlc3MgSSBjYW4g
c2VlIHRoZSB0YWJsZSBhbmQgaXQgZmllbGRzLCBidXQgaWYgSSB0cnkgdG8g dXNlIHRoZSB0YWJs
ZSBpbiBhIHF1ZXJyeSBvciB2aWV3IHRoZSB0YWJsZSBJIGdldCBhbiBlcnJv cjogcGVybWlzc2lv
biBkZW5pZWQgZm9yIHJlbGF0aW9uIHN1bW1lcl9maW5haWQ7IGVycm9yIHdo aWxlIGV4ZWN1dGlu
ZyB0aGUgcXVlcnkgKCM3KTxvOnA+PC9vOnA+PC9zcGFuPjwvcD4NCjxwIGNs YXNzPSJNc29Ob3Jt
YWwiPjxzcGFuIHN0eWxlPSJjb2xvcjojMUY0OTdEIj48bzpwPiZuYnNwOzwv bzpwPjwvc3Bhbj48
L3A+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj48c3BhbiBzdHlsZT0iY29sb3I6 IzFGNDk3RCI+QW55
IGlkZWFzPzxvOnA+PC9vOnA+PC9zcGFuPjwvcD4NCjxwIGNsYXNzPSJNc29O b3JtYWwiPjxzcGFu
IHN0eWxlPSJjb2xvcjojMUY0OTdEIj48bzpwPiZuYnNwOzwvbzpwPjwvc3Bh bj48L3A+DQo8cCBj
bGFzcz0iTXNvTm9ybWFsIj48c3BhbiBzdHlsZT0iY29sb3I6IzFGNDk3RCI+ QWxzbyBpbiB0aGUg
cG9zdGdyZXNxbCBpbnN0ZWFkIG9mIGxpc3Rlbl9hZGRyZXNzPeKAmSrigJkg SSB0cmllZCBsaXN0
ZW5fYWRkcmVzcz3igJlsb2NhbGhvc3QsIG15LmlwLmFkZHJlc3PigJkgYnV0 IHRoYXQgZmFpbGVk
IHRvIHdvcmsuPG86cD48L286cD48L3NwYW4+PC9wPg0KPHAgY2xhc3M9Ik1z b05vcm1hbCI+PHNw
YW4gc3R5bGU9ImNvbG9yOiMxRjQ5N0QiPkhvdyBjYW4gSSBrZWVwIGxvY2Fs IGhvc3QgYW5kIG9u
bHkgYWxsb3cgc3BlY2lmaWMgYWRkcmVzcz8gSSBkb27igJl0IHdhbnQgdG8g b3BlbiBpdCB1cCB0
byBhbGwgd2l0aCDigJgq4oCZPG86cD48L286cD48L3NwYW4+PC9wPg0KPHAg Y2xhc3M9Ik1zb05v
cm1hbCI+PHNwYW4gc3R5bGU9ImNvbG9yOiMxRjQ5N0QiPjxvOnA+Jm5ic3A7 PC9vOnA+PC9zcGFu
PjwvcD4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiPjxzcGFuIHN0eWxlPSJjb2xv cjojMUY0OTdEIj5U
aGFua3M8bzpwPjwvbzpwPjwvc3Bhbj48L3A+DQo8cCBjbGFzcz0iTXNvTm9y bWFsIj48c3BhbiBz
dHlsZT0iY29sb3I6IzFGNDk3RCI+PG86cD4mbmJzcDs8L286cD48L3NwYW4+ PC9wPg0KPHAgY2xh
c3M9Ik1zb05vcm1hbCI+PHNwYW4gc3R5bGU9ImNvbG9yOiMxRjQ5N0QiPjxv OnA+Jm5ic3A7PC9v
OnA+PC9zcGFuPjwvcD4NCjxkaXY+DQo8ZGl2IHN0eWxlPSJib3JkZXI6bm9u ZTtib3JkZXItdG9w
OnNvbGlkICNCNUM0REYgMS4wcHQ7cGFkZGluZzozLjBwdCAwaW4gMGluIDBp biI+DQo8cCBjbGFz
cz0iTXNvTm9ybWFsIj48Yj48c3BhbiBzdHlsZT0iZm9udC1zaXplOjEwLjBw dDtmb250LWZhbWls
eTomcXVvdDtUYWhvbWEmcXVvdDssJnF1b3Q7c2Fucy1zZXJpZiZxdW90OyI+ RnJvbTo8L3NwYW4+
PC9iPjxzcGFuIHN0eWxlPSJmb250LXNpemU6MTAuMHB0O2ZvbnQtZmFtaWx5 OiZxdW90O1RhaG9t
YSZxdW90OywmcXVvdDtzYW5zLXNlcmlmJnF1b3Q7Ij4ganNpbGJlcmJlcmdA bWluZHNwcmluZy5j
b20gW21haWx0bzpqc2lsYmVyYmVyZ0BtaW5kc3ByaW5nLmNvbV0NCjxicj4N CjxiPlNlbnQ6PC9i
PiBUdWVzZGF5LCBNYXJjaCAyOSwgMjAxMSAxMToxMyBBTTxicj4NCjxiPlRv OjwvYj4gTWFyYyBG
cm9tbTsgcGdzcWwtb2RiY0Bwb3N0Z3Jlc3FsLm9yZzxicj4NCjxiPlN1Ympl Y3Q6PC9iPiBSZTog
W09EQkNdIGZpcnN0IHRpbWUgb2RiYzxvOnA+PC9vOnA+PC9zcGFuPjwvcD4N CjwvZGl2Pg0KPC9k
aXY+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj48bzpwPiZuYnNwOzwvbzpwPjwv cD4NCjxwPjxzcGFu
IHN0eWxlPSJmb250LXNpemU6MTAuMHB0O2ZvbnQtZmFtaWx5OiZxdW90O0Fy aWFsJnF1b3Q7LCZx
dW90O3NhbnMtc2VyaWYmcXVvdDs7Y29sb3I6YmxhY2siPiZuYnNwOzxvOnA+ PC9vOnA+PC9zcGFu
PjwvcD4NCjxwPjxzcGFuIHN0eWxlPSJmb250LXNpemU6MTAuMHB0O2ZvbnQt ZmFtaWx5OiZxdW90
O0FyaWFsJnF1b3Q7LCZxdW90O3NhbnMtc2VyaWYmcXVvdDs7Y29sb3I6Ymxh Y2siPldoeSwNCjxv
OnA+PC9vOnA+PC9zcGFuPjwvcD4NCjxwPjxzcGFuIHN0eWxlPSJmb250LXNp emU6MTAuMHB0O2Zv
bnQtZmFtaWx5OiZxdW90O0FyaWFsJnF1b3Q7LCZxdW90O3NhbnMtc2VyaWYm cXVvdDs7Y29sb3I6
YmxhY2siPiZuYnNwOzxvOnA+PC9vOnA+PC9zcGFuPjwvcD4NCjxwPjxzcGFu IHN0eWxlPSJmb250
LXNpemU6MTAuMHB0O2ZvbnQtZmFtaWx5OiZxdW90O0FyaWFsJnF1b3Q7LCZx dW90O3NhbnMtc2Vy
aWYmcXVvdDs7Y29sb3I6YmxhY2siPiZuYnNwOyZuYnNwOyZuYnNwOyBUaGF0 J3MgYSB2aW50YWdl
IDAyLUZlYi0yMDA2IGRyaXZlci48bzpwPjwvbzpwPjwvc3Bhbj48L3A+DQo8 cD48c3BhbiBzdHls
ZT0iZm9udC1zaXplOjEwLjBwdDtmb250LWZhbWlseTomcXVvdDtBcmlhbCZx dW90OywmcXVvdDtz
YW5zLXNlcmlmJnF1b3Q7O2NvbG9yOmJsYWNrIj4mbmJzcDs8bzpwPjwvbzpw Pjwvc3Bhbj48L3A+
DQo8cD48c3BhbiBzdHlsZT0iZm9udC1zaXplOjEwLjBwdDtmb250LWZhbWls eTomcXVvdDtBcmlh
bCZxdW90OywmcXVvdDtzYW5zLXNlcmlmJnF1b3Q7O2NvbG9yOmJsYWNrIj4m bmJzcDsmbmJzcDsm
bmJzcDsmbmJzcDsgSSB1c2UgOC4wNCBmcm9tIERlYy0yMDA5IGFuZCBldmVu IHRoYXQncyBnZXR0
aW5nIGEgbGl0dGxlIHN0YWxlLiZuYnNwOyBXaHkgbm90IHRyeSB0aGUgOS5u IGRyaXZlcnMuPG86
cD48L286cD48L3NwYW4+PC9wPg0KPHA+PHNwYW4gc3R5bGU9ImZvbnQtc2l6 ZToxMC4wcHQ7Zm9u
dC1mYW1pbHk6JnF1b3Q7QXJpYWwmcXVvdDssJnF1b3Q7c2Fucy1zZXJpZiZx dW90Oztjb2xvcjpi
bGFjayI+Jm5ic3A7PG86cD48L286cD48L3NwYW4+PC9wPg0KPHA+PHNwYW4g c3R5bGU9ImZvbnQt
c2l6ZToxMC4wcHQ7Zm9udC1mYW1pbHk6JnF1b3Q7QXJpYWwmcXVvdDssJnF1 b3Q7c2Fucy1zZXJp
ZiZxdW90Oztjb2xvcjpibGFjayI+Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7 Jm5ic3A7Q291bGQg
dGhlIHBvcnQocykgYmUgYmxvY2tlZCAvIHJlc3RyaWN0ZWQgYmV0d2VlbiB5 b3UgYW5kIHRoZSBz
ZXJ2ZXIgYW5kIGlzIFBvc3RncmVTUUwgU1NMIHN1cHBvcnQgZW5hYmxlZCAt LQ0KPG86cD48L286
cD48L3NwYW4+PC9wPg0KPHA+PHNwYW4gc3R5bGU9ImZvbnQtc2l6ZToxMC4w cHQ7Zm9udC1mYW1p
bHk6JnF1b3Q7QXJpYWwmcXVvdDssJnF1b3Q7c2Fucy1zZXJpZiZxdW90Oztj b2xvcjpibGFjayI+
Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7DQo8 YSBocmVmPSJodHRw
Oi8vd3d3LnBvc3RncmVzcWwub3JnL2RvY3MvOS4wL3N0YXRpYy9zc2wtdGNw Lmh0bWwiPmh0dHA6
Ly93d3cucG9zdGdyZXNxbC5vcmcvZG9jcy85LjAvc3RhdGljL3NzbC10Y3Au aHRtbDwvYT48bzpw
PjwvbzpwPjwvc3Bhbj48L3A+DQo8cD48c3BhbiBzdHlsZT0iZm9udC1zaXpl OjEwLjBwdDtmb250
LWZhbWlseTomcXVvdDtBcmlhbCZxdW90OywmcXVvdDtzYW5zLXNlcmlmJnF1 b3Q7O2NvbG9yOmJs
YWNrIj4mbmJzcDs8bzpwPjwvbzpwPjwvc3Bhbj48L3A+DQo8cD48c3BhbiBz dHlsZT0iZm9udC1z
aXplOjEwLjBwdDtmb250LWZhbWlseTomcXVvdDtBcmlhbCZxdW90OywmcXVv dDtzYW5zLXNlcmlm
JnF1b3Q7O2NvbG9yOmJsYWNrIj4mbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsm bmJzcDtKTVM8bzpw
PjwvbzpwPjwvc3Bhbj48L3A+DQo8cD48c3BhbiBzdHlsZT0iZm9udC1zaXpl OjEwLjBwdDtmb250
LWZhbWlseTomcXVvdDtBcmlhbCZxdW90OywmcXVvdDtzYW5zLXNlcmlmJnF1 b3Q7O2NvbG9yOmJs
YWNrIj4mbmJzcDs8bzpwPjwvbzpwPjwvc3Bhbj48L3A+DQo8cD48c3BhbiBz dHlsZT0iZm9udC1z
aXplOjEwLjBwdDtmb250LWZhbWlseTomcXVvdDtBcmlhbCZxdW90OywmcXVv dDtzYW5zLXNlcmlm
JnF1b3Q7O2NvbG9yOmJsYWNrIj4mbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDst LS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLTxvOnA+PC9vOnA+PC9zcGFuPjwvcD4N CjxwPjxzcGFuIHN0
eWxlPSJmb250LXNpemU6MTAuMHB0O2ZvbnQtZmFtaWx5OiZxdW90O0FyaWFs JnF1b3Q7LCZxdW90
O3NhbnMtc2VyaWYmcXVvdDs7Y29sb3I6YmxhY2siPjxvOnA+Jm5ic3A7PC9v OnA+PC9zcGFuPjwv
cD4NCjxibG9ja3F1b3RlIHN0eWxlPSJib3JkZXI6bm9uZTtib3JkZXItbGVm dDpzb2xpZCBibHVl
IDEuNXB0O3BhZGRpbmc6MGluIDBpbiAwaW4gNC4wcHQ7bWFyZ2luLWxlZnQ6 MGluO21hcmdpbi10
b3A6NS4wcHQ7bWFyZ2luLWJvdHRvbTo1LjBwdCI+DQo8cCBjbGFzcz0iTXNv Tm9ybWFsIj48c3Bh
biBzdHlsZT0iZm9udC1zaXplOjEwLjBwdDtmb250LWZhbWlseTomcXVvdDtB cmlhbCZxdW90Oywm
cXVvdDtzYW5zLXNlcmlmJnF1b3Q7O2NvbG9yOmJsYWNrIj4tLS0tLU9yaWdp bmFsIE1lc3NhZ2Ut
LS0tLQ0KPGJyPg0KRnJvbTogTWFyYyBGcm9tbSA8YnI+DQpTZW50OiBNYXIg MjksIDIwMTEgMTo1
OCBQTSA8YnI+DQpUbzogJnF1b3Q7PGEgaHJlZj0ibWFpbHRvOnBnc3FsLW9k YmNAcG9zdGdyZXNx
bC5vcmciPnBnc3FsLW9kYmNAcG9zdGdyZXNxbC5vcmc8L2E+JnF1b3Q7IDxi cj4NClN1YmplY3Q6
IFtPREJDXSBmaXJzdCB0aW1lIG9kYmMgPGJyPg0KPGJyPg0KPGJyPg0KPG86 cD48L286cD48L3Nw
YW4+PC9wPg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PHNwYW4gc3R5bGU9ImNv bG9yOmJsYWNrIj5C
ZWZvcmUgbGVhcm5pbmcgdGhlcmUgd2FzIGFuIG9kYmMgbGlzdCwgSSBzZW50 IHRoaXMgcG9zdCB0
byB0aGUgYWRtaW4gbGlzdC48bzpwPjwvbzpwPjwvc3Bhbj48L3A+DQo8cCBj bGFzcz0iTXNvTm9y
bWFsIj48c3BhbiBzdHlsZT0iY29sb3I6YmxhY2siPiZuYnNwOzxvOnA+PC9v OnA+PC9zcGFuPjwv
cD4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiPjxzcGFuIHN0eWxlPSJjb2xvcjpi bGFjayI+SSBhbSBy
dW5uaW5nIHBvc3RncmVzIG9uIGEgcmVkIGhhdCBsaW51eCBzZXJ2ZXIuPG86 cD48L286cD48L3Nw
YW4+PC9wPg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PHNwYW4gc3R5bGU9ImNv bG9yOmJsYWNrIj5w
b3N0Z3Jlc3FsLXB5dGhvbi04LjEuMjMtMS5lbDVfNi4xPG86cD48L286cD48 L3NwYW4+PC9wPg0K
PHAgY2xhc3M9Ik1zb05vcm1hbCI+PHNwYW4gc3R5bGU9ImNvbG9yOmJsYWNr Ij5wb3N0Z3Jlc3Fs
LXRlc3QtOC4xLjIzLTEuZWw1XzYuMTxvOnA+PC9vOnA+PC9zcGFuPjwvcD4N CjxwIGNsYXNzPSJN
c29Ob3JtYWwiPjxzcGFuIHN0eWxlPSJjb2xvcjpibGFjayI+cG9zdGdyZXNx bC1saWJzLTguMS4y
My0xLmVsNV82LjE8bzpwPjwvbzpwPjwvc3Bhbj48L3A+DQo8cCBjbGFzcz0i TXNvTm9ybWFsIj48
c3BhbiBzdHlsZT0iY29sb3I6YmxhY2siPnBvc3RncmVzcWwtZG9jcy04LjEu MjMtMS5lbDVfNi4x
PG86cD48L286cD48L3NwYW4+PC9wPg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+ PHNwYW4gc3R5bGU9
ImNvbG9yOmJsYWNrIj5wb3N0Z3Jlc3FsLWNvbnRyaWItOC4xLjIzLTEuZWw1 XzYuMTxvOnA+PC9v
OnA+PC9zcGFuPjwvcD4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiPjxzcGFuIHN0 eWxlPSJjb2xvcjpi
bGFjayI+cG9zdGdyZXNxbC04LjEuMjMtMS5lbDVfNi4xPG86cD48L286cD48 L3NwYW4+PC9wPg0K
PHAgY2xhc3M9Ik1zb05vcm1hbCI+PHNwYW4gc3R5bGU9ImNvbG9yOmJsYWNr Ij5wb3N0Z3Jlc3Fs
LXBsLTguMS4yMy0xLmVsNV82LjE8bzpwPjwvbzpwPjwvc3Bhbj48L3A+DQo8 cCBjbGFzcz0iTXNv
Tm9ybWFsIj48Yj48c3BhbiBzdHlsZT0iY29sb3I6YmxhY2siPnBvc3RncmVz cWwtb2RiYy0wOC4w
MS4wMjAwLTMuMTwvc3Bhbj48L2I+PHNwYW4gc3R5bGU9ImNvbG9yOmJsYWNr Ij48bzpwPjwvbzpw
Pjwvc3Bhbj48L3A+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj48c3BhbiBzdHls ZT0iY29sb3I6Ymxh
Y2siPnBvc3RncmVzcWwtamRiYy04LjEuNDA3LTFqcHAuNDxvOnA+PC9vOnA+ PC9zcGFuPjwvcD4N
CjxwIGNsYXNzPSJNc29Ob3JtYWwiPjxzcGFuIHN0eWxlPSJjb2xvcjpibGFj ayI+cG9zdGdyZXNx
bC1zZXJ2ZXItOC4xLjIzLTEuZWw1XzYuMTxvOnA+PC9vOnA+PC9zcGFuPjwv cD4NCjxwIGNsYXNz
PSJNc29Ob3JtYWwiPjxzcGFuIHN0eWxlPSJjb2xvcjpibGFjayI+cG9zdGdy ZXNxbC10Y2wtOC4x
LjIzLTEuZWw1XzYuMTxvOnA+PC9vOnA+PC9zcGFuPjwvcD4NCjxwIGNsYXNz PSJNc29Ob3JtYWwi
PjxzcGFuIHN0eWxlPSJjb2xvcjpibGFjayI+Jm5ic3A7PG86cD48L286cD48 L3NwYW4+PC9wPg0K
PHAgY2xhc3M9Ik1zb05vcm1hbCI+PHNwYW4gc3R5bGU9ImNvbG9yOmJsYWNr Ij5Vc2VyIG9uIHdp
bmRvd3MgY29tcHV0ZXJzIHdvdWxkIGxpa2UgdG8gb2RiYyB0byB0aGUgcG9z dGdyZXMgZGF0YWJh
c2VzLjxvOnA+PC9vOnA+PC9zcGFuPjwvcD4NCjxwIGNsYXNzPSJNc29Ob3Jt YWwiPjxzcGFuIHN0
eWxlPSJjb2xvcjpibGFjayI+SSBkb3dubG9hZGVkIHRoZSB3aW5kb3dzIHBv c3RncmVzIG9kYmMg
ZHJpdmVycyBmcm9tIHRoZSBmb2xsb3dpbmcgc2l0ZSBhbmQgaW5zdGFsbGVk IHZlcnNpb24g4oCc
cHNxbG9kYmMtMDhfMDFfMDIwMOKAnSBvbiB0aGUgd2luZG93cyBjb21wdXRl ci48bzpwPjwvbzpw
Pjwvc3Bhbj48L3A+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj48c3BhbiBzdHls ZT0iY29sb3I6Ymxh
Y2siPjxhIGhyZWY9Imh0dHA6Ly9mdHA5LnVzLnBvc3RncmVzcWwub3JnL3B1 Yi9taXJyb3JzL3Bv
c3RncmVzcWwvb2RiYy92ZXJzaW9ucy9tc2kvIiB0YXJnZXQ9Il9ibGFuayI+ aHR0cDovL2Z0cDku
dXMucG9zdGdyZXNxbC5vcmcvcHViL21pcnJvcnMvcG9zdGdyZXNxbC9vZGJj L3ZlcnNpb25zL21z
aS88L2E+PG86cD48L286cD48L3NwYW4+PC9wPg0KPHAgY2xhc3M9Ik1zb05v cm1hbCI+PHNwYW4g
c3R5bGU9ImNvbG9yOmJsYWNrIj4mbmJzcDs8bzpwPjwvbzpwPjwvc3Bhbj48 L3A+DQo8cCBjbGFz
cz0iTXNvTm9ybWFsIj48c3BhbiBzdHlsZT0iY29sb3I6YmxhY2siPldoZW4g SSBjb25maWd1cmUg
YSDigJxGaWxlIERhdGEgU291cmNl4oCdIGNvbm5lY3Rpb24gaW4gYWNjZXNz LCBJIGNhbm5vdCBj
b25uZWN0IHRvIHRoZSBwb3N0Z3Jlc3FsIGRhdGFiYXNlLiBJIGdldCB0aGUg bWVzc2FnZSwg4oCc
QSBjb25uZWN0aW9uIGNvdWxkIG5vdCBiZSBtYWRlIHVzaW5nIHRoZSBmaWxl IGRhdGEgc291cmNl
IHBhcmFtZXRlcnMgZW50ZXJlZC4gU2F2ZSBub24tdmVyaWZpZWQNCiBmaWxl IERTTj/igJ08bzpw
PjwvbzpwPjwvc3Bhbj48L3A+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj48c3Bh biBzdHlsZT0iY29s
b3I6YmxhY2siPlRoZSBwYXJhbWV0ZXJzIGVudGVyZWQgYXJlOjxvOnA+PC9v OnA+PC9zcGFuPjwv
cD4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiPjxzcGFuIHN0eWxlPSJjb2xvcjpi bGFjayI+RGF0YWJh
c2U6IGRhdGFiYXNlX25hbWU8bzpwPjwvbzpwPjwvc3Bhbj48L3A+DQo8cCBj bGFzcz0iTXNvTm9y
bWFsIj48c3BhbiBzdHlsZT0iY29sb3I6YmxhY2siPlNlcnZlcjogSSBlbnRl cmVkIHRoZSBJUCBh
ZGRyZXNzIG9mIHRoZSBzZXJ2ZXI8bzpwPjwvbzpwPjwvc3Bhbj48L3A+DQo8 cCBjbGFzcz0iTXNv
Tm9ybWFsIj48c3BhbiBzdHlsZT0iY29sb3I6YmxhY2siPlVzZXIgTmFtZTog SSBlbnRlcmVkIHBv
c3RncmVzPG86cD48L286cD48L3NwYW4+PC9wPg0KPHAgY2xhc3M9Ik1zb05v cm1hbCI+PHNwYW4g
c3R5bGU9ImNvbG9yOmJsYWNrIj5QYXNzd29yZDo8bzpwPjwvbzpwPjwvc3Bh bj48L3A+DQo8cCBj
bGFzcz0iTXNvTm9ybWFsIj48c3BhbiBzdHlsZT0iY29sb3I6YmxhY2siPlNT TCBNb2RlOiBwcmVm
ZXI8bzpwPjwvbzpwPjwvc3Bhbj48L3A+DQo8cCBjbGFzcz0iTXNvTm9ybWFs Ij48c3BhbiBzdHls
ZT0iY29sb3I6YmxhY2siPlBvcnQ6IDU0MzIgKHdoaWNoIGlzIHRoZSBwb3J0 IHVzZWQgYnkgcG9z
dGdyZXMpPG86cD48L286cD48L3NwYW4+PC9wPg0KPHAgY2xhc3M9Ik1zb05v cm1hbCI+PHNwYW4g
c3R5bGU9ImNvbG9yOmJsYWNrIj4mbmJzcDs8bzpwPjwvbzpwPjwvc3Bhbj48 L3A+DQo8cCBjbGFz
cz0iTXNvTm9ybWFsIj48c3BhbiBzdHlsZT0iY29sb3I6YmxhY2siPkRvIEkg bmVlZCB0byBjb25m
aWd1cmUgdGhlIC9ldGMvb2RiYy5pbmkgZmlsZT8gSXQgaXMgY3VycmVudGx5 IGp1c3QgYSBibGFu
ayBmaWxlLjxvOnA+PC9vOnA+PC9zcGFuPjwvcD4NCjxwIGNsYXNzPSJNc29O b3JtYWwiPjxzcGFu
IHN0eWxlPSJjb2xvcjpibGFjayI+Jm5ic3A7PG86cD48L286cD48L3NwYW4+ PC9wPg0KPHAgY2xh
c3M9Ik1zb05vcm1hbCI+PHNwYW4gc3R5bGU9ImNvbG9yOmJsYWNrIj5UaGFu a3MgZm9yIGFueSBo
ZWxwLjxvOnA+PC9vOnA+PC9zcGFuPjwvcD4NCjxwIGNsYXNzPSJNc29Ob3Jt YWwiPjxzcGFuIHN0
eWxlPSJjb2xvcjpibGFjayI+Jm5ic3A7PG86cD48L286cD48L3NwYW4+PC9w Pg0KPHAgY2xhc3M9
Ik1zb05vcm1hbCI+PHNwYW4gc3R5bGU9ImZvbnQtc2l6ZToxMC4wcHQ7Zm9u dC1mYW1pbHk6JnF1
b3Q7Q291cmllciBOZXcmcXVvdDs7Y29sb3I6YmxhY2siPk1hcmM8L3NwYW4+ PHNwYW4gc3R5bGU9
ImNvbG9yOmJsYWNrIj48bzpwPjwvbzpwPjwvc3Bhbj48L3A+DQo8L2Jsb2Nr cXVvdGU+DQo8L2Rp
dj4NCjwvYm9keT4NCjwvaHRtbD4NCg==

--_000_93361C67E4EE844A80935863A4FF4B6C04E60D02Exch2010MB2un iv_--

Re: first time odbc

am 30.03.2011 00:05:35 von Jeff Silberberg






T> 


ef=3D"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
T>


 =
;




GIN-LEFT: 0px">-----Original Message-----
From: Marc Fromm WWU.EDU>
Sent: Mar 29, 2011 3:01 PM
To: "jsilberberg@mindspring.com"=

Cc: "pgsql-odbc@postgresql.org" C@POSTGRESQL.ORG>
Subject: RE: [ODBC] first time odbc

SPACE PREFIX =3D [default] http://www.w3.org/TR/REC-html40 NS =3D "http://w=
ww.w3.org/TR/REC-html40" /> 0" xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" xmlns:w=3D"=
urn:schemas-microsoft-com:office:word" xmlns:o=3D"urn:schemas-microsoft-com=
:office:office" xmlns:v=3D"urn:schemas-microsoft-com:vml"> content=3D"text/html; charset=3Dutf-8" http-equiv=3D"Content-Type"> a content=3D"Microsoft Word 14 (filtered medium)" name=3D"Generator">

spidmax=3D"1026" v:ext=3D"edit"> !--[if 9] mso gte> " data=3D"1">
ody lang=3DEN-US vlink=3D"purple" link=3D"blue" bgcolor=3D"white">

I updated the windows p=
ostgresql odbc drivers and now I get the message:


No connection could be =
made because the target machine actively refused it.


  >


This sounds like someth=
ing needs to be configured on the server to allow the odbc connection.=


  >



-BOTTOM: 0in; PADDING-LEFT: 0in; PADDING-RIGHT: 0in; BORDER-TOP: #b5c4df 1p=
t solid; BORDER-RIGHT: medium none; PADDING-TOP: 3pt">

FONT-SIZE: 10pt">From: -serif'; FONT-SIZE: 10pt"> jsilberberg@mindspring.com [mailto:jsilberberg@m=
indspring.com]
Sent: Tuesday, March 29, 2011 11:13 AM
To:<=
/B> Marc Fromm; pgsql-odbc@postgresql.org
Subject: Re: [ODBC] fir=
st time odbc


 


E: 10pt"> 


E: 10pt">Why,


E: 10pt"> 


E: 10pt">    That's a vintage 02-Feb-2006 driver.=


E: 10pt"> 


E: 10pt">     I use 8.04 from Dec-2009 and even that's =
getting a little stale.  Why not try the 9.n drivers. >


E: 10pt"> 


E: 10pt">     Could the port(s) be blocked / restr=
icted between you and the server and is PostgreSQL SSL support enabled -- <=
o:p>


E: 10pt">        ostgresql.org/docs/9.0/static/ssl-tcp.html" target=3D_blank>http://www.post=
gresql.org/docs/9.0/static/ssl-tcp.html


E: 10pt"> 


E: 10pt">     JMS


E: 10pt"> 


E: 10pt">    ----------------------------------- o:p>


E: 10pt"> 


lid; PADDING-BOTTOM: 0in; MARGIN-TOP: 5pt; PADDING-LEFT: 4pt; PADDING-RIGHT=
: 0in; MARGIN-BOTTOM: 5pt; MARGIN-LEFT: 0in; BORDER-TOP: medium none; BORDE=
R-RIGHT: medium none; PADDING-TOP: 0in">

R: black; FONT-SIZE: 10pt">-----Original Message-----
From: Marc Fromm =

Sent: Mar 29, 2011 1:58 PM
To: " esql.org" target=3D_blank>pgsql-odbc@postgresql.org"
Subject: [ODBC=
] first time odbc



Before learning there was=
an odbc list, I sent this post to the admin list.


 <=
/P>

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.el=
5_6.1


postgresql-odbc-08.01.=
0200-3.1


postgresql-jdbc-8.1.407-1=
jpp.4


postgresql-server-8.1.23-=
1.el5_6.1


postgresql-tcl-8.1.23-1.e=
l5_6.1


 <=
/P>

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 â€=
=9Cpsqlodbc-08_01_0200â€=9D on the windows computer.
<=
/P>

..postgresql.org/pub/mirrors/postgresql/odbc/versions/msi/" target=3D_blank>=
http://ftp9.us.postgresql.org/pub/mirrors/postgresql/odbc/ve rsions/msi/
=


 <=
/P>

When I configure a â€=
=9CFile Data Sourceâ€=9D connection in access, I cannot connect to the =
postgresql database. I get the message, â€=9CA connection could not be =
made using the file data source parameters entered. Save non-verified file =
DSN?â€=9D


The parameters entered ar=
e:


Database: database_name :p>


Server: I entered the IP =
address of the server


User Name: I entered post=
gres


Password: N>


SSL Mode: prefer p>


Port: 5432 (which is the =
port used by postgres)


 <=
/P>

Do I need to configure th=
e /etc/odbc.ini file? It is currently just a blank file.
<=
/P>

 <=
/P>

Thanks for any help.=


 <=
/P>

k; FONT-SIZE: 10pt">Marc AN>

=

Re: first time odbc

am 30.03.2011 00:05:35 von Jeff Silberberg






T> 


Why, =


T> 


 =
;   That's a vintage 02-Feb-2006 driver.


T> 


 =
;    I use 8.04 from Dec-2009 and even that's getting a litt=
le stale.  Why not try the 9.n drivers.


T> 


 =
;    Could the port(s) be blocked / restricted between =
you and the server and is PostgreSQL SSL support enabled --
<=
/FONT>


 =
;       docs/9.0/static/ssl-tcp.html">http://www.postgresql.org/docs /9.0/static/ssl=
-tcp.html


 


     JMS


T> 


 =
;   -----------------------------------




GIN-LEFT: 0px">-----Original Message-----
From: Marc Fromm WWU.EDU>
Sent: Mar 29, 2011 1:58 PM
To: "pgsql-odbc@postgresql.org" =

Subject: [ODBC] first time odbc

L:NAMESPACE PREFIX =3D [default] http://www.w3.org/TR/REC-html40 NS =3D "ht=
tp://www.w3.org/TR/REC-html40" /> -html40" xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" xmlns=
:w=3D"urn:schemas-microsoft-com:office:word" xmlns:o=3D"urn:schemas-microso=
ft-com:office:office" xmlns:v=3D"urn:schemas-microsoft-com:vml"> ZZmeta content=3D"text/html; charset=3Dus-ascii" http-equiv=3D"Content-Type=
"> r">

spidmax=3D"1026" v:ext=3D"edit"> !--[if 9] mso gte> " data=3D"1">
ody lang=3DEN-US vlink=3D"purple" link=3D"blue">

Before learning there was an odbc list, I sent this po=
st to the admin list.


 


I am running postgres on a red hat linux server.<=
/o:p>


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 po=
stgres databases.


I downloaded the windows postgres odbc drivers from th=
e following site and installed version â€=9Cpsqlodbc-08_01_0200â€=
=9D on the windows computer.


ostgresql/odbc/versions/msi/" target=3D_blank>http://ftp9.us.postgresql.org=
/pub/mirrors/postgresql/odbc/versions/msi/


 


When I configure a â€=9CFile Data Sourceâ€=9D =
connection in access, I cannot connect to the postgresql database. I get th=
e message, â€=9CA connection could not be made using the file data sour=
ce parameters entered. Save non-verified file DSN?â€=9D


The parameters entered are:


Database: database_name


Server: I entered the IP address of the server :p>


User Name: I entered postgres


Password:


SSL Mode: prefer


Port: 5432 (which is the port used by postgres) o:p>


 


Do I need to configure the /etc/odbc.ini file? It is c=
urrently just a blank file.


 


Thanks for any help.


 


10pt">Marc

Z![endif]--> ODY>

Re: first time odbc

am 30.03.2011 06:18:06 von Frank Finner

Is the user you connect with allowed to see / modify data?=20

Maybe it would be a good idea to increase the log level on the server
and look in the logs, what happens. This can be done at runtime, no
need to stop the database.

Regards,
Frank.

On Tue, 29 Mar 2011 20:21:44 +0000 Marc Fromm
wrote:

> By editing postgresql.conf and changing listen_address =3D â€=98*=E2=
€™ and
> editing pg_hba.conf and adding host all all my.ip.address allowed me
> to connect to the postgresql data base with Microsoft access.
>=20
> In access I can see the table and it fields, but if I try to use the
> table in a querry or view the table I get an error: permission denied
> for relation summer_finaid; error while executing the query (#7)
>=20
> Any ideas?
>=20
> Also in the postgresql instead of listen_address=’*â€=99 I =
tried
> listen_address=’localhost, my.ip.addressâ€=99 but that fail=
ed to work.
> How can I keep local host and only allow specific address? I donâ€=99t
> want to open it up to all with â€=98*â€=99
>=20
> Thanks
>=20
>=20
> From: jsilberberg@mindspring.com [mailto:jsilberberg@mindspring.com]
> Sent: Tuesday, March 29, 2011 11:13 AM
> To: Marc Fromm; pgsql-odbc@postgresql.org
> Subject: Re: [ODBC] first time odbc
>=20
>=20
>=20
>=20
> Why,
>=20
>=20
>=20
> That's a vintage 02-Feb-2006 driver.
>=20
>=20
>=20
> I use 8.04 from Dec-2009 and even that's getting a little
> stale. Why not try the 9.n drivers.
>=20
>=20
>=20
> Could the port(s) be blocked / restricted between you and the
> server and is PostgreSQL SSL support enabled --
>=20
> http://www.postgresql.org/docs/9.0/static/ssl-tcp.html
>=20
>=20
>=20
> JMS
>=20
>=20
>=20
> -----------------------------------
>=20
>=20
> -----Original Message-----
> From: Marc Fromm
> Sent: Mar 29, 2011 1:58 PM
> To: "pgsql-odbc@postgresql.org"
> Subject: [ODBC] first time odbc
>=20
>=20
> Before learning there was an odbc list, I sent this post to the admin
> list.
>=20
> 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
>=20
> 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 â€=9Cpsqlodbc-08_01_0200â€=
=9D on the
> windows computer.
> http://ftp9.us.postgresql.org/pub/mirrors/postgresql/odbc/ve rsions/msi/
>=20
> When I configure a â€=9CFile Data Sourceâ€=9D connection in acces=
s, I cannot
> connect to the postgresql database. I get the message, â€=9CA connect=
ion
> could not be made using the file data source parameters entered. Save
> non-verified file DSN?â€=9D 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)
>=20
> Do I need to configure the /etc/odbc.ini file? It is currently just a
> blank file.
>=20
> Thanks for any help.
>=20
> Marc



--=20
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Re: first time odbc

am 30.03.2011 11:44:03 von Rod

On 29/03/2011 21:21, Marc Fromm wrote:
> By editing postgresql.conf and changing listen_address =3D â€=98*=E2=
€™ and editing
> pg_hba.conf and adding host all all my.ip.address allowed me to connect
> to the postgresql data base with Microsoft access.
>
> In access I can see the table and it fields, but if I try to use the
> table in a querry or view the table I get an error: permission denied
> for relation summer_finaid; error while executing the query (#7)

You need to grant permission on the table to the user:


GRANT SELECT ON summer_finaid TO [insert your user here];

See the docs here:

http://www.postgresql.org/docs/9.0/static/sql-grant.html

> Also in the postgresql instead of listen_address=’*â€=99 =
I tried
> listen_address=’localhost, my.ip.addressâ€=99 but that fa=
iled to work.
>
> How can I keep local host and only allow specific address? I donâ€=99=
t want
> to open it up to all with â€=98*â€=99

listen_addresses specifies the interfaces on which Postgres *listens*,=20
not the remote hosts which can connect - that's done in pg_hba.conf.

Ray.



--=20
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie

--=20
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Re: first time odbc

am 30.03.2011 16:54:45 von Marc Fromm

SSBvbmx5IHdhbnQgdGhlIHVzZXJzIHRvIHJlYWQgZGF0YSwgdGh1cyBJIHJl
bW92ZWQgc3VwZXJ1c2VyIGFuZCBhcHBsaWVkIGdyYW50IHNlbGVjdC4gDQoN
CklmIHRoZSBsaXN0ZW5fYWRkcmVzcyBpcyBub3QgYSBjbGllbnQgZmlsdGVy
LCB3b3VsZCBpdCBzdGlsbCBiZSBiZXR0ZXIgdG8gb25seSBoYXZlIGl0IGxp
c3RlbiB0byBsb2NhbGhvc3QgYW5kIHRoZSBmZXcgaXAgYWRkcmVzc2VzIHRo
YXQgd2lsbCBuZWVkIHRvIG9kYmMgdG8gdGhlIHBvc3RncmVzIGRhdGFiYXNl
PyBJcyBpdCBqdXN0IG5vdCBwb3NzaWJsZSB0byBhc3NpZ24gbGlzdGVuX2Fk
ZHJlc3MgPSAnbG9jYWxob3N0LCAxLmlwLmFkZHJlc3MsIDIuaXAuYWRkcmVz
cyc/DQoNCk9uZSBvdGhlciB0aGluZyBzdGlsbCwgaWYgaW4gdGhlIHBnX2hi
YS5jb25mIGZpbGUgSSBkbyBub3QgaW5jbHVkZSBhbnkgaXAgYWRkcmVzc2Vz
IEkgY2Fubm90IGNvbm5lY3QgdG8gdGhlIGRhdGFiYXNlLiBJZiBJIGVudGVy
IGp1c3Qgb25lIGlwIGFkZHJlc3MsIGFueSBjb21wdXRlciBjYW4gY29ubmVj
dCB0byB0aGUgZGF0YWJhc2UsIGV2ZW4gdGhvdWdoIHNvbWUgbWFjaGluZXMg
aGF2ZSBzdGF0aWMgaXAgYWRkcmVzc2VzIGFuZCBvdGhlcnMgaGF2ZSBkaGNw
IGFkZHJlc3MgZnJvbSBhIGNvbXBsZXRlbHkgZGlmZmVyZW50IHN1Ym5ldC4g
RG8geW91IGtub3cgd2h5IHRoaXMgaXM/IEkgZmlndXJlZCB0aGUgcGdfaGJh
LmNvbmYgZmlsZSBjb250cm9sbGVkIGFjY2VzcyBieSBpcCBhZGRyZXNzLCBi
YXNlZCBvbiBvdGhlciBnb29nbGVkIGFydGljbGVzLg0KDQpUaGFua3MNCg0K
LS0tLS1PcmlnaW5hbCBNZXNzYWdlLS0tLS0NCkZyb206IHBnc3FsLW9kYmMt
b3duZXJAcG9zdGdyZXNxbC5vcmcgW21haWx0bzpwZ3NxbC1vZGJjLW93bmVy
QHBvc3RncmVzcWwub3JnXSBPbiBCZWhhbGYgT2YgRnJhbmsgRmlubmVyDQpT
ZW50OiBUdWVzZGF5LCBNYXJjaCAyOSwgMjAxMSA5OjE4IFBNDQpUbzogcGdz
cWwtb2RiY0Bwb3N0Z3Jlc3FsLm9yZw0KU3ViamVjdDogUmU6IFtPREJDXSBm
aXJzdCB0aW1lIG9kYmMNCg0KSXMgdGhlIHVzZXIgeW91IGNvbm5lY3Qgd2l0
aCBhbGxvd2VkIHRvIHNlZSAvIG1vZGlmeSBkYXRhPyANCg0KTWF5YmUgaXQg
d291bGQgYmUgYSBnb29kIGlkZWEgdG8gaW5jcmVhc2UgdGhlIGxvZyBsZXZl
bCBvbiB0aGUgc2VydmVyIGFuZCBsb29rIGluIHRoZSBsb2dzLCB3aGF0IGhh
cHBlbnMuIFRoaXMgY2FuIGJlIGRvbmUgYXQgcnVudGltZSwgbm8gbmVlZCB0
byBzdG9wIHRoZSBkYXRhYmFzZS4NCg0KUmVnYXJkcywNCkZyYW5rLg0KDQpP
biBUdWUsIDI5IE1hciAyMDExIDIwOjIxOjQ0ICswMDAwIE1hcmMgRnJvbW0g
PE1hcmMuRnJvbW1Ad3d1LmVkdT4NCndyb3RlOg0KDQo+IEJ5IGVkaXRpbmcg
cG9zdGdyZXNxbC5jb25mIGFuZCBjaGFuZ2luZyBsaXN0ZW5fYWRkcmVzcyA9
IOKAmCrigJkgYW5kIA0KPiBlZGl0aW5nIHBnX2hiYS5jb25mIGFuZCBhZGRp
bmcgaG9zdCBhbGwgYWxsIG15LmlwLmFkZHJlc3MgYWxsb3dlZCBtZSANCj4g
dG8gY29ubmVjdCB0byB0aGUgcG9zdGdyZXNxbCBkYXRhIGJhc2Ugd2l0aCBN
aWNyb3NvZnQgYWNjZXNzLg0KPiANCj4gSW4gYWNjZXNzIEkgY2FuIHNlZSB0
aGUgdGFibGUgYW5kIGl0IGZpZWxkcywgYnV0IGlmIEkgdHJ5IHRvIHVzZSB0
aGUgDQo+IHRhYmxlIGluIGEgcXVlcnJ5IG9yIHZpZXcgdGhlIHRhYmxlIEkg
Z2V0IGFuIGVycm9yOiBwZXJtaXNzaW9uIGRlbmllZCANCj4gZm9yIHJlbGF0
aW9uIHN1bW1lcl9maW5haWQ7IGVycm9yIHdoaWxlIGV4ZWN1dGluZyB0aGUg
cXVlcnkgKCM3KQ0KPiANCj4gQW55IGlkZWFzPw0KPiANCj4gQWxzbyBpbiB0
aGUgcG9zdGdyZXNxbCBpbnN0ZWFkIG9mIGxpc3Rlbl9hZGRyZXNzPeKAmSri
gJkgSSB0cmllZCANCj4gbGlzdGVuX2FkZHJlc3M94oCZbG9jYWxob3N0LCBt
eS5pcC5hZGRyZXNz4oCZIGJ1dCB0aGF0IGZhaWxlZCB0byB3b3JrLg0KPiBI
b3cgY2FuIEkga2VlcCBsb2NhbCBob3N0IGFuZCBvbmx5IGFsbG93IHNwZWNp
ZmljIGFkZHJlc3M/IEkgZG9u4oCZdCANCj4gd2FudCB0byBvcGVuIGl0IHVw
IHRvIGFsbCB3aXRoIOKAmCrigJkNCj4gDQo+IFRoYW5rcw0KPiANCj4gDQo+
IEZyb206IGpzaWxiZXJiZXJnQG1pbmRzcHJpbmcuY29tIFttYWlsdG86anNp
bGJlcmJlcmdAbWluZHNwcmluZy5jb21dDQo+IFNlbnQ6IFR1ZXNkYXksIE1h
cmNoIDI5LCAyMDExIDExOjEzIEFNDQo+IFRvOiBNYXJjIEZyb21tOyBwZ3Nx
bC1vZGJjQHBvc3RncmVzcWwub3JnDQo+IFN1YmplY3Q6IFJlOiBbT0RCQ10g
Zmlyc3QgdGltZSBvZGJjDQo+IA0KPiANCj4gDQo+IA0KPiBXaHksDQo+IA0K
PiANCj4gDQo+ICAgICBUaGF0J3MgYSB2aW50YWdlIDAyLUZlYi0yMDA2IGRy
aXZlci4NCj4gDQo+IA0KPiANCj4gICAgICBJIHVzZSA4LjA0IGZyb20gRGVj
LTIwMDkgYW5kIGV2ZW4gdGhhdCdzIGdldHRpbmcgYSBsaXR0bGUgc3RhbGUu
ICANCj4gV2h5IG5vdCB0cnkgdGhlIDkubiBkcml2ZXJzLg0KPiANCj4gDQo+
IA0KPiAgICAgIENvdWxkIHRoZSBwb3J0KHMpIGJlIGJsb2NrZWQgLyByZXN0
cmljdGVkIGJldHdlZW4geW91IGFuZCB0aGUgDQo+IHNlcnZlciBhbmQgaXMg
UG9zdGdyZVNRTCBTU0wgc3VwcG9ydCBlbmFibGVkIC0tDQo+IA0KPiAgICAg
ICAgIGh0dHA6Ly93d3cucG9zdGdyZXNxbC5vcmcvZG9jcy85LjAvc3RhdGlj
L3NzbC10Y3AuaHRtbA0KPiANCj4gDQo+IA0KPiAgICAgIEpNUw0KPiANCj4g
DQo+IA0KPiAgICAgLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0NCj4gDQo+IA0KPiAtLS0tLU9yaWdpbmFsIE1lc3NhZ2UtLS0tLQ0KPiBG
cm9tOiBNYXJjIEZyb21tDQo+IFNlbnQ6IE1hciAyOSwgMjAxMSAxOjU4IFBN
DQo+IFRvOiAicGdzcWwtb2RiY0Bwb3N0Z3Jlc3FsLm9yZzxtYWlsdG86cGdz
cWwtb2RiY0Bwb3N0Z3Jlc3FsLm9yZz4iDQo+IFN1YmplY3Q6IFtPREJDXSBm
aXJzdCB0aW1lIG9kYmMNCj4gDQo+IA0KPiBCZWZvcmUgbGVhcm5pbmcgdGhl
cmUgd2FzIGFuIG9kYmMgbGlzdCwgSSBzZW50IHRoaXMgcG9zdCB0byB0aGUg
YWRtaW4gDQo+IGxpc3QuDQo+IA0KPiBJIGFtIHJ1bm5pbmcgcG9zdGdyZXMg
b24gYSByZWQgaGF0IGxpbnV4IHNlcnZlci4NCj4gcG9zdGdyZXNxbC1weXRo
b24tOC4xLjIzLTEuZWw1XzYuMQ0KPiBwb3N0Z3Jlc3FsLXRlc3QtOC4xLjIz
LTEuZWw1XzYuMQ0KPiBwb3N0Z3Jlc3FsLWxpYnMtOC4xLjIzLTEuZWw1XzYu
MQ0KPiBwb3N0Z3Jlc3FsLWRvY3MtOC4xLjIzLTEuZWw1XzYuMQ0KPiBwb3N0
Z3Jlc3FsLWNvbnRyaWItOC4xLjIzLTEuZWw1XzYuMQ0KPiBwb3N0Z3Jlc3Fs
LTguMS4yMy0xLmVsNV82LjENCj4gcG9zdGdyZXNxbC1wbC04LjEuMjMtMS5l
bDVfNi4xDQo+IHBvc3RncmVzcWwtb2RiYy0wOC4wMS4wMjAwLTMuMQ0KPiBw
b3N0Z3Jlc3FsLWpkYmMtOC4xLjQwNy0xanBwLjQNCj4gcG9zdGdyZXNxbC1z
ZXJ2ZXItOC4xLjIzLTEuZWw1XzYuMQ0KPiBwb3N0Z3Jlc3FsLXRjbC04LjEu
MjMtMS5lbDVfNi4xDQo+IA0KPiBVc2VyIG9uIHdpbmRvd3MgY29tcHV0ZXJz
IHdvdWxkIGxpa2UgdG8gb2RiYyB0byB0aGUgcG9zdGdyZXMgDQo+IGRhdGFi
YXNlcy4gSSBkb3dubG9hZGVkIHRoZSB3aW5kb3dzIHBvc3RncmVzIG9kYmMg
ZHJpdmVycyBmcm9tIHRoZSANCj4gZm9sbG93aW5nIHNpdGUgYW5kIGluc3Rh
bGxlZCB2ZXJzaW9uIOKAnHBzcWxvZGJjLTA4XzAxXzAyMDDigJ0gb24gdGhl
IA0KPiB3aW5kb3dzIGNvbXB1dGVyLg0KPiBodHRwOi8vZnRwOS51cy5wb3N0
Z3Jlc3FsLm9yZy9wdWIvbWlycm9ycy9wb3N0Z3Jlc3FsL29kYmMvdmVyc2lv
bnMvbXNpDQo+IC8NCj4gDQo+IFdoZW4gSSBjb25maWd1cmUgYSDigJxGaWxl
IERhdGEgU291cmNl4oCdIGNvbm5lY3Rpb24gaW4gYWNjZXNzLCBJIGNhbm5v
dCANCj4gY29ubmVjdCB0byB0aGUgcG9zdGdyZXNxbCBkYXRhYmFzZS4gSSBn
ZXQgdGhlIG1lc3NhZ2UsIOKAnEEgY29ubmVjdGlvbiANCj4gY291bGQgbm90
IGJlIG1hZGUgdXNpbmcgdGhlIGZpbGUgZGF0YSBzb3VyY2UgcGFyYW1ldGVy
cyBlbnRlcmVkLiBTYXZlIA0KPiBub24tdmVyaWZpZWQgZmlsZSBEU04/4oCd
IFRoZSBwYXJhbWV0ZXJzIGVudGVyZWQgYXJlOiBEYXRhYmFzZToNCj4gZGF0
YWJhc2VfbmFtZSBTZXJ2ZXI6IEkgZW50ZXJlZCB0aGUgSVAgYWRkcmVzcyBv
ZiB0aGUgc2VydmVyIFVzZXINCj4gTmFtZTogSSBlbnRlcmVkIHBvc3RncmVz
IFBhc3N3b3JkOg0KPiBTU0wgTW9kZTogcHJlZmVyDQo+IFBvcnQ6IDU0MzIg
KHdoaWNoIGlzIHRoZSBwb3J0IHVzZWQgYnkgcG9zdGdyZXMpDQo+IA0KPiBE
byBJIG5lZWQgdG8gY29uZmlndXJlIHRoZSAvZXRjL29kYmMuaW5pIGZpbGU/
IEl0IGlzIGN1cnJlbnRseSBqdXN0IGEgDQo+IGJsYW5rIGZpbGUuDQo+IA0K
PiBUaGFua3MgZm9yIGFueSBoZWxwLg0KPiANCj4gTWFyYw0KDQoNCg0KLS0N
ClNlbnQgdmlhIHBnc3FsLW9kYmMgbWFpbGluZyBsaXN0IChwZ3NxbC1vZGJj
QHBvc3RncmVzcWwub3JnKSBUbyBtYWtlIGNoYW5nZXMgdG8geW91ciBzdWJz
Y3JpcHRpb246DQpodHRwOi8vd3d3LnBvc3RncmVzcWwub3JnL21haWxwcmVm
L3Bnc3FsLW9kYmMNCg0KCi0tIApTZW50IHZpYSBwZ3NxbC1vZGJjIG1haWxp
bmcgbGlzdCAocGdzcWwtb2RiY0Bwb3N0Z3Jlc3FsLm9yZykKVG8gbWFrZSBj
aGFuZ2VzIHRvIHlvdXIgc3Vic2NyaXB0aW9uOgpodHRwOi8vd3d3LnBvc3Rn
cmVzcWwub3JnL21haWxwcmVmL3Bnc3FsLW9kYmMK

Re: first time odbc

am 30.03.2011 17:23:31 von Adrian Klaver

On 03/30/2011 07:54 AM, Marc Fromm wrote:
> I only want the users to read data, thus I removed superuser and applied grant select.
>
> If the listen_address is not a client filter, would it still be better to only have it listen to localhost and the few ip addresses that will need to odbc to the postgres database? Is it just not possible to assign listen_address = 'localhost, 1.ip.address, 2.ip.address'?

listen_address refers to the addresses available on the host. More than
one assumes you have more than one IP address bound to the database
host. You will not get the result you want using the method you propose
above.

>
> One other thing still, if in the pg_hba.conf file I do not include any ip addresses I cannot connect to the database. If I enter just one ip address, any computer can connect to the database, even though some machines have static ip addresses and others have dhcp address from a completely different subnet. Do you know why this is? I figured the pg_hba.conf file controlled access by ip address, based on other googled articles.

pg_hba.conf works by first match wins. My guess is you have line above
your IP line that is more permissive and is allowing connections. Per a
previous post, you probably should spend some time with the manual to
fully understand the interaction between the various security,access
components of Postgres:)
>
> Thanks
>
>
--
Adrian Klaver
adrian.klaver@gmail.com

--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Re: first time odbc

am 30.03.2011 17:47:37 von Rod

On 30/03/2011 15:54, Marc Fromm wrote:
> I only want the users to read data, thus I removed superuser and
> applied grant select.

Good stuff.

> If the listen_address is not a client filter, would it still be
> better to only have it listen to localhost and the few ip addresses
> that will need to odbc to the postgres database? Is it just not
> possible to assign listen_address = 'localhost, 1.ip.address,
> 2.ip.address'?

You're still misunderstanding listen_addresses - it has *nothing* to do
with client addresses.

Example: I have a server with two network interfaces, a.b.c.x and
a.b.c.y. If I want PG to listen on both interfaces, I can set
listen_addresses = '*' (or list the two addresses explicitly). If I want
it to listen *only* on a.b.c.x, then I set listen_addresses='a.b.c.x'.

> One other thing still, if in the pg_hba.conf file I do not include
> any ip addresses I cannot connect to the database. If I enter just
> one ip address, any computer can connect to the database, even though
> some machines have static ip addresses and others have dhcp address
> from a completely different subnet. Do you know why this is? I
> figured the pg_hba.conf file controlled access by ip address, based
> on other googled articles.

Can you show us your pg_hba.conf?

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie

--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Re: first time odbc

am 30.03.2011 18:33:57 von Marc Fromm

VGhpcyBpcyBteSBwZ19oYmEuY29uZiBmaWxlLiBJIHJlcGxhY2VkIHgncyB3
aXRoIG15IGlwIGFkZHJlc3MuDQpJZiBJIGNvbW1lbnQgbGluZSA3NCwgdGhl
biBubyBvbmUgY2FuIG9kYmMgdG8gcG9zdGdyZXNxbC4NCkxpbmVzIDEgLSA2
NyBhcmUgYWxsIGp1c3QgY29tbWVudGVkIHRleHQuDQoNCiA2OCAjIFRZUEUg
IERBVEFCQVNFICAgIFVTRVIgICAgICAgIENJRFItQUREUkVTUyAgICAgICAg
ICBNRVRIT0QNCiA2OSANCiA3MCAjICJsb2NhbCIgaXMgZm9yIFVuaXggZG9t
YWluIHNvY2tldCBjb25uZWN0aW9ucyBvbmx5DQogNzEgbG9jYWwgICBhbGwg
ICAgICAgICBhbGwgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgdHJ1
c3QNCiA3MiAjIElQdjQgbG9jYWwgY29ubmVjdGlvbnM6DQogNzMgaG9zdCAg
ICBhbGwgICAgICAgICBhbGwgICAgICAgICAxMjcuMC4wLjEvMzIgICAgICAg
ICAgdHJ1c3QNCiA3NCBob3N0ICAgIGFsbCAgICAgICAgIGFsbCAgICAgICAg
IHh4eC54eHgueHh4Lnh4eCAyNTUuMjU1LjAuMCAgICAgICBtZDUNCiA3NSAj
IElQdjYgbG9jYWwgY29ubmVjdGlvbnM6DQogNzYgaG9zdCAgICBhbGwgICAg
ICAgICBhbGwgICAgICAgICA6OjEvMTI4ICAgICAgICAgICAgICAgdHJ1c3QN
Cg0KDQotLS0tLU9yaWdpbmFsIE1lc3NhZ2UtLS0tLQ0KRnJvbTogUmF5bW9u
ZCBPJ0Rvbm5lbGwgW21haWx0bzpyb2RAaW9sLmllXSANClNlbnQ6IFdlZG5l
c2RheSwgTWFyY2ggMzAsIDIwMTEgODo0OCBBTQ0KVG86IE1hcmMgRnJvbW0N
CkNjOiBwb3N0Z3Jlc3FsQGZpbm5lci5kZTsgcGdzcWwtb2RiY0Bwb3N0Z3Jl
c3FsLm9yZw0KU3ViamVjdDogUmU6IFtPREJDXSBmaXJzdCB0aW1lIG9kYmMN
Cg0KT24gMzAvMDMvMjAxMSAxNTo1NCwgTWFyYyBGcm9tbSB3cm90ZToNCj4g
SSBvbmx5IHdhbnQgdGhlIHVzZXJzIHRvIHJlYWQgZGF0YSwgdGh1cyBJIHJl
bW92ZWQgc3VwZXJ1c2VyIGFuZCANCj4gYXBwbGllZCBncmFudCBzZWxlY3Qu
DQoNCkdvb2Qgc3R1ZmYuDQoNCj4gSWYgdGhlIGxpc3Rlbl9hZGRyZXNzIGlz
IG5vdCBhIGNsaWVudCBmaWx0ZXIsIHdvdWxkIGl0IHN0aWxsIGJlIGJldHRl
ciANCj4gdG8gb25seSBoYXZlIGl0IGxpc3RlbiB0byBsb2NhbGhvc3QgYW5k
IHRoZSBmZXcgaXAgYWRkcmVzc2VzIHRoYXQgd2lsbCANCj4gbmVlZCB0byBv
ZGJjIHRvIHRoZSBwb3N0Z3JlcyBkYXRhYmFzZT8gSXMgaXQganVzdCBub3Qg
cG9zc2libGUgdG8gDQo+IGFzc2lnbiBsaXN0ZW5fYWRkcmVzcyA9ICdsb2Nh
bGhvc3QsIDEuaXAuYWRkcmVzcywgMi5pcC5hZGRyZXNzJz8NCg0KWW91J3Jl
IHN0aWxsIG1pc3VuZGVyc3RhbmRpbmcgbGlzdGVuX2FkZHJlc3NlcyAtIGl0
IGhhcyAqbm90aGluZyogdG8gZG8gd2l0aCBjbGllbnQgYWRkcmVzc2VzLg0K
DQpFeGFtcGxlOiBJIGhhdmUgYSBzZXJ2ZXIgd2l0aCB0d28gbmV0d29yayBp
bnRlcmZhY2VzLCBhLmIuYy54IGFuZCBhLmIuYy55LiBJZiBJIHdhbnQgUEcg
dG8gbGlzdGVuIG9uIGJvdGggaW50ZXJmYWNlcywgSSBjYW4gc2V0IGxpc3Rl
bl9hZGRyZXNzZXMgPSAnKicgKG9yIGxpc3QgdGhlIHR3byBhZGRyZXNzZXMg
ZXhwbGljaXRseSkuIElmIEkgd2FudCBpdCB0byBsaXN0ZW4gKm9ubHkqIG9u
IGEuYi5jLngsIHRoZW4gSSBzZXQgbGlzdGVuX2FkZHJlc3Nlcz0nYS5iLmMu
eCcuDQoNCj4gT25lIG90aGVyIHRoaW5nIHN0aWxsLCBpZiBpbiB0aGUgcGdf
aGJhLmNvbmYgZmlsZSBJIGRvIG5vdCBpbmNsdWRlIGFueSANCj4gaXAgYWRk
cmVzc2VzIEkgY2Fubm90IGNvbm5lY3QgdG8gdGhlIGRhdGFiYXNlLiBJZiBJ
IGVudGVyIGp1c3Qgb25lIGlwIA0KPiBhZGRyZXNzLCBhbnkgY29tcHV0ZXIg
Y2FuIGNvbm5lY3QgdG8gdGhlIGRhdGFiYXNlLCBldmVuIHRob3VnaCBzb21l
IA0KPiBtYWNoaW5lcyBoYXZlIHN0YXRpYyBpcCBhZGRyZXNzZXMgYW5kIG90
aGVycyBoYXZlIGRoY3AgYWRkcmVzcyBmcm9tIGEgDQo+IGNvbXBsZXRlbHkg
ZGlmZmVyZW50IHN1Ym5ldC4gRG8geW91IGtub3cgd2h5IHRoaXMgaXM/IEkg
ZmlndXJlZCB0aGUgDQo+IHBnX2hiYS5jb25mIGZpbGUgY29udHJvbGxlZCBh
Y2Nlc3MgYnkgaXAgYWRkcmVzcywgYmFzZWQgb24gb3RoZXIgDQo+IGdvb2ds
ZWQgYXJ0aWNsZXMuDQoNCkNhbiB5b3Ugc2hvdyB1cyB5b3VyIHBnX2hiYS5j
b25mPw0KDQpSYXkuDQoNCi0tDQpSYXltb25kIE8nRG9ubmVsbCA6OiBHYWx3
YXkgOjogSXJlbGFuZA0Kcm9kQGlvbC5pZQ0KDQoKLS0gClNlbnQgdmlhIHBn
c3FsLW9kYmMgbWFpbGluZyBsaXN0IChwZ3NxbC1vZGJjQHBvc3RncmVzcWwu
b3JnKQpUbyBtYWtlIGNoYW5nZXMgdG8geW91ciBzdWJzY3JpcHRpb246Cmh0
dHA6Ly93d3cucG9zdGdyZXNxbC5vcmcvbWFpbHByZWYvcGdzcWwtb2RiYwo=