Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Data Connectivity
Message Icon Topic: Oracle connection/password issue Post Reply Post New Topic
Author Message
DCrum
Newbie
Newbie


Joined: 28 Apr 2011
Online Status: Offline
Posts: 4
Quote DCrum Replybullet Topic: Oracle connection/password issue
    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?
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
Quote hilfy Replybullet 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


Edited by hilfy - 28 Apr 2011 at 12:34pm
IP IP Logged
DCrum
Newbie
Newbie


Joined: 28 Apr 2011
Online Status: Offline
Posts: 4
Quote DCrum Replybullet 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?
IP IP Logged
CircleD
Senior Member
Senior Member
Avatar

Joined: 11 Mar 2011
Location: United States
Online Status: Offline
Posts: 251
Quote CircleD Replybullet 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.
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
Quote hilfy Replybullet 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
IP IP Logged
DCrum
Newbie
Newbie


Joined: 28 Apr 2011
Online Status: Offline
Posts: 4
Quote DCrum Replybullet Posted: 29 Apr 2011 at 6:10am
Thanks I will try that.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.047 seconds.