Server Has Not Yet Been Opened (Crystal Report 8.5)

Experiencing this exception during deployment ? Even though it is working fine at the development machine.



Solution:

1. Open up Crystal Report 8.5
   
2. Goto "Database/Convert Database Driver".
   Reset the driver by selecting the dll file. If it is the correct dll file, select it again to reset it. If you are connecting to MS SQL Server, then the file should be pdsoledb.dll.
   
   
3. The next step is trickier, make sure you select only "Microsoft OLEDB Provider for SQL Server". Do not select "SQL Native Client" which will give you the "Server Has Not Been Opened" error.
   
   
4. Click "Next" and provide the proper connection parameters for your local data source. During deployment, remember to dynamically reset the parameters to the proper one using 'SetLogOnInfo'. Check out here for sample codes.
   
   
5. Remember to save the rpt file.
   
6. You are done. Test it out at deployment machine again
   

For your information, CR 8.5 is no longer available in the market and thus is no longer supported by Crystal Reports + Business Objects + SAP. Most of the cached links are no longer available :(

If this solution doesn't help it, check out here which talks about the other two common issues of Crystal Report 8.5 deployment.

• Unable To Find Database DLL
• Physical Database Not Found

Speaking from experience you should encounter these exceptions in the following order.

1. Unable To Find Database DLL
2. Physical Database Not Found
3. Server Has Not Yet Been Opened
   
   

You may also encounter another not so critical issues:

• CRViewer Export Button Not Working.
  Solution:-->Make sure these dlls are in c:\windows\system32 and it is registered (in the deployed machine)
  
  
  
  • u2dapp.dll
    
  • u2ddisk.dll
    
  • u2dmapi.dll
    
  • u2dnotes.dll
    
  • U2dpost.dll
    
  • U2dvim.dll
    
  • U2fcr.dll
    
  • U2fdif.dll
    
  • U2fhtml.dll
    
  • U2fodbc.dll
    
  • U2frdef.dll
    
  • U2frec.dll
    
  • U2frtf.dll
    
  • U2fsepv.dll
    
  • U2ftext.dll
    
  • U2fwks.dll
    
  • U2fwordw.dll
    
  • U2fxls.dll
    
  • exportmodeller.dll
  
  
• Printer selection option box is not available
  Solution:--> You have to create custom codes for it in your software application and link it with CRViewer.