junebrown
asked on
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.
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.
Here is the list of required files for CR8.5
http://support.businessobjects.com/library/kbase/articles/c2008905.asp
mlmcc
http://support.businessobjects.com/library/kbase/articles/c2008905.asp
mlmcc
ASKER
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.
I have searched my PC for this and I don't have it. I do have p2sodbc.dll and p2lodbc.dll.
Any other sugguestions.
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
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
WHat code are you using?
Which edition of CR8.5 did you buy?
mlmcc
Which edition of CR8.5 did you buy?
mlmcc
ASKER
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.
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.
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
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
ASKER
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.
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.
Windows also installs many dlls in windows\system
mlmcc
mlmcc
ASKER
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.
I guess we will have to compare window\system32 directories.
Unless anyone has any other suggestions.
Yes I forget the NT based systems use system32.
mlmcc
mlmcc
ASKER
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I am on XP (no I havent installed SP2) and my colleague is on Win2000.
We will look at installation packages.
We will look at installation packages.
ASKER
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.
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.
ASKER
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.
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.
Glad i could help
mlmcc
mlmcc
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