shamin
asked on
Error 599 Cannot open sql server
Hi,
We have a crystal report that give this error Error : 599 - Cannot open sql server. This is a report with 13 sub reports. The version of Crystal report is 7.0.100.15. The database is Oracle. It runs fine from Report designer. When run from the Application it gives this error. The application is in Powerbuilder 6.5. The report seems to running fine in production on the users machine. We recently upgraded PowerBuilder 6.5 to 8. This report is not running in both the versions of the application. I have read through the other threads and couldn't find a solution for this. Its hard to say that the problem is machine specific because it works in other machines. Any help is highly appreciated.
We have a crystal report that give this error Error : 599 - Cannot open sql server. This is a report with 13 sub reports. The version of Crystal report is 7.0.100.15. The database is Oracle. It runs fine from Report designer. When run from the Application it gives this error. The application is in Powerbuilder 6.5. The report seems to running fine in production on the users machine. We recently upgraded PowerBuilder 6.5 to 8. This report is not running in both the versions of the application. I have read through the other threads and couldn't find a solution for this. Its hard to say that the problem is machine specific because it works in other machines. Any help is highly appreciated.
ASKER
hi frodoman,
I have pasted the code below which calls the report.
This is a windows application developed in Powerbuilder with Oracle as the database. There is no difference that i can think of between the machines on which the report works. Although i'm looking at the versions of crpe32.dll on the machines that work fine. I copied this dll from a good machine into my machine and still get the same error. My machine has this problem and i have no problem to reach the database. I had mentioned that its not occuring on the production machines, but it looks like some production machines have this same problem.
Thanks for the reply frodoman. Any further help will highly appreciated.
-------------------------- ---------- ---------- ---------- ----------
LONG Error_Code
STRING Error_Message, ls_msgparm[]
unsignedlong msgHandle
int textLen
char charMsg
textLen = 100
PEStartPrintJob ( ai_job , true )
Error_Code = PEGetErrorCode(ai_job)
if Error_Code <> 0 Then
if PEGetErrorText( ai_job, msgHandle, textLen) = 1 Then
Error_Message = SPACE(100)
if PEGetHandleString (msgHandle,Error_Message,t extLen) = 1 Then
ls_msgparm[1] = 'The system is attempting to reconnect for access to this report. Click OK.' + &
'~r~nIf you still cannot access the report, please call the Help Desk.' + &
'~r~n(Error : ' + Trim(string(Error_Code)) + ' - ' + Trim(Error_Message) + ')'
gnv_app.inv_error.of_messa ge("9011", ls_msgparm )
end if
of_setlogoninfo(ai_job)
PEStartPrintJob ( ai_job , true )
end if
end if
return 0
I have pasted the code below which calls the report.
This is a windows application developed in Powerbuilder with Oracle as the database. There is no difference that i can think of between the machines on which the report works. Although i'm looking at the versions of crpe32.dll on the machines that work fine. I copied this dll from a good machine into my machine and still get the same error. My machine has this problem and i have no problem to reach the database. I had mentioned that its not occuring on the production machines, but it looks like some production machines have this same problem.
Thanks for the reply frodoman. Any further help will highly appreciated.
--------------------------
LONG Error_Code
STRING Error_Message, ls_msgparm[]
unsignedlong msgHandle
int textLen
char charMsg
textLen = 100
PEStartPrintJob ( ai_job , true )
Error_Code = PEGetErrorCode(ai_job)
if Error_Code <> 0 Then
if PEGetErrorText( ai_job, msgHandle, textLen) = 1 Then
Error_Message = SPACE(100)
if PEGetHandleString (msgHandle,Error_Message,t
ls_msgparm[1] = 'The system is attempting to reconnect for access to this report. Click OK.' + &
'~r~nIf you still cannot access the report, please call the Help Desk.' + &
'~r~n(Error : ' + Trim(string(Error_Code)) + ' - ' + Trim(Error_Message) + ')'
gnv_app.inv_error.of_messa
end if
of_setlogoninfo(ai_job)
PEStartPrintJob ( ai_job , true )
end if
end if
return 0
Sounds like it could be a dll issue. Make sure you don't have two dll's on the machine - check the win/system directory.
I'll keep looking but what I've seen so far relates mainly to dll problems.
frodoman
I'll keep looking but what I've seen so far relates mainly to dll problems.
frodoman
Hi shamin,
Take a look at these articles. These might be of help to you:
http://support.businessobjects.com/library/kbase/articles/c2004178.asp
http://support.businessobjects.com/library/kbase/articles/c2001521.asp
goodluck,
jrmn
Take a look at these articles. These might be of help to you:
http://support.businessobjects.com/library/kbase/articles/c2004178.asp
http://support.businessobjects.com/library/kbase/articles/c2001521.asp
goodluck,
jrmn
ASKER
Hi Jrmn,
Thanks for giving those links. I looked at the documents and it didn't help much.
Any other ideas.
Thanks for giving those links. I looked at the documents and it didn't help much.
Any other ideas.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Frodoman,
We are trying to find out about the dll's in the users machine at this time.
Thanks for the info. I will let you know.
We are trying to find out about the dll's in the users machine at this time.
Thanks for the info. I will let you know.
ASKER
Thank you all for helping. We figured out the problem. There was a dll mismatch.
Thanks
Shamin
Thanks
Shamin
frodoman