hi everybody,

I have a vb application supplied by vendor that connects to a oracle database and also has crystal reports in it. The way they are getting connected to oracle is

1. the application asks for username, password and servicename the first time it logs on to the application.

2. It uses the same params to establish another connection to oracle for crystal reports

Now the problem I'm facing is I connect successfully to the application but when I try to print crystal reports it says "Logon failed" . The vendor says that we have some settings on our database that is preventing me to have more than one connection from the same user and same machine. I try to open the crystal report and say verify database the report connects to the database.

One other thing is we have two identical databases one for each region and this report works on one database and not on ther other. Can anyone of you out there tell me what to look for on the database.


Thanks
Rukmini