We help IT Professionals succeed at work.
Get Started

"open database session failed" error on one Crystal Report when directed to certain database

1,499 Views
Last Modified: 2007-11-27
We market an application that is created in Visual Basic 6, uses an Access database (4.0), and has a number of Crystal Reports (8.5) that access the database via OLE DB.  One of our long-time users has just recently started having a problem with one of the reports, receiving the Crystal Reports error message "open database session failed" when they try to run it.  Their other reports are still functioning correctly, including reports that draw from the same columns of the same table.  Since all of the reports run through the same code sequence and use the same connection string, that would mean that it is not a connectivity problem, wouldn't it?  They have sent me a copy of their Access database and I get the same error when I use their database, but not when I use any other database, so that would indicate no version incompatibility in the report itself.  Using Crystal Reports directly, without running it through Visual Basic, the report will run against their database without problems, which suggests there is no problem within the database.  (I have tried compacting and repairing the database with no effect.)  What else is left?  Does anyone have any other suggestions as to where to look for the problem?
Comment
Watch Question
Database Architect / Application Developer
CERTIFIED EXPERT
Top Expert 2007
Commented:
This problem has been solved!
Unlock 1 Answer and 5 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE