Logon automation
Home > IT Answers > Development > Logon automation
Blowerycolumbus
10 pts.
0
Q:
Logon automation
Programming Languages, Oracle, Network connectivity, VB, Logon, ADO
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.
ASKED: Jan 4 2008  2:31 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mrdenny
47440 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
I don't beleive that the password is available as that would present a major security hole within the Windows operating system.
Last Answered: Feb 1 2008  2:27 AM GMT by Mrdenny   47440 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Xanader   395 pts.  |   Feb 1 2008  4:37PM GMT

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.  |   Feb 1 2008  4:40PM GMT

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

 
0