• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3457
  • Last Modified:

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.





0
junebrown
Asked:
junebrown
  • 9
  • 8
2 Solutions
 
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
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 9
  • 8
Tackle projects and never again get stuck behind a technical roadblock.
Join Now