The only diff b/w the two DBs is that the one getting connected has ACL value as blank and the one that doesn't get connected has the same ACL property values = {}
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.