How do I solve an error detected by database dll crystal report error message?

I am using Crystal Report 8.5 and use stored procedures in sql server 2000 to come up with a report. The problem I have is that most of these reports work on my machine. However, once I put out the application to be used by several others from an intranet system, they get this error "Error Occurred Reading Records: Error detected by database DLL. Error Number: -2147192179". For your information, I use OLE DB driver to connect to the SQL Server. I also use html form through asp codes to use the .rpt crystal report.
dexeyaAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

bluV11tCommented:
Hi!
Try opening the report from crystal reports on the server console and go to meny Database / Set location and set the location of the tables again.
0
dro_lawCommented:
That could be a few things.  have you tried running a SQL trace to see what query the reports are running when not on your machine? Most likely, it is a permissions issue. Are you hitting the database with the same user account on your machine as your on the user machines?If the query works from your machine, there is most likely nothing wrong with the SQL query your report is structuring. The only difference is the context in which you are running it. So, most likely , it's the account, or you have not distributed the crystal dlls correctly in your install package and the users have a different version than you do.

Hop that helps.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
mlmccCommented:
How did you install the reports and Crystal on the server?

Can they run reports not based on stored procedures?

Can you run a report through the server?

mlmcc
0
Introduction to R

R is considered the predominant language for data scientist and statisticians. Learn how to use R for your own data science projects.

dexeyaAuthor Commented:
Each user has a different account and we are not using the same user account but how can i distribute the crystal dlls in the install packages? Do you mean to say each user need to have a crystal report software in their machine? If that's so, they don't. They access the reports from an html page which has an embedded asp page that calls the crystal report.
0
dexeyaAuthor Commented:
I accidentally hit accept solution and it looks like the question is closed but I am not done with my questions. Bear with me please since this is the first time I am using expert-exchange and didn't even know how to reply to your answers.
0
dexeyaAuthor Commented:
bluV11t, I went ahead and set the location again but it didn't change anything.

dro_law, Each user has a different account and we are not using the same user account but how can i distribute the crystal dlls in the install packages? Do you mean to say each user need to have a crystal report software in their machine? If that's so, they don't. They access the reports from an html page which has an embedded asp page that calls the crystal report.

mlmcc, the reports on the server are based on stored procedures.
0
dro_lawCommented:
If you are using a web page, then you don't need to distribute any components (sorry, I missed that in your first post). So, the problem is most likely that not all of the users that are hitting the db have access to the stored procedure. Try giving exec permission on the stored procedure to the public role. That should allow everyone to run it. Of course, that assumes that the SP is not of a sensitive/secure nature since anyone will be able to run it under the public role. If it it does return sensitive data, then create a role for all the users that need report access and assign them to it. That will make it easier to administer for future reports/stored procedures.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.