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.
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)
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
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!
Discuss This Question: 2  Replies