Visual Basic ADODB Connection Problem between 2 Servers
am 12.11.2007 07:46:22 von Phillip SmithI'm hoping I'm posting this to the right place.
I've been using PostgreSQL for a couple of years now. I'm successfully
running several PG servers at work for Data Warehousing and one at home for
various things (drupal, amarok, development)
I've decided to experiment with Visual Basic and PostgreSQL as there's
something I want to develop where I think VB would be best (mainly because
the only other languages I know are PHP and PICK)
My problem is, I use the connection string below to connect to the server at
work, and it connects fine; I can execute SELECT queries etc:
strPG =3D "Driver=3D{PostgreSQL};" & _
"Server=3Dsql.weatherbeeta.com.au;" & _
"PORT=3D5432;" & _
"Database=3Ddwh;" & _
"UID=3Dpostgres;" & _
"PWD=3Dthisisnotreallymypassword"
But when I take the same string and modify it to connect to my home server
(via VPN) it fails:
strPG =3D "Driver=3D{PostgreSQL};" & _
"Server=3D192.168.1.234;" & _
"PORT=3D5432;" & _
"Database=3Ddevelop;" & _
"UID=3Dpostgres;" & _
"PWD=3Danotherpassword"
The error message in VB is:
"The database does not exist on the server or user authentication
failed."
The logs on my home server say:
2007-11-12 17:38:22 ESTLOG: connection received: host=3D172.20.0.155
port=3D1148
2007-11-12 17:38:22 ESTLOG: connection authorized: user=3Dpostgres
database=3Ddevelop
2007-11-12 17:38:22 ESTLOG: duration: 0.173 ms
2007-11-12 17:38:22 ESTLOG: disconnection: session time: 0:00:00.142
user=3Dpostgres database=3Ddevelop host=3D172.20.0.155 port=3D1148
I can connect using the same credentials via psql running on one of my
servers at work fine (172.20.0.155 is my work IP address), so it doesn't
appear to be incorrect username / password or firewall etc.
My only thought is that I'm using the wrong auth type in pg_hba, but they're
both the same at work and at home (md5)
Anyone help me or point me in the right direction?
Both servers are v8.2 under Linux; work one is 64-bit and home is 32-bit.
Cheers,
~p
THINK BEFORE YOU PRINT - Save paper if you don't really need to print this
*******************Confidentiality and Privilege Notice*******************
The material contained in this message is privileged and confidential to
the addressee. If you are not the addressee indicated in this message or
responsible for delivery of the message to such person, you may not copy
or deliver this message to anyone, and you should destroy it and kindly
notify the sender by reply email.
Information in this message that does not relate to the official business
of Weatherbeeta must be treated as neither given nor endorsed by Weatherbee=
ta.
Weatherbeeta, its employees, contractors or associates shall not be liable
for direct, indirect or consequential loss arising from transmission of this
message or any attachments
e-mail.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match