Store Log in Details in Crystal Reports

[alc25]

I am connecting to an Oracle Database, each time I run a report, it asks me for connection detail - username and password. How do I store these so it doesnt ask me each time?

 

[synapsevampire]

You don't, the intent is to abide by security. That's sort of like asking how you can store your login information in XP.

You can write a front end to do this, however it is ill advised.

-k

 

[alc25]

Ok, I understand, the reason I was asking is because I have added a Crystal Report into a VB application, when I try to refresh the report, I get an error, as though it cannot access the database (Oracle). Would I need to specify this login info in the VB code and how would I do so?

 

[vidru]

You need to supply the login info for the report through your code. The method varies depending on your:
a) version of CR
b) version of VB (6, .NET)
c) method of accessing the crystal print engine (OCX, RDC, .NET assemblies, etc.)
d) method of connectivity (ODBC, Native, etc.)

If you happen to be using VB6 with the RDC, have a look at this faq (faq768-5374), particularly the SetLogOnInfo method, which is used to set the... um... logon info.

-dave

 

[synapsevampire]

In addtition to Dave's suggestion, here's the sample applications:

http://support.businessobjects.com/fix/samplescr.asp

-k