Print Page | Close Window

Oracle connection/password issue

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=13054
Printed Date: 23 Apr 2025 at 1:09pm


Topic: Oracle connection/password issue
Posted By: DCrum
Subject: Oracle connection/password issue
Date Posted: 28 Apr 2011 at 12:26pm
I am running Crytal Reports 2008 Ver. 12.3.0.601
 
When I establish a new DB connection to my Oracle 11g DB using the Oracle Server Data Source I provide the Service, UserID, an Password and the connection is successful.  However every time I open Crystal and attempt to expand the newly created Oracle connection it prompts me for the password.  I know with ODBC I can use a Connection String to pass the password on thru however how can I keep from getting prompted everytime with Native?


Replies:
Posted By: hilfy
Date Posted: 28 Apr 2011 at 12:33pm
You can't if you're running the report inside of Crystal itself.   And even if you use an ODBC connection, I believe that Crystal will still ask for a password.
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics

Posted By: DCrum
Date Posted: 28 Apr 2011 at 12:36pm
So when I publish this report to the Crystal Reports Server will it still prompt me for the password?

Posted By: CircleD
Date Posted: 28 Apr 2011 at 1:52pm
Originally posted by hilfy

You can't if you're running the report inside of Crystal itself.   And even if you use an ODBC connection, I believe that Crystal will still ask for a password.
 
-Dell



It does.


-------------

Posted By: hilfy
Date Posted: 29 Apr 2011 at 4:43am

After you publish the report, log in to the CMC and go to the report you just published.  Right-click on it and select "Database Configuration".  There you can set the password for the connection.  At the bottom of the screen under the "When viewing report:" options select "Use same database logon as when report is run".

-Dell

-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics

Posted By: DCrum
Date Posted: 29 Apr 2011 at 6:10am
Thanks I will try that.


Print Page | Close Window