Link to home
Start Free TrialLog in
Avatar of liverpoolandy
liverpoolandy

asked on

THE REMAINING TEXT DOES NOT APPEAR TO BE PART OF THE FORMULA CRYSTAL 6.

I have recently installed our VB 6 and Crystal 6 app on a Windows Server 2003 which will
be used as a terminal server for the application.
When we try to run one of reports that includes a barcode, we received the above error. If the formula for the barcode is removed, the report prints fine. We have checked and double checked the the user defined function dll is in the correct place. We even tried using a standard crystal formula and received the same error. Obviously, with Server 2003 something is stopping the app finding the DLL's in c:\Winnt\Crsytal.

Any assitance greatly appreciated.
ASKER CERTIFIED SOLUTION
Avatar of vidru
vidru

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of liverpoolandy
liverpoolandy

ASKER

Hi Dave,
Doesn't matter who you log in as.
I'll try putting the Cyrstal Folder into system32
Cheers
SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I've put all dll's etc everywhere I can think of but still the same error.
I think it's something to do with Security Policies on 2003
Any ideas?
I've just put the Crystal folder under
C:\Documents and Settings\Administrator\WINDOWS
and it works.
I then tried it for another user
C:\Documents and Settings\andy\WINDOWS
and it didn't!!!!
Did you try to simply register the barcode dll?

From the Start, RUN, ...  use
regsvr32 <path to the dll>

hth,
- Ido
The dll's been registered and unregistered more times than I can remember.
One more point, all works fine for the Administrator on the console since copying crystal
folder into C:\Documents and Settings\Administrator\WINDOWS but you get the original
error if you login remotely as the Administrator.
This sounds like a permissions issue.  When you put the dlls in the Administraotrs windows directory he could run them but others couldn't since they don't have access to the directory.

Another issue is CR6 is not tested or supported on Win 2K3.  This may be the root of the problem.

Can you build any formulas?  Say one that just returns a simple value like
Name - @test
"This Works"

mlmcc
I think its definatley a permissons issue. I'm a developer and not a W2003 Administrator so it's difficult
trying to work out whats what!!

I have given access on the Administrators directory to everyone. Given access to the relevant branches of the
registry to everyone and still no success. My account is not only a local Administrator on the W2003 box but a domain administrator aswell and still it will not work under my account.

I understand the issue with CR6, we are in the process of downloading a trial version of CR10 to see if this
will resolve the problem.
We should have this down and a test program ready my midday GMT. I will post the results.
Anything else you can think of on the permissions front please let me know.

Andy
We have now evaluated CR10 and it works fine with W2003 Server so we are going to upgrade.
We've been thinking about it for a while but never got round to it. This problem has now forced
us to do it.
Many thanks everyone for your assitance with the original problem.
Andy