How to fix the Crystal error Message 599: Cannot find Sql Server ?

[akinia]

Hi everyone,

I'am a little bit in trouble. My report works fin under CR Vers 6.0.1.135. It retrieves data from Access and Oracle.
When I insert my report in the application which must use it to generate report, I obtain this message:
Crystal error Message 599 ":" (Cannot find Sql Server.&quot
I've heard to check LogonServer(), but I don't know how to do ? This windows appears when I run the report with CR, but doesn't with the other application.

If somme one have any Idea to help me I'll appreciate.

Thanks in advance.

 

[KPharm]

599 (or 20599) means that you simply aren't logging into the DB correctly. Unfortunately, the answer sometimes isn't easy. Are you using code to call the report? What language? If using VB, I had the same error until I finally got the right code to log into every table inside of the report:

For nTableCount = 1 To crystalReport.Database.Tables.Count
crystalReport.Database.Tables(nTableCount).SetLogOnInfo YourServerName, YourServerName, mConnection.UserID, mConnection.PASSWORD
Next nTableCount

(This is with an OLE report, so it will very.) If using ODBC, try:

Call crystalApplication.LogOnServer("P2SODBC.DLL", "Oracle 8", YourServerName, m_sUsername, m_sPassword)

Hope this helps