LOGON Failed error using CR for .NET and ORACLE 9i/ASP.NET
Posted on 2004-11-11
I have an ASP.NETapp that I have built on my development machine, using CR for .NET for the reporting (a rather small part of the overall app). My development box has access to Oracle 8i, and everything runs PERFECTLY.
I have distributed the app to a customer site where the customer is using ORACLE 9i. Everything about the app is perfect on the customer box WITH ONE EXCEPTION:
when I try to open a report, I get "Logon Failed..."
As I said, everything else about the app runs perfectly on both boxes. The same UserName and Password opens the Reports and the rest of the app (not the same username and pwd acroos boxes) and there are no errors with other parts of the app.
I have been in communication with the CR Help Desk - They are in INDIA - via email, and the results have been less than helpful.
The reports are being connnected at runtime, using the ConnectionInfo object, and I am assigning the connection properties to the 'tables' (a single View for each report) also at runtime (the report files are NOT Embedded in the DLL)