Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 9A1BE2E1382 for ; Tue, 13 Nov 2007 23:01:41 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 03656-09 for ; Tue, 13 Nov 2007 23:01:37 -0400 (AST) Received: from weatherbeeta.com.au (218-214-212-153.people.net.au [218.214.212.153]) by postgresql.org (Postfix) with ESMTP id 22FAD2E16FA for ; Tue, 13 Nov 2007 23:01:33 -0400 (AST) Received: (qmail 15211 invoked from network); 14 Nov 2007 03:01:30 -0000 X-NetworkBox-HamSign: 0101;OUT;wbeetaau1;3987e977eda1ea98d6028da3d010eeb6; Received: from mail.weatherbeeta.com.au (10.20.0.2) by network-box.weatherbeeta.com.au with SMTP; 14 Nov 2007 03:01:30 -0000 Received: (qmail 9608 invoked by uid 1166); 14 Nov 2007 14:01:25 +1100 Received: from 172.20.0.155 by mail.weatherbeeta.com.au (envelope-from , uid 1165) with qmail-scanner-1.25-st-qms (clamdscan: 0.88.6/2315. perlscan: 1.25-st-qms. Clear:RC:1(172.20.0.155):. Processed in 0.297946 secs); 14 Nov 2007 03:01:25 -0000 X-Antivirus-mail.weatherbeeta.com.au-Mail-From: phillip.smith@weatherbeeta.com.au via mail.weatherbeeta.com.au X-Antivirus-mail.weatherbeeta.com.au: 1.25-st-qms (Clear:RC:1(172.20.0.155):. Processed in 0.297946 secs Process 9589) Received: from it-phil.weatherbeeta.com.au (HELO wbaus090) (172.20.0.155) by mail.weatherbeeta.com.au with SMTP; 14 Nov 2007 14:01:24 +1100 From: "Phillip Smith" To: Subject: Visual Basic ADODB Connection Problem Date: Wed, 14 Nov 2007 14:01:27 +1100 Organization: Weatherbeeta Pty Ptd Message-ID: <00e401c8266a$a6511660$9b0014ac@wbaus090> MIME-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.6626 Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962 X-Scanned-By-wbeetaau1: Virus scan performed by network-box X-Scanned-By-wbeetaau1: Scanner file id is wbeetaau1-1195009290.826-15204-000 X-Scanned-By-wbeetaau1: No known viruses found in message (received+scanned in 0.01/0.03 secs) X-Scanned-By-wbeetaau1: Spam-Check-Result: No, hits=0 required=7 tests= autolearn=no version=2.0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/117 X-Sequence-Number: 27360 Hi All, I posted this on the ODBC list a couple of days ago but haven't had any reply - not sure if I had the right list. Perhaps it's an admin thing = since it works on one server but not another, maybe it's something obscure = between how I've setup the server that isn't working...? Cheers, ~p (Forwarded message below) > I'm hoping I'm posting this to the right place. >=20 > 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) >=20 > 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) >=20 > 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" >=20 > 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" >=20 > The error message in VB is: > "The database does not exist on the server or user authentication > failed." >=20 > 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 >=20 > 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. >=20 > 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) >=20 > Anyone help me or point me in the right direction? >=20 > Both servers are v8.2 under Linux; work one is 64-bit and home is = 32-bit. >=20 > 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 Weatherbeeta. 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.