Re: Cannot connect to remote database. - Mailing list pgsql-jdbc

From Kristina Magwood
Subject Re: Cannot connect to remote database.
Date
Msg-id OFC4C530DA.3A8A7A30-ON85256FE2.00725367-85256FE2.00725EDE@nanometrics.ca
Whole thread Raw
In response to Re: Cannot connect to remote database.  (Dave Cramer <pg@fastcrypt.com>)
List pgsql-jdbc

Yes!  It works.  Thank you, Dave and John.



Dave Cramer <pg@fastcrypt.com>

04/13/2005 04:47 PM

Please respond to
pg@fastcrypt.com

To
Kristina Magwood <kristina@nanometrics.ca>
cc
pgsql-jdbc@postgresql.org
Subject
Re: [JDBC] Cannot connect to remote database.





Shouldnt the url be jdbc:postgresql://<ipAddress>/<port>/xxx;

Dave
Kristina Magwood wrote:

>
> Hi,
>
> I am trying to connect to two psql databases at once using jdbc.
> The first database is v7.3 running on Windows under Cygwin, the second
> is v8.01 on Windows both on the local LAN.
> The pg_hba.conf files on both machines allow any machine on the LAN to
> access the database.
> People regularly access the v7.3 database from Crystal Reports, so I
> know it's available.
>
> When I try to run the jar from the first machine, I am able to connect
> to the local database, but not the remote database.
> The same thing happens when I try from the second machine.
>
> The error is:
> Backend start-up failed: FATAL: database "xxx" does not exist.
> Where xxx is the name of the database on the remote server.
> In other words, my program is only looking for databases on the local
> machine.
>
> The code I use to connect is:
>
> DriverManager.registerDriver(new org.postgresql.Driver());
> String serviceArg = jdbc:postgresql:xxx//<ipAddress>/<port>;
> m_conn = DriverManager.getConnection(serviceArg, m_userName,
> m_userPassword);
>
> Any help will be greatly appreciated.
>
> Kristina Magwood


--
Dave Cramer
http://www.postgresintl.com
519 939 0336
ICQ#14675561


pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: Cannot connect to remote database.
Next
From: Nelson Arapé
Date:
Subject: Pam Authentication is supported?