Visual Basic ADODB Connection Problem between 2 Servers
От | Phillip Smith |
---|---|
Тема | Visual Basic ADODB Connection Problem between 2 Servers |
Дата | |
Msg-id | 008201c824f7$bcadd4d0$9b0014ac@wbaus090 обсуждение исходный текст |
Список | pgsql-odbc |
I'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 = "Driver={PostgreSQL};" & _ "Server=sql.weatherbeeta.com.au;" & _ "PORT=5432;" & _ "Database=dwh;" & _ "UID=postgres;" & _ "PWD=thisisnotreallymypassword" But when I take the same string and modify it to connect to my home server (via VPN) it fails: strPG = "Driver={PostgreSQL};" & _ "Server=192.168.1.234;" & _ "PORT=5432;" & _ "Database=develop;" & _ "UID=postgres;" & _ "PWD=anotherpassword" 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=172.20.0.155 port=1148 2007-11-12 17:38:22 ESTLOG: connection authorized: user=postgres database=develop 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=postgres database=develop host=172.20.0.155 port=1148 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 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.
В списке pgsql-odbc по дате отправления: