Hi,
You may have developed this report from one server ABC and
might you are accessing the database from any another Server XYZ.
So database mismatch error .
You also check in AR System ODBC Login, which is in Crystal report->File
->Log ON or Off Server->ODBC RDO->Make new Connection->Choose DSN Name
->Fill user name, click next-> AR System ODBC Login->Options->Check Use
Underscores
Hope this will help you.
Thanks,
Sandeep
--
[EMAIL PROTECTED]
www.vyomlabs.com
Consulting | Oursourcing | Training || BMC Remedy BSM | ITIL | IT Governance
Thad Esser wrote:
**
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.***
__20060125_______________________This posting was submitted with HTML
in it___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers
Are"
