crystal and mysql dll

Help.

I have mysql and CR 8.5 (full installation)  on my PC and all is well.
My colleague hasn't got CR 8.5 (running off runtime dlls) but has got mysql loaded.
When he runs reports it comes up with the message

Error 599 Cannot open SQL Server. Execute <PEStartPrintJob>

We have copied across everything we can think of + a bit more.
All the p2*.dlls, which includes p2sodbc.dll, p2smon.dll
We have loaded crpe32.dll and crpeaig80.dll, and can run paradox cr8.5 reports no problem.
It is the extra dlls for mysql we haven't figured out.
The runtime.hlp doesn't give any clues for mysql.





junebrownAsked:
Who is Participating?
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.

mlmccCommented:
On your  machine
Open a report that uses the MySQL database
Click DATABASE - CONVERT DATABASE DRIVER
The popup will show you which dll you are using to connect to the database
Click CANCEL
Ensure that dll is loaded on your friend's machine

mlmcc
0
mlmccCommented:
Here is the list of required files for CR8.5
http://support.businessobjects.com/library/kbase/articles/c2008905.asp

mlmcc
0
junebrownAuthor Commented:
When I do this it comes up with pdsodbc.dll

I have searched my PC for this and I don't have it. I do have p2sodbc.dll and p2lodbc.dll.

Any other sugguestions.
0
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

mlmccCommented:
Crystal in its infinite wisdom always uses the pd names.

The pd*.dll are for 16-bit implementations.
The p2*.dll are for 32-bit implementations.

You need to ensure p2sodbc.dll is on the machine.  What directory did you put it in?

mlmcc
0
mlmccCommented:
WHat code are you using?

Which edition of CR8.5 did you buy?

mlmcc
0
junebrownAuthor Commented:
We have tried p2sobdc.dll in 2 place

winnt\system32 (it is an windows 2000 PC) and in the same directory as my exe.

cr 8.5 developer.

I have just thought of a compilation. We bought version 9 (developer), but discovered it didn't work with paradox, so reverted to 8.5 (which does). So it is possible I still have some version 9  dlls, even though I look it off, and re-installed 8.5. Our new s/w is written with mysql, but we still have system out there running with paradox.

Or maybe this is irrelevant.

0
mlmccCommented:
That is possible that CR9 replaced some dlls and they weren't replaced when CR8.5 was reinstalled.

We loaded our p2* dlls in the application directory, so that should be ok.

Are you building an installation package to install the application on the client?  What language?

mlmcc
0
junebrownAuthor Commented:
The language is delphi.

I haven't built an installation package as we are still trying to work out which dll's we need.

I obviously have a dlls my colleague doesn't even though I have sent him everything from the
windows\crystal directory on my PC.

I will see if I can find another PC (in my office, my colleague is 400 miles away which doesn't help debugging) which hasn't had CR development package loaded.

We have been using CRs for years with paradox and have installed no problem with installation packages on client PCs.
0
mlmccCommented:
Windows also installs many dlls in windows\system

mlmcc
0
junebrownAuthor Commented:
I am on XP, and only have 10 dlls in my system directory.
I guess we will have to compare window\system32 directories.

Unless anyone has any other suggestions.
0
mlmccCommented:
Yes I forget the NT based systems use system32.

mlmcc
0
junebrownAuthor Commented:
1 last try

is there anything wrong in the way I am calling the report

              Crpe1.Clear;
              crpe1.reportname := 'compdec.rpt';                    
              crpe1.verify;  
              crpe1.execute;

I know with paradox tables we had to change the path name, but I assume that CR would pick the paths up from the ODBC connection for mysql.
0
Saari_LexCommented:
Hold on a second: if you're not using an installation package, how exactly do you know which libraries need to be registered and what other libraries are direct or indirect dependencies of the ones you only see on the surface?
Package and deployment tools are not just neat software distribution utilities: they're also useful developer helpers to analyse runtime images.

So here's my suggestion: use some sort of package and distribution wizard in the first place (just pick one) and you'll save yourself a lot of headaches trying to understand what library depends on what other library, what needs to be registed, what needs to be in the system folder, what needs to be in the app folder, etc etc...

Now this doesn't make sure you get it right first time, but it already does 90% of the work for you.

Another 9% of the work is performed by using some cool profiler or runtime image snapshot tools, like modules.exe and/or depends.exe (the first one is even on the business objects website) to double-check that you're distributing all the runtime modules you need.

The remaining 1% is usually dedicated to picking up and distributing non-embedded resources like property files and odbc datasources.

Good luck.
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:
Another minor issue, CR8.5 wasn't tested on XP.  Crystal believes it will work and supports (or did) it on XP.

Did you upgrade to SP2?  Crysatl apparently has major problems with XP SP2 so Crystal recommends not installing.

mlmcc
0
junebrownAuthor Commented:
I am on XP (no I havent installed SP2) and my colleague is on Win2000.

We will look at installation packages.
0
junebrownAuthor Commented:
OK. We tried this. Used 'wise' to work out the DLLs and install.

My colleague has now also installed CR dev (full version) on his PC, so we should be matching.

But we are still getting

Error 559 Cannot open SQL Server. Execute <PEStartPrintJob>

when he executes the reports via delphi.

 I have set up all the connect (password/user name/database) and lLogOnServer values
and it connects, but as soon as we execute we get the message.
0
junebrownAuthor Commented:
All,

thanks for the help.

Have finally worked it out.
What I needed to do was load and unload the engine at run time, which forced a refresh on the driver type.


not sure how to say this point is now closed though.
0
mlmccCommented:
Glad i could help

mlmcc
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.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.