works fine with another database in the same database server with same user role combination.
Don't know whats going wrong..
On 10/13/06, Shane Ambler <pgsql@xxxxxxxxxxxxxxxx> wrote:
J S B wrote:
> Hi,
> I took a back up of my database and restored it in a new DB..When I'm
> trying
> to connect to the new DB from a client machine using ECPG connection
> techniques, it says newDB doesn't exist.
> There's another DB in the same DB server and if I try and connect to
> that DB
> then it doesn't cry over anything.
>
> Thanks
> Jas
>
I am guessing that you can verify that the newDB exists and has the data
you just have trouble from the ECPG client from any machine.
I would check access privileges - does the user you log in as using ECPG
have access to newDB? - the 'DB doesn't exist' may be a wrong error
which should say access denied.
