Solved

Crystal Reports Custom Control

Posted on 1997-05-27
2
208 Views
Last Modified: 2006-11-17
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?
0
Comment
Question by:msbs
2 Comments
 
LVL 3

Accepted Solution

by:
dansari earned 50 total points
ID: 1426590
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
 

Author Comment

by:msbs
ID: 1426591
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

Featured Post

ScreenConnect 6.0 Free Trial

Want empowering updates? You're in the right place! Discover new features in ScreenConnect 6.0, based on partner feedback, to keep you business operating smoothly and optimally (the way it should be). Explore all of the extras and enhancements for yourself!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I’ve seen a number of people looking for examples of how to access web services from VB6.  I’ve been using a test harness I built in VB6 (using many resources I found online) that I use for small projects to work out how to communicate with web serv…
Article by: Martin
Here are a few simple, working, games that you can use as-is or as the basis for your own games. Tic-Tac-Toe This is one of the simplest of all games.   The game allows for a choice of who goes first and keeps track of the number of wins for…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question