Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Passing password parameter

Status
Not open for further replies.

jcl5

IS-IT--Management
Joined
Dec 6, 2002
Messages
89
Location
GB
I am using an Oracle 8i database with Crystal 9. How can I pass a default username and password into the report so that the user doesn't need to when running the reports.

Thanks

jcl5
 
Are you using ODBC Driver?

If yes, go to edit the ODBC configuration and for the user id section, key in username/password.

For example, the user id is mike and password is mike123, the valid input will be mike/mike123


Tim
 
Doesn't seem to accept it - do you just mean through Admin Tools - Data Sources or do you mean hard code it into a file or is it somewhere within Crystal?

Thanks
 
yes..go to Administrative Tools -> Data Sources (ODBC) and select the your desired configuration.

my fault that I didn't mentioned it very clear about the driver. I am using Oracle8 ODBC driver and it works just fine. However, I have tried CR Oracle8 driver, it seems like you cannot keyin the password.

You can try Orcale8 ODBC.

Tim
 
Is the Oracle driver safe to use in CR 9?

It wasn't with previous versions.

-k
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top