BornInTheUSA
Programmer
Hey people, recently I've been trying to set up the 'cheapest' solution for a 'total solution' for a bunch of clients. To make a long story short I migrated over to every LINUX alternative I could.
Current system is Linux Redhat 7.2 running, apache web server, and MySQL. Also ColdfusionMX for Linux has been installed on the system and everything works properly here so far.
The clients are REALLY big on Crystal Reports since I could make reports 'appear' identical to the ones they've been using for years. I was able to install 'wine' (Windows Emulator) onto the system, and was also able to Install Crystal Reports (5.0) though wine on the system. (I used 5 because is has a requred crpe32.dll which is required for Coldfusion to do crystal reports has been taken out of the 'standard' version of Crystal Reports 7.0 and up, its only in the 'developer edition') Finally I installed MyODBC and registered the MySQL database in MyODBC.
Now when I run crystal reports on the linux machine, it all works fine, I could see the database and choose it, even make reports and everything all fine.
Basically both crystal reports and coldfusion are working fine on their own. The problem is that coldfusion running on the linux side trys to access the crw32.dll file (was located in C:/windows/system) and gives me an 'unable to load library' error.
The file exists, and is located /usr/share/wine-c/windows/system (in the wine setup /usr/share/wine-c is set to be C:\)
I belive the problem stems from Coldfusion being installed on the Linux Side. Coldfusion trys to execute the <CFREPORT> tag (which loads a crystal report) and then checks whatever linux's analogy to windows registey for the location of the dll. Its not smart enough to know that it needs to go throug wine. Crystal reports is stitting on the wine portion and coldfusion doesn't even know it.
If anyone has tackled this probmem or has any ideas or clues that might help please let me know. After this last point, I'm SURE the info would be VERY useful to other deveopers out there. A 'developer version' of Crystal Reports for LINUX would probably solve the problem on its own, mabye we could use that for ideas on a possible solution (what would that do, and how do we 'hack' a fix. Thanks a bunch, hope to hear from you guys... Justin
Current system is Linux Redhat 7.2 running, apache web server, and MySQL. Also ColdfusionMX for Linux has been installed on the system and everything works properly here so far.
The clients are REALLY big on Crystal Reports since I could make reports 'appear' identical to the ones they've been using for years. I was able to install 'wine' (Windows Emulator) onto the system, and was also able to Install Crystal Reports (5.0) though wine on the system. (I used 5 because is has a requred crpe32.dll which is required for Coldfusion to do crystal reports has been taken out of the 'standard' version of Crystal Reports 7.0 and up, its only in the 'developer edition') Finally I installed MyODBC and registered the MySQL database in MyODBC.
Now when I run crystal reports on the linux machine, it all works fine, I could see the database and choose it, even make reports and everything all fine.
Basically both crystal reports and coldfusion are working fine on their own. The problem is that coldfusion running on the linux side trys to access the crw32.dll file (was located in C:/windows/system) and gives me an 'unable to load library' error.
The file exists, and is located /usr/share/wine-c/windows/system (in the wine setup /usr/share/wine-c is set to be C:\)
I belive the problem stems from Coldfusion being installed on the Linux Side. Coldfusion trys to execute the <CFREPORT> tag (which loads a crystal report) and then checks whatever linux's analogy to windows registey for the location of the dll. Its not smart enough to know that it needs to go throug wine. Crystal reports is stitting on the wine portion and coldfusion doesn't even know it.
If anyone has tackled this probmem or has any ideas or clues that might help please let me know. After this last point, I'm SURE the info would be VERY useful to other deveopers out there. A 'developer version' of Crystal Reports for LINUX would probably solve the problem on its own, mabye we could use that for ideas on a possible solution (what would that do, and how do we 'hack' a fix. Thanks a bunch, hope to hear from you guys... Justin