Prompting for Userid/password

[pandy1]

Hi,
I created a crystal report(ver9,0)off oracle(9i) database. Everytime i run the report, the report is prompting for userid/password. Is there anyway i can enter once and avoid prompting userid/password everytime.

And also, i see the following 3 drivers with which i can create a DSN off oracle database. which one i need to use and which is recommended and what are the pros and cons of each?

CR Oracle ODBC driver 4.10
Microsoft ODBC for Oracle
Oracle ODBC driver

Thank you very much for your help.

Thanks in advance.

pandy

 

[synapsevampire]

I think that you might have one other choice in CR 9, and that's under More Data Sources->Oracle Server, which should prove to be the fastest.

The idea of embedding a user/id into a report goes against common wisdom in terms of security.

You can embed that information into external code, or use CE and embed it in there.

The Crystal ODBC driver has been the past thru version 8.5, other ODBC drivers might even return wrong data (decimal precision, etc.).

-k

 

[pandy1]

Thank you synapsevampire, i created a report using the choice you adviced ie., More Data Sources->Oracle Server, What is this actually? is this odbc or native driver? can you explain a little bit about this?

and also can we use CR ODBC driver in crystal 9 or not? and why? what are the disadvantages?

and also the other ODBC drivers are not advisable? why?

i could save userid and password when i create a dsn against sql server database which is not possible when i createa dsn against oracle database.

can you give a sample code to embed the user id and password in crystal report? I am not using CE.

Thanks in advance.
pandy

 

[Turkbear]

Hi,
The Oracle Server is a 'Native' Oracle driver meaning it uses SqlNet directly with no overlay of an ODBC layer..

AFAIK, you cannot hard code the username/password in CR running in standard Client/Server mode ( Oracle takes database security seriously).

Using the RDC in CR Developer will allow you to write code that does that, but that means writing the user interface as well.

 

[question911]

Use this as starting point to hard code user id and password for RDC/VB 6.0.

'Set Connection to logon to Oracle database server

crxApplication.LogOnServer "crdb_oracle.dll", "My Oracle Service Name", "", "turkbear", "mypassword