<i><font color="#663300">The problem now is that first Oracle ODBC Driver Connect dialog. It seems pretty cheesy. What I would love to do is feed the Oracle ODBC Driver the userid and password from the CodeBook login. </font></i>
Yea, I agree. Unfortunatly in 6.0 there is no way to do this, without putting the userid and password in the DBC, which is not very secure.
What you can do though is eliminate your CB login screen. Open your initial view, the user will get the Oracle Login. If this is successful, get the user ID from Oracle and silently log them into your client side security system. This way they get only one login screen.
Also, you don't have to worry about the 'where do I store the user names and logins and how do I access them before the user has logged into Oracle?' So, now, Oracle is handling passwords and authentication for you.
BOb
©2002 Bob Archer |