Home > IT Answers > Development > Logon automation
blowerycolumbus
10 pts.
 Logon automation
ADO, Logon, Network connectivity, Oracle, Programming Languages, VB
I have several programs that where written in vb6 that are now required to be automated through a scheduler. It has been a while since I coded in vb6 and need to know a way to get access to the current logged on users credentials to pass on to a database loggon. the Oracle database is NOT set up to use windows authentication so I must use user name and password in a connection object within ADO. I know I can get the user through the scripting host object but how can I get the password to pass on? A code example would be most helpful. We do have active directory also.

Software/Hardware used:
ASKED: January 4, 2008  2:31 PM
UPDATED: February 1, 2008  4:39 PM
RELATED QUESTIONS
Answer Wiki:
I don't beleive that the password is available as that would present a major security hole within the Windows operating system.
Last Wiki Answer Submitted:  February 1, 2008  2:27 am  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Depending on what type of authentication/authorization your AD is using, you can pass the client’s kerboros ticket. You can get that through the scripting host too. google msdn for the code.

Another way would be to set up Single Sign On from either Oracle (10g) or Microsoft (BizTalk/SharePoint Server)

Xanader
 395 pts.
 

Sorry, just re-read your question, If Oracle isn’t configured to check auth through AD, then presenting a ticket won’t work.
You’ll need to set it up or go the SSO route

Xanader
 395 pts.