I don't know if this will help or not, but I ran across a KB article the other day that talks about how the user tool integrates with Crystal:
http://support.bmc.com/KMSUSER/DocView_SHFrame.htm?&d=/kmspublic/KM-000000006154.htm It says its for previous versions, but the basics should still apply. Trace through the process and you should be able to find where your issue is. Even if it doesn't help in your particular situation, I thought it was good background to know (one of the few useful KB articles). Thad Esser Remedy Developer "Argue for your limitations, and sure enough, they're yours."-- Richard Bach "Congo" <[EMAIL PROTECTED]> Sent by: "Action Request System discussion list(ARSList)" <[email protected]> 04/19/2007 06:56 AM Please respond to [email protected] To [email protected] cc Subject Crystal Reports connection Hi, Ive got an ActiveLink which opens a crystal report. But whatever the report contain I got a CR error: Failed to retrieve data from the database. Details [Database Vendor Code: 9021] I can see the raport in the Crystal Reports environment in a preview. The sql query generated from CR works if I run it against the database. In the ODBC configuration the Use underscores checkbox is checked as well as on User Preferences form. What more to check....? ARS 7.0.02 CR 9.2.2 regards _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ***IMPORTANT NOTICE: This communication, including any attachment, contains information that may be confidential or privileged, and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message is strictly prohibited. Nothing in this email, including any attachment, is intended to be a legally binding signature.*** _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
