[jediez]

Hi.

I’m using Crystal Reports XI, Tomcat 5.0 to display a report on to a jsp.

When the report is about to be displayed, I get this error:

“Error
Logon failed
”

I’m absolutely sure the connection information I’m proving is correct. I tried printing out the connection information by calling oCrystalReportViewer.getDatabas eLogonInfos().getConnectionInfo(0).getAttributes().toString() ; and this text is shown:

{Server Name=mas3, Connection String=Server=s(mas3);User ID=s(admin);Password=, Database Name=, Database DLL=crdb_oracle.dll}

Apparently I’ve not set the Database Name, I dont know where to set it, just tried with this code: (It did not work though)

PropertyBag propertyBag = new PropertyBag();
propertyBag.put(“Database Name”, “m239”); oIConnectionInfo.setAttributes(property Bag);

Please, please… help me out with this issue as It’s driving me into crazy

Regards

[Riyad Kalla]

Hmm strange. Can you create a single sample Class with a single main() method that correctly opens the connection to first make sure you are using the right code? Then it’s just an issue of figuring out where to put it, in your app.

[jediez]

What code are u suggesting, to open a connection using Crystal Reports objects?

I already tried a test connection that uses JDBC and ORacle Driver to connect to database and it works perfectly.

Any other hint?

[jediez]

Hi rkalla.

Have u got any other hint?
This issue id driving me nuts.

Please help

[Riyad Kalla]

Unfortunately not, I haven’t used Crystal Reports before. I was only suggesting a general tactic to figure out what is going wrong, more specifically, try and connect to the report from a simple test class instead of trying to debug the bigger issue in the context of your entire application.

[Author]

Posts