Logon automation

10 pts.
Tags:
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.
ASKED: January 4, 2008  2:31 PM
UPDATED: February 1, 2008  4:39 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

I don’t beleive that the password is available as that would present a major security hole within the Windows operating system.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Xanader
    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)
    410 pointsBadges:
    report
  • Xanader
    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
    410 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following