Crystal Reports Custom Control

When loading my form, the Oracle Logon Popup screen connects
the user to the Database. However, to use Crystal Reports
through its custom control in my form, I have to provide a
connect string again. How can I set the .connect property of
the CR custom control to whatever userid and password has
been given by the user?
msbsAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

dansariCommented:
The Connect property should be set to an ODBC connect string - this string can contain the UserID and password.

Set it to something like:

ODBC;DSN=[Your data source];UID=[userID];PWD=[password];

You can provide a custom dialog to allow the user to logon to Oracle in your form's Form_Load event, then set the Connect property both of your form's data control and CR control to the above string (in Form_Load).


0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
msbsAuthor Commented:
Is there any alternative to this approach? I mean can we extract the UID & PWD from the default logon procedure of the ODBC driver?

Thanks.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.