Re: Cannot connect to remote database.

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

Dave Cramer <pg(at)fastcrypt(dot)com>
04/13/2005 04:47 PM
Please respond to
pg(at)fastcrypt(dot)com

To
Kristina Magwood <kristina(at)nanometrics(dot)ca>
cc
pgsql-jdbc(at)postgresql(dot)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