TOPIC: Database login failed error

Database login failed error 21 Apr 2011 12:55 #785

  • kenhenderson
  • kenhenderson's Avatar
  • Offline
I am getting the following error when trying to run the RRD File.

"Database logon failed. (emailCrystalReport)"

My Crystal Report accesses an Excel file database that is located on our file server. The RRD output is an email. I have double checked my log in user and password. Any ideas what is causing this?

We are running version 1.6.24.0
The administrator has disabled public write access.

Re:Database login failed error 21 Apr 2011 13:00 #786

  • mattholbrook
  • mattholbrook's Avatar
Hi,

Does the Crystal Report connect directly to the excel spreadsheet or does it use a ODBC connection that points towards the spreadsheet? If it used an odbc connection please make sure you have one set up on the system you are on. If the Crystal Report connects directly to the spreadsheet then the spreadsheet needs to be in the exact location that the report specifies. So if you moved it at any point that could trip it up. Thanks!

Matt
The administrator has disabled public write access.

Re:Database login failed error 25 Apr 2011 22:50 #787

  • kenhenderson
  • kenhenderson's Avatar
  • Offline
I didn't have the ODBC set up correctly. I think that is going to fix it. Thanks!
The administrator has disabled public write access.