Cliff, I skipped your message the first time wondering why J++. You can specify a profile on your connection, if you don't it will prompt for it. Hopefully you are running it on the same computer in that case or you will have to run to the other computer to signon. There are ways to cache signons that are described in the JavaDoc. You can qualify your tables etc with a library name, specify a library list on the connection string, or in a property file. I have had problems with the second option; it seems to get stuck on a single collection. Probably just missed a setting in my code to set nameing to sys or something. I had the library names in my case so I qualified the library in my prepared statement. David Morris

Reply With Quote